Course ID: MEEKTT

Microsoft Excel: Essential Knowledge, Tips and Techniques to Guide CFOs

About & Customize

Popular Options

  • In-Person
  • Live Webcast

Upon completion of this course participants will be able to:
– Identify various techniques to optimize Excel’s setup for daily use
– Recognize and recall critical capabilities for using Excel in data analytics and how Excel “fits” into the data ecosystem
– Recall methods to “control the chaos” around Excel file maintenance and development, and identify two Lean Principles that can aid this effort
– Recall Excel automation techniques to accelerate workflow
– Recall other tips and techniques to improve Excel use of your team

In this course, we cover essential Microsoft Excel capabilities and techniques that will give any senior manager, likely not using Excel in depth like their team, the ability to evaluate and assess opportunities to perform more effectively. Studies have shown that many Excel users aren’t proficient in their use of Excel, which is being exacerbated by the continuous enhancements Microsoft is making to the software.

Topics covered include:
– What “modern” Excel means and why Excel 365 is the must have platform
– How to configure user setup of Excel for optimal productivity
– Artificial intelligence capabilities built into Excel and how to use them
– Important new functions introduced in Excel that make use far easier than before – including dynamic arrays, new lookup function, and data access
– Key data analysis concepts and tools important to know in Excel
– Productivity tips that not only benefit the user, but can benefit your entire team

After this session, participants will be armed with up to date knowledge of Excel to take back and move their teams skills and effectiveness forward!

Designed For

CFOs, Controllers and Senior Managers responsible for managing teams using Microsoft Excel in their workflow.

Field of Study
Computer Software & Applications
Prerequisites

Understanding of basic Excel use would be helpful. While some of the concepts covered are advanced in nature, the goal is understanding and awareness, not application of the tools and techniques.

Course Producer
Business Learning Institute
CPE Credits
2
Level
Basic
Available Formats
In-Person, Live Webcast
Types
Seminars

This course, like all courses in the BLI catalog, is customizable for your organization. Format, length, and content customizations are available.

To get started, contact BLI:
(888) 777-7077
team@blionline.org