Understanding Excel Data Types

Learn how Excel stores data and the importance of selecting the right data type for your project.

• Practical aspects of Excel data types
• Common data type errors

Efficient Navigation, Data Entry & Data Manipulation

Master techniques for efficient navigation and data entry. Discover how to manipulate data using techniques such as sorting, filtering, and cell referencing.

• Efficient navigation
• Data entry techniques
• Data manipulation
• Using named ranges and fill handle

Data Conversion & Cleaning

Learn different ways to import, clean, and fix data from different sources using simple formulas.

• Data cleaning and conversion techniques
• Handling errors, duplicates, and non-uniform data
• Flash fill
• Text-to-columns functionality

How Formulas Work

Take a deeper look at how formulas work and when to use them, including an overview of available formulas and typical applications for them.

• Understanding formulas
• Solving real-world challenges

Solving Real-World Problems With Formulas

Discover how formulas can help to solve everyday problems in settings such as sales, human resources, and accounting.

• Using formulas effectively
• Advanced techniques
• Array formulas for data analysis

Efficient Data Search

Explore various approaches to searching for data and making Excel identify key values within large datasets through search operations.

• Data search best practices
• Find, replace, advanced filtering, and wildcards
• Highlighting using conditional formatting
• Lookup and conditional calculation functions

Workshop 1: Solving Real-World Problems

In this session, you will be able to bring your own real-world Excel problem and collaborate with your peers to find the best solution for it. The focus here is on daily work challenges rather than Excel features.

• Collaboratively addressing real-world challenges
• Implementing and validating Excel solutions

Stamping Out Errors: Data Validation & Automation

Learn how to ensure you are using spreadsheets effectively by applying data validation, error checking, formulas, and other tactics. Bring in time-saving automations for certain tasks.

• Data validation and error checking
• Automation with macros
• Handling errors in formulas
• Circular references

Building A Simple Interactive Dashboard

Discover what dashboards can do for your business function. Create a simple interactive dashboard (step-by-step build) to obtain instant insights from your data.

• Fundamentals and purpose of dashboards
• Basic data aggregation with pivot tables
• Creating interactive elements with basic slicers
• Incorporating charts
• Best practices in dashboard design

Improving Dashboards & Adding Graphics

Learn to build more advanced dashboards, combining them with charts and exploring best practices when creating graphics.

• Multi-dimensional analysis with pivot tables
• Enhancing interactive elements with advanced slicers and timelines
• Advanced charts and graphics for data visualisation
• Exploring dynamic dashboards and form controls

Using Artificial Intelligence (AI) With Excel

Understand how artificial Intelligence (AI) in Excel can help you take your spreadsheets to the next level. Solve a range of business pain points, from finding answers to making your spreadsheets smarter.

• An introduction to AI in Excel
• Leveraging AI for problem solving

Workshop 2: Enhancing Real-World Scenarios

In this final session, you'll be asked to bring further real-world challenges and collaboratively build solutions with your peers that include formulas, advanced dashboards, charts, and AI.

• Collaboratively resolve real-world Excel challenges
• Incorporate all the features learned
• Review of best practices in Excel