Fundamentals of Excel

Setting rules and restrictions on data entry to ensure accuracy and consistency in spreadsheets.

Data Validation

An overview of the Excel interface, including navigating workbooks and worksheets, using the ribbon, and customizing options.

Introduction to Excel

Techniques for entering data accurately and efficiently, including using AutoFill and AutoComplete. Learn how to edit data within cells and navigate between cells.

Entering and Editing Data

How to format cells, including changing fonts, styles, and colors, as well as adjusting alignment and applying borders and shading.

Formatting Cells

Understanding basic formulas, such as SUM, AVERAGE, and COUNT, and using functions to perform calculations in Excel.

Creating Formulas and Functions

Manipulating rows and columns, including inserting, deleting, hiding, and resizing them to organize data effectively.

Working with Rows and Columns

Sorting data alphabetically or numerically, and filtering data to display only specific information based on criteria.

Sorting and Filtering Data

Creating visually appealing charts and graphs to represent data in a meaningful way, including bar graphs, pie charts, and line graphs.

Charts and Graphs

Applying conditional formatting to highlight important data trends, comparisons, or outliers within a range of cells.

Conditional Formatting

Using PivotTables to summarize, analyze, and present data in a dynamic and interactive format.