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

Supply Chain Planning to the Rescue – Cash Flow Management During COVID-19

During the best of times, managing cash flow can be challenging. But during long-term disruptions such as COVID-19, cash flow management can become an existential exercise. As companies look to assess the damage from the pandemic, in order to define [...]

Demand Forecast Accuracy – A Better Way to Fight the Bullwhip Effect

Supply chain disruptions are nothing new. As 2020 continues to demonstrate, some disruptions can have a greater, catastrophic impact. But even small fluctuations can cause what is known as the “Bullwhip Effect”. This phenomenon occurs when demand signals are amplified [...]

5 Tips to Hacking Distribution Requirement Planning in the Food and Beverage Industry

The Food Waste Reduction Roadmap Report of 2019 show that a third of food, which includes beverages, is wasted around the world. Further analysis of the ongoing waste across the food and beverage production chain in the United Kingdom highlights [...]

Top 5 Production Capacity Planning Challenges You Should Know

Modern manufacturing is a complex endeavor for any company.  Equipment capability, labor and productivity must be balanced against demand, sales forecasts, supply chain issues and many other factors to produce the right volume at the right time. Too much and [...]

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 [...]
Subscribe to our Blog
Back To Top