Introduction to Microsoft Excel is a comprehensive introductory course designed to equip learners with fundamental skills in Microsoft Excel. This hands-on course covers essential functionalities, including data entry, formatting, basic formulas, and simple functions. Through practical exercises and real-world examples, students will gain confidence in navigating Excel's interface and harnessing its powerful features to analyze data and streamline workflows.
Participants will learn to:
- Navigate workbooks and worksheets
- Enter and edit data
- Understand formulas and calculations
- Create and edit tables
- Create basic charts: bar, line, pie and formatting charts: titles, legends, axes
- Create a budget spreadsheet or data analysis project
- Use logical functions such as IF, AND, OR
- Use lookup functions such as VLOOKUP, HLOOKUP