LEVEL 1: Microsoft Excel (Fundamentals) (2 days)

Objectives

The Level 1 Microsoft Excel (Fundamentals) course aims to provide participants with a foundational understanding of Excel’s fundamental features and functionalities. The primary objective is to equip participants with essential skills, enabling them to navigate the Excel interface, create and format spreadsheets, perform basic calculations, and utilize key tools for data analysis. This course focuses on building a solid Excel proficiency for beginners, laying the groundwork for more advanced data manipulation and analysis in subsequent levels.

Target Audience

The target audience for this Microsoft Excel Fundamentals – Level 1 course is beginners and individuals with little to no prior experience with Excel. It is ideal for office workers, students, administrative professionals, or anyone who needs to work with data and wants to gain a fundamental understanding of Excel’s basic functionalities.

Learning Outcomes 

• Navigate the Excel interface confidently and efficiently.
• Create, save, and manage spreadsheets and workbooks.
• Format data and cells to make the spreadsheet visually appealing and organized.
• Perform basic calculations using formulas and functions, such as addition, subtraction, multiplication, and division.
• Develop a solid foundation in Microsoft Excel, providing a basis for further learning and more advanced Excel courses.

Course Outlines:

Day 1:

Module 1: Introduction to Microsoft Excel

• Excel interface and navigation
• Working with workbooks and worksheets
• Basic data entry and editing techniques

Module 2: Formatting Data and Cells

• Applying font styles and formatting
• Adjusting cell alignments and indents
• Using borders and shading
• Formatting numbers and dates

Module 3: Basic Formulas and Functions

• Understanding cell references (relative and absolute)
• Performing arithmetic calculations
• Using SUM, AVERAGE, COUNT, and other essential functions
• Applying auto-fill and auto-series techniques

Module 4: Data Sorting and Filtering

• Sorting data in ascending and descending order
• Applying custom sorts based on specific criteria
• Using AutoFilter to filter data

Day 2:

Module 5: Working with Tables

• Creating and managing Excel tables
• Using table features for data organization and analysis
• Utilizing the “Total Row” feature to calculate summary statistics within the table
• Understanding the benefits of using structured references in formulas within tables

Module 6: Data Visualization with Charts

• Creating different chart types (column, bar, pie, line, etc.)
• Formatting and customizing charts for better visualization
• Applying chart elements like axis titles and chart titles for better context
• Modifying chart types and switching rows/columns for varied chart representations

Module 7: Conditional Formatting

• Applying conditional formatting to highlight data based on specific rules
• Using icon sets, data bars, and color scales
• Utilizing conditional formatting to identify duplicates or unique values in data
• Managing and clearing conditional formatting rules as needed

Module 8: Printing and Page Setup

• Previewing and adjusting print settings
• Page layout and print area settings
• Printing options for worksheets and workbooks

Join Today!