What you’ll learn

I. Introduction to Excel

• Excel interface overview
• Understanding the Ribbon and Quick Access Toolbar
• Basic Excel terminology (cells, rows, columns, etc.)
• Entering data and formulas
• Navigating worksheets and workbooks
• Saving and opening files

II. Basic Excel Functions

• Formatting cells (fonts, borders, shading)
• Autosum function
• Copying and pasting cells
• Basic arithmetic functions (addition, subtraction, multiplication, division)
• Basic statistical functions (average, median, mode, min, max)
• Absolute and relative cell references

III. Sorting and Filtering Data

• Sorting data by column
• Filtering data by column
• Using multiple criteria to filter data
• Advanced filtering techniques (e.g. filtering by date range)

IV. Removing Duplicates

• Identifying and selecting duplicate values
• Removing duplicate values using built-in Excel functions
• Using conditional formatting to highlight duplicate values

V. Lookup Functions

• VLOOKUP function
• HLOOKUP function
• INDEX and MATCH functions
• Using named ranges to improve the readability of formulas

VI. IF Function

• Understanding logical tests
• Writing IF statements
• Using nested IF statements
• Using IF with other functions like SUMIF and COUNTIF