Everyday Excel, Part 1

Welcome to Everyday Excel! This module serves as an introduction to the course, providing an overview of the Excel environment. Learners will delve into Excel's basic features, cell formatting, and editing techniques. The module emphasizes hands-on learning with in-application assignments, ensuring practical proficiency.

The "Expression Entry and Common Excel Functions" module focuses on Excel syntax, order of operations, and troubleshooting formulas. Learners will gain proficiency in common Excel functions, such as counting, summing, and averaging, along with rounding, remainders, and random number generation. Hands-on assignments reinforce practical application.

The "More Excel Functions" module delves into advanced logical functions, text functions, financial functions, and array formulas. Learners will explore the dynamic application of named ranges, IF, AND, and OR functions, as well as Flash Fill and VBA user-defined functions. Practical assignments ensure a comprehensive understanding of advanced Excel functions.

In the "Managing Data" module, learners will master data management techniques, including filtering, sorting, data validation, removing duplicates, and consolidating data. The module introduces one-way lookup functions, Excel Tables, and the XLOOKUP function. Hands-on assignments provide practical proficiency in data management.

The "Plotting, Importing Data, and Converting to Other File Types" module focuses on data visualization, covering scatter plots, column and pie charts, Pivot Tables, Slicers, and Sparklines. Learners will explore the practical application of dynamic charts, data import, and file conversion. Hands-on assignments ensure a comprehensive understanding of data visualization techniques.