Tel:020 7920 9500

Microsoft Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction..

For more demanding uses, Excel can be used to create charts, Analyse Data, used as a data repository and of course keep track of your accounts.

How to Use Excel for Your Daily Tasks: A Beginner’s Guide

Benefit From our Smart Training

Excel Introduction Training Course Overview

Our Excel Introduction Training Course ideal for complete novices or those who have basic knowledge of Microsoft Excel.

This Excel course equips participants with fundamental spreadsheet skills.

Master essential formatting: Customize cells, adjust appearances, and enhance data presentation.
Navigate with ease: Explore multiple worksheets, manage rows and columns effectively, and efficiently move and copy data within and across sheets.
Visualize data: Create basic charts to effectively communicate insights.
Optimize printing: Learn to print effectively and efficiently.

By the end of the course, participants will have a strong foundation in Excel, enabling them to confidently apply their skills to real-world scenarios and significantly improve their spreadsheet proficiency.

Excel Introduction Training Course Details

Course Location : Face to face group / Online & Onsite training available.

Class Size : As a guide we recommend class sizes to be no more than six.

Virtual / Online training Format : Teams or Zoom.

Tailored Course Content : Our Excel Introduction Training Course can be tailored to your requirements online or Onsite

Course Outline:

Module 1: Introduction to Excel

What is Excel and its uses?
The Excel interface:
- Ribbon, tabs, groups
- Workbooks, worksheets, cells, rows, and columns
Basic navigation:
- Selecting cells, ranges, and entire sheets
- Using scroll bars and the navigation bar
Data entry:
- Entering text, numbers, dates, and times
- Autofill and its uses

Module 2: Data Formatting

Cell formatting:
- Number formats (currency, percentages, dates)
- Font styles, colors, and alignments
- Cell borders and shading
Conditional formatting:
- Applying rules to highlight data (e.g., highlighting cells based on value)

Module 3: Formulas and Functions

Basic formulas:
- Addition, subtraction, multiplication, division
- Order of operations
Common functions:
- SUM, AVERAGE, MAX, MIN
- COUNT, COUNTA
Working with cell references:
- Relative, absolute, and mixed references

Module 4: Working with Data

Sorting and filtering data:
- Sorting data in ascending/descending order
- Filtering data based on criteria
Inserting and deleting rows and columns
Copying and pasting data:
- Basic copy and paste
- Paste Special options (values, formulas, formats)

Module 5: Charts and Data Visualization

Creating basic charts:
- Column charts, bar charts, pie charts, line charts
- Chart elements (titles, legends, labels)
- Customizing chart appearance

Module 6: Printing

Page setup:
- Setting print area, margins, and orientation
- Printing multiple pages
Previewing and printing worksheets

Hands-on Exercises and Projects:

Throughout the course, incorporate hands-on exercises and practical projects to reinforce learning.
Examples:
- Creating a simple budget spreadsheet.
- Analyzing sales data and creating a sales report.
- Tracking student grades.
Note:
- This is a basic outline and can be customized based on the specific needs and learning objectives of the target audience.
- Remember We will adapt the course to your specific requirements and the level of your learners.
- We Provide ample time for questions and discussions.
This outline provides a solid foundation for an introductory Excel course.

Online or Your Venue

Our instructors are very approachable, making the dryest subject matter fun.