Microsoft Excel (MOS Excel Associate / Expert)

Objective: To master organizing and analyzing data and creating graphs.

Excel Basics:
Create, open, and save workbooks.
User interface (cells, sheets, ribbon).
Data entry (text, numbers, dates).
Manage cells and sheets:
Copy, cut, and paste data (with special paste options).
Format cells (numbers, dates, currency).
Manage sheets (add, delete, rename).

Basic Formulas and Functions:
Creating simple formulas (addition, subtraction, multiplication, division).
Using common functions (SUM, AVERAGE, MIN, MAX, COUNT).
Relative, absolute, and mixed references.
Data Analysis:
Sort and Filter.
Conditional Formatting.
Data Validation.

Charts:
Create different types of charts (bar, pie, line).
Format and customize charts.
Advanced features (Expert level):
Logical functions (IF, AND, OR).
Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP).
Work with large spreadsheets (PivotTables & PivotCharts).
Analyze data using What-If Analysis.
Collaborate on and protect workbooks.
Create simple macros using the Recorder.