Microsoft Excel Essentials
Overview
This course introduces you to the power of Microsoft Excel, starting from the beginning this course will go thorugh the most important features of Excel that you will need for daily use. Although it starts from the beginning, so it is suitable for Excel beginners, it will bring you to a very good working knowledge of Excel with many tips and tricks to make it a great revision course for existing Excel users, focusing in on the newest features in Excel that make it more efficient to work with, inclusing Excel’s new AI integration.
Course Objectives
By the end of this Excel Essentials course, you’ll have a strong grasp of Excel’s core functionalities. You’ll be adept at creating, formatting, and managing everyday spreadsheets, utilizing features like formulas and tables to enhance your daily Excel tasks.
See also
Look at our Excel Master programme which includes Data Analysis, Power BI and VBA Courses. We also have a Data Analytics Master programme.
Content
Introduction & Navigation
- Looking at the Interface
- Moving Through Cells & Sheets
- Selecting A Range Of Cells
Basics
- Inserting, Renaming And Deleting Worksheets
- Entering data
- Editing Cell Content
Formatting
- Formatting data in cells
- Applying Cells Borders
- Changing Alignments, Font Size, Type And Colour
- Merge And Wrap Features
- Hide/Show columns and rows
- Formatting text
- Formatting dates and numbers
Basic Formulae
- Simple Calculations Using Operators
Protection
- Protecting sheets
- Protecting workbooks
Page Setup
- Headers & Footers
- Printer Setup
Using Functions
- Simple Daily Functions: SUM, AVERAGE
- Daily functions: COUNT, MAX, MIN
- Formulas across 2 separate sheets
- Absolute referencing
- Name a cell/range
- Name Manager
- Using Named cells/ranges in formula
Find and Select Options
- Find a value
- Select/Replace
- Find a Special value
Lists
- Sort data
- Filter data
- Remove duplicates
- Freeze panes
Introduction to Tables
- Converting ranges into Tables
- Table Options
- Using Sorts and Filters in Tables
- Total Row
AI in Excel
- Using the Analyse Data Pane
- Show data results quickly and easily
Course summary video
You will learn how to
- Open, save and close workbooks
- Work with multiple sheets
- Enter and edit data in cells
- Change format types of cells
- Create simple formula using operators and cell references
- Create more advanced formula using daily functions such as SUM
- Work with long lists of data with sort and filter features
- Create and work with Tables
- … and much more
Audience
A little knowledge of Excel would be beneficial, but Excel beginners can attend if they are already using other Microsoft applications.
If you are a complete beginner to Excel and have little knowledge of the Microsoft Office applications in general, contact us and we will tell you about our Foundations courses.
Classroom and Virtual training options
Online Course Materials
Duration
2 Day or 4 x 3 Hour Sessions
Contact Us
We’ll reply quickly.
Enquiry
I understand that my personal data is being processed in accordance with the privacy notice and accept the terms and conditions of use.