Microsoft Excel Beginner Training

Microsoft Excel Fundamentals

Beginner Excel Overview

Ready to start building your Excel skills from the ground up? This beginner Excel training course provides the foundation you need to grow your knowledge and become an expert in data manipulation over time. You'll learn how to create and format worksheets, perform basic calculation operations, work with charts and tables, and organize data efficiently.

This course also covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201.

Master the basics—and open the door to more advanced skills in data analysis, reporting, data visualization, and spreadsheet management.

Course Objectives

In this Excel for beginners course, you’ll learn how to create and format spreadsheets, apply Excel formulas and Excel functions, design and modify Excel charts, and organize information into structured tables and worksheets. You’ll develop the confidence to use Excel like a pro, streamline everyday tasks, and set a strong foundation for advanced tips and future certifications

Course Prerequisites

• Basic computer literacy
• Basic PC operating system navigation skills
• Basic Internet usage skills

Beginner Excel Agenda

1 – Getting Started with Excel

• Navigate the Excel user interface and organize your workspace efficiently
• Use Excel commands and features, and locate tools with shortcut keys
• Create and save a basic workbook
• Access and use Excel Online for cloud-based collaboration
• Enter and edit data entry efficiently in worksheets
• Find help and support through built-in tools and Microsoft Support resources

2 – Performing Calculations

• Build Excel formulas to perform calculations quickly
• Insert and manage Excel functions like SUM, AVERAGE, and logical operators
• Reuse and copy formulas and functions using step-by-step techniques

3 – Modifying a Worksheet

• Insert, delete, and adjust cells, columns, and rows
• Search for and replace data, and use filter tools for data management
• Use proofing and research tools to ensure accuracy

4 – Formatting a Worksheet

• Apply text and number formatting, including borders and shading for visual emphasis
• Align, arrange, and organize worksheet content
• Apply colors, borders, and predefined styles for professional spreadsheets
• Apply basic conditional formatting to highlight trends
• Create and use templates to streamline repetitive tasks

5 – Printing Workbooks

• Preview and print worksheets with correct page layout settings
• Configure headers and footers to provide context in printed sheets
• Customize your sheet layout for clean presentation

6 – Managing Workbooks

• Manage multiple sheets and workbooks efficiently
• Update workbook properties to maintain organized files
• Manage workbook and worksheet views for better navigation

This course is offered Online