About the Course
Microsoft Excel Fundamentals is designed to teach participants the core usage of Excel. The course covers everyday essentials such as basic formulas, table creation, and data organization. It is suitable for anyone who wants to use Excel more effectively and productively.
Target Audience
Beginners with little or no prior Excel experience
Office professionals and new hires
Students and recent graduates
Business owners and entrepreneurs
Learning Outcomes
Master the core Excel interface and workbook structure
Use basic formulas and functions effectively
Perform data entry, table creation, and formatting tasks
Sort and filter datasets accurately
Use Excel more productively and accurately in daily business workflows
Curriculum
Module 1 – Introduction
Excel Interface
Using the File Menu
Using the Help Menu (Tell Me What You Want to Do)
Using the Quick Access Toolbar
Customizing the Quick Access Toolbar
Module 2 – Formatting
Using the Home Tab
Font, Date, and Number Formatting
Defining Custom Number Formats
Working with Dates and Date Settings
Formatting Excel Tables
Find, Replace, and Go To Special
Module 3 – Worksheets
Inserting and Deleting Cells, Columns, and Rows
Moving and Copying Worksheets Within a Workbook
Adding and Deleting Worksheets
Moving and Copying Worksheets Between Workbooks
Creating Custom Lists
Flash Fill
Module 4 – Printing Workbooks
Using Workbook Views
Using Scaling Settings
Adjusting Page Margins
Printing Titles
Setting the Print Area
Header and Footer Options
Using Page Layout View
Inserting, Showing, and Deleting Comments
Printing Comments
Module 5 – Working with Worksheets
Splitting, Hiding, and Unhiding Worksheets
Freezing Rows and Columns
Module 6 – Conditional Formatting
Applying Conditional Formatting to Text, Numbers, and Dates
Working with Data Bars, Color Scales, and Icon Sets
Module 7 – Charts
Creating Charts
Using Recommended Charts
Adding and Removing Chart Data
Using Chart Formatting Options
Creating Trend Charts
Using Sparklines
Module 8 – Using Excel Formulas
Building Formulas
Performing Calculations with Functions
Copying Formulas and Functions
Using Absolute References
Module 9 – Tips and Tricks
Keyboard Shortcuts
Practical Methods for Functions and Data Analysis
Other Courses in This Category
-
Intermediate Excel
Intermediate Microsoft Excel training covering table management, advanced sorting and filtering, conditional formatting, VLOOKUP/HLOOKUP, and conditional functions (SUMIF, AVERAGEIF, COUNTIF).
- Live Course
- 10 modules
-
Advanced Excel
Advanced Microsoft Excel training covering XLOOKUP, INDEX/MATCH, SUMIFS, database functions, data validation, PivotTables and PivotCharts, workbook security, and recorded macros.
- Live Course
- 8 modules
-
Basic MS Project
Foundational Microsoft Project training covering project scheduling, Work Breakdown Structure (WBS), task dependencies (FS, SS, FF), resource assignment, and Gantt Chart tracking.
- Live Course
- 8 modules
-
Advanced MS Project
Advanced Microsoft Project training covering Critical Path analysis, resource leveling, cost and budget variance tracking, and Earned Value (EV, PV, AC) performance analysis.
- Live Course
- 8 modules
-
Excel VBA Training
Automate Microsoft Excel with VBA: macro recording, Excel Object Model programming, custom functions, interactive UserForms, error handling, and Access/SQL Server integration.
- Live Course
- 9 modules
-
Excel Expert Level
Expert-level Microsoft Excel training covering array formulas, XLOOKUP, INDEX/MATCH, advanced PivotTables, Goal Seek, Solver, What-If Analysis, form controls, and Power Query.
- Live Course
- 8 modules
Get in touch
