skip to Main Content

The 7 essential Excel tricks every Excel user needs to know

Best Practices  
10/21/2015

Here at DemandCaster, we use Excel every day. In fact, the original version of DemandCaster was built using Excel and a number of advanced Excel tricks. All DemandCaster reports are defaulted to output as Excel and Excel can be used to easily prepare and then upload user defined forecasts and other updates as tab delimited text files.

Our custom report configurator is also Excel friendly. Using the custom reports, users can prepare and upload pre-formatted excel templates that include graphs, tables, and other excel tricks and functions. Each time the custom report is run, the template is refreshed with the latest data allowing DemandCaster to be a comprehensive business intelligence reporting system that is tailored to meet the needs of your company. We even added the functionality to load additional data sets into the DemandCaster database beyond it's required data.

With this in mind, we recently discovered and would like to share a neat infographic from Microsoft Training that provides a list of the Seven Essential Excel Tricks every Office Worker needs to know. We hope you can use these tricks to build your own custom templates or improve your analysis of the data generated by DemandCaster. We realize that not all our customers are Excel savvy, so as we discover these tips and tricks, we will post them to this blog under the Reporting category.

Now that you have read the infographic, here are three video's that we have posted on our YouTube page that provides a more detailed description of how to use Excel to create a custom filtered report.

Related Articles

Best Practices for Resource Capacity Planning for Small and Medium Businesses

Manufacturing can be challenging in the best of conditions.  But for small and medium-sized businesses (SMBs) striving to remain competitive with large companies, their smaller size and reach mean that planning is even more crucial.   Small and medium-sized businesses often [...]

Strategies for Optimizing Customer Service Levels

  While every business works diligently to improve efficiency and operational excellence, at the end of the day it’s the customer who determines a company’s success.  And companies are looking for new ways to optimize customer service levels to improve [...]

Going Green in Supply Chain

Can supply chain professionals help their business become more sustainable? Absolutely! You will be helping the environment, but going green can also help your business with brand building and efficiency. It can even be as simple as moving to the [...]

Computational thinking in today’s industry

Industry Week defines computational thinking as, “A structured approach to problem-solving, which ultimately allows you to come up with a solution that can be effectively carried out by computers, people, or—typically—a combination of both.” This is a great tool when [...]

A Focus on the Eighth Lean Waste in Manufacturing

There were originally seven wastes of lean manufacturing, but an eighth was added in the 1990s that should not be ignored! Dave Turbide said, “Variously called unused human creativity, under-utilized talent, incorrect use of abilities, unused human intellect, or simply [...]

The Life of a Demand Planner

What do the first 100 days look like for the average demand planner? What trends does a demand planner hope to establish when embarking on this new journey? Much like POTUS, you can’t go it alone -- you need your [...]

5 Most Common Mistakes Made in Sales Forecasting

Selling anything, from widgets to wide-load trucks, isn’t an exact science. There are fluctuations in demand, in supply of raw materials, in shipping and more. That said, getting as close to reality as possible in sales forecasting is how you [...]

Manufacturing Performance Metrics for Producing Products

Delivering goods and products begins with raw materials, which vary widely by industry and manufacturing process. No matter the industry, however, all inventory must be sourced and managed. The most effective way to do so is by measuring inventory turnover. [...]

Awareness And Knowledge Arise From Demand Planning Basics of Cross-Functional Alignment

Supply Chain, finance, commercial, marketing, and any other department that can impact sales volume, are all integral parts of a business. When it comes to the awareness, knowledge and alignment, cross-functional collaboration best practices are key to seeing both opportunities [...]

How are Millennials Affecting the Supply Chain?

Millennials want more than a good price. They want availability, speed and convenience. More than that, they want to be included in the actual co-creation of the product. To millennials, it's about the experience. Enter "experiential supply chain." At the [...]
Subscribe to our Blog
Back To Top