- Â Course Objectives
Microsoft Excel 2016 Essentials
Microsoft Excel 2016 Essentials is a beginner-friendly course that introduces learners to the fundamental features of Excel. Whether you're a student, business user, or professional, this course will help you build confidence in using Excel for calculations, data entry, formatting, and basic analysis. Through hands-on practice, you'll create worksheets, use formulas, and present data in a clear and professional way.
INTRODUCTION
Module 1
-
Starting Excel and understanding the Ribbon
-
Exploring the workbook and worksheet layout
-
Customizing the Quick Access Toolbar
-
Opening, saving, and creating new files
Module 2
-
Entering and editing text and numbers
-
Selecting, copying, cutting, and pasting data
-
Inserting and deleting rows/columns
-
Using AutoFill and Flash Fill
Module 3
-
Adjusting row height and column width
-
Applying cell styles and themes
-
Using borders, colors, and fonts
-
Aligning and wrapping text
Module 4
-
Understanding cell references (relative/absolute)
-
Using SUM, AVERAGE, MIN, MAX, COUNT
-
Applying AutoSum and using the Formula Bar
-
Troubleshooting common formula errors
Module 5
-
Renaming, moving, and copying sheets
-
Grouping and hiding sheets
-
Navigating between sheets
-
Saving as different formats (PDF, CSV)
Module 6
-
Creating column, line, and pie charts
-
Editing chart titles, legends, and labels
-
Customizing chart colors and styles
-
Moving and resizing charts
Module 7
-
Sorting data alphabetically or by value
-
Applying filters to columns
-
Using multiple filters
-
Clearing and customizing filters
Module 8
-
Setting print area and print titles
-
Using Page Break Preview
-
Headers, footers, and page numbers
-
Scaling and fitting to print
Module 9
-
Starting with a template
-
Creating budgets, invoices, and calendars
-
Custom number formats
-
Tips for professional-looking spreadsheets
Module 10
-
Recap of core skills
-
Hands-on mini project (e.g., monthly budget sheet)
-
Self-assessment quiz or workbook
-
Preparing for advanced Excel topics
ASSESSMENT
- Course Objectives