Level 1: Microsoft Excel (Fundamental)

Objectives
Microsoft Excel is a powerful spreadsheet software used to organize, analyze, and present data efficiently. This one-day course is designed for beginners and aims to provide participants with a strong foundation in using Excel for everyday tasks. By the end of the course, participants will be able to create, format, and manipulate spreadsheets, perform basic calculations, and gain a good understanding of Excel’s essential features.

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 Outline:
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!