Microsoft Excel

Course Title: Introduction to Microsoft Excel for Beginners

Course Duration: 3 Weeks (15 Hours)

Course Format: Online Live Training

Next Start Date: TBC

Master Microsoft Excel with our introductory online course tailored for beginners. Learn essential functions, formulas, and techniques to efficiently organize and analyze data. From creating spreadsheets to utilizing charts and graphs, this course will equip you with the fundamental skills needed to excel in Excel.

https://www.microsoft.com/en-gb/microsoft-365/excel

Course Structure

Module 1: Getting Started with Excel

• Lesson 1.1: Introduction to Excel and Basic Navigation

  • Overview of Microsoft Excel and its interface

  • Navigating through Excel (ribbon, workbook, worksheet)

  • Understanding cells, rows, columns, and worksheets

• Lesson 1.2: Basic Data Entry and Formatting

  • Entering data into cells

  • Editing, copying, cutting, and pasting data

  • Basic formatting (font, cell color, borders, alignment)

• Lesson 1.3: Working with Worksheets and Workbooks

  • Creating, renaming, and deleting worksheets

  • Saving, opening, and closing workbooks

  • Managing worksheet tabs and moving between them

  
  

Module 2: Basic Formulas and Functions

• Lesson 2.1: Introduction to Formulas

  • What are formulas in Excel?

  • Creating simple formulas (addition, subtraction, multiplication, division)

  • Understanding cell references (relative, absolute, mixed)

• Lesson 2.2: Common Excel Functions

  • Introduction to functions in Excel

  • Using basic functions like SUM, AVERAGE, MIN, MAX, COUNT

  • Combining functions and formulas

• Lesson 2.3: Working with Dates and Text Functions

  • Date functions (TODAY, NOW, DATEDIF)

  • Simple text functions (LEFT, RIGHT, CONCATENATE, LEN)

Module 3: Data Management and Visualization

• Lesson 3.1: Sorting and Filtering Data

  • Sorting data in ascending/descending order

  • Using filters to display specific data

  • Custom filtering

• Lesson 3.2: Working with Tables

  • Converting data ranges into tables

  • Table formatting options

  • Using structured references in tables

• Lesson 3.3: Introduction to Charts and Graphs

  • Creating simple charts (bar, pie, line)

  • Customizing chart elements (titles, labels, legends)

  • Choosing the right chart for your data

Module 4: Intermediate Excel Features

• Lesson 4.1: Introduction to Conditional Formatting

  • Applying conditional formatting rules

  • Using color scales, data bars, and icon sets

  • Creating custom rules for conditional formatting

• Lesson 4.2: Working with Data Validation and Protection

  • Setting data validation rules (restricting data entry)

  • Creating drop-down lists

  • Protecting worksheets and workbooks (password protection)

• Lesson 4.3: Introduction to PivotTables

  • Understanding PivotTables and their purpose

  • Creating a simple PivotTable

  • Using PivotTable features to summarize data

Learning Objectives

By completing each module, students will achieve the following:

Module 1: Getting Started with Excel

• Understand the purpose and functionality of Microsoft Excel.

• Navigate through the Excel interface, including worksheets, the ribbon, and toolbars.

• Perform basic data entry and apply simple formatting options to cells and ranges.

  
  

Module 2: Basic Formulas and Functions

• Use simple arithmetic formulas to perform calculations in Excel.

• Apply common functions like SUM, AVERAGE, and COUNT to analyze data.

• Use date and text functions to work with specific data types.

  
  

Module 3: Data Management and Visualization

• Sort and filter data to view and analyze subsets of information.

• Create and format Excel tables to organize and manage data efficiently.

• Build basic charts to visualize data and communicate insights.

  
  

Module 4: Intermediate Excel Features

• Apply conditional formatting to visually highlight important data.

• Use data validation to control and restrict user input.

• Build simple PivotTables to summarize large datasets and extract key insights.

Learning Outcomes

By the end of this course, students will be able to:

• Navigate the Microsoft Excel interface, manage worksheets and workbooks, and perform basic data entry.

• Use simple formulas and functions to perform calculations and manipulate data effectively.

• Sort, filter, and visualize data through tables and charts to present clear and organized reports.

• Apply intermediate Excel features like conditional formatting, data validation, and protection to enhance the functionality and usability of spreadsheets.

• Create basic PivotTables to summarize and analyze data efficiently.

Register Now