Basic Excel Training Course

Share this course

Duration

2 Days

Course Overview

This course is designed for beginners who want to develop foundational skills in Microsoft Excel. Participants will learn how to navigate the Excel interface, enter and format data, perform basic calculations, and create simple charts and tables. Hands-on exercises will ensure practical application of concepts, making participants confident in handling everyday Excel tasks.

Format of Training

  • Instructor-led interactive sessions
  • Hands-on lab exercises
  • Practical demonstrations
  • Real-world examples

Course Objectives

  1. Navigate the Excel interface and understand basic functions.
  2. Enter, format, and manipulate data effectively.
  3. Perform basic calculations using formulas and functions.
  4. Create and modify simple charts for data visualization.
  5. Use sorting and filtering to organize data.
  6. Apply basic conditional formatting for better readability.
  7. Save, print, and share Excel files efficiently.

Prerequisites

Course Outline

Day 1

Session 1: Introduction to Excel

  • Understanding the Excel interface and ribbon
  • Creating, opening, and saving workbooks
  • Basic data entry and navigation shortcuts

Session 2: Formatting and Organizing Data

  • Adjusting column width and row height
  • Applying basic formatting (fonts, colors, alignment)
  • Using cell styles and themes

Session 3: Basic Formulas and Functions

  • Introduction to formulas and cell references
  • Common functions: SUM, AVERAGE, MIN, MAX
  • Copying and pasting formulas (relative vs. absolute references)

 

Day 2

Session 1: Sorting, Filtering, and Tables

  • Sorting data in ascending and descending order
  • Applying filters to extract specific data
  • Creating and formatting simple tables

Session 2: Introduction to Charts and Graphs

  • Creating bar, column, and pie charts
  • Customizing chart elements (titles, legends, labels)
  • Selecting the right chart for data visualization

Session 3: Printing, Sharing, and File Management

  • Page layout and print settings
  • Saving files in different formats (PDF, CSV)
  • Sharing workbooks and basic collaboration features
Team reviewing charts and documents together around a meeting table

Bespoke Option

We are open to customizing this program to align with your specific learning objectives. If your team has particular goals or areas they wish to focus on, we would be happy to tailor the course outline to meet those needs and ensure the program supports the achievement of your desired outcomes.

Need help with the right course to choose?

support@skillvotech.com

Explore more opportunities

Advanced Excel for Data Analysis and Reporting Training Course

Basic Excel Training Course

Intermediate Excel Training Course

Mastering PowerPoint for Professional Presentations Training Course

Microsoft Word for Documentation and Formatting Training Course

Microsoft Outlook for Productivity and Email Management Training Course

Basic Excel Training Course