 |
$395
|
1 Day
Group discounts available |
|
 |
Times |
9:00am - 4:30pm |
|
 |
Reference |
Hosted manual included or
Purchase printed book |
|
 |
Certificate |
Attendance or Completion
upon assessment |
|
 |
Classroom |
Upon request |
|
 |
Live Online
|
Hands-on, Live Instructor
Dedicated VILT Platform |
|
 |
On Site |
Get a Quote |
|
Excel Essentials Course
4.75 (12,580 reviews)
Brochure
Do you need to get up to speed with the basics in Excel? This course is designed for people who are new to spreadsheets or who have little experience with Microsoft Excel. Develop your skills and confidence by learning from experienced Excel certified instructors who will
work with you at your pace
make sure you are not overwhelmed and
give you handy tips on best practice and spreadsheet design.
This course covers the basic day to day tasks required to work with an Excel spreadsheet to produce basic reports. You will learn how to use a variety of Excel tools including working with data, formulas and functions, create and setup reports for print, and represent data with charts.
Courses are conducted on Excel 365, Excel 2019, Excel 2016 and Excel 2013. Just choose the version when booking.
Course Details
Proficiency in Microsoft Excel is a highly beneficial in many business roles. This introductory Excel course will equip you with the knowledge of Excel to organise, analyse and work with data. You will develop essential Excel skills to
gain the confidence to navigate the Excel interface
produce formatted spreadsheets
master essential spreadsheet functions, perform calculations
produce creative charts from your data
build an aptitude for data analysis
Audience:
The course has been designed for new users of Microsoft Excel.
Prerequisites:
Participants must have basic keyboard and mouse skills and be familiar with the Windows operating system.
Course Content
Getting Started with Excel
- Overview & Excel Screen
- Title Bar
- Ribbon and Ribbon Tabs
- Name Box and Formula Bar
- Worksheets
- Selecting Cells
- Using Ranges
- Entering Data into the Worksheet
- Data Entry Techniques
- Entering a Formula
- AutoSum
- Managing your Workbook
Editing Data
- Editing the Contents of a Cell
- Find & Replace
- Editing a Formula
- Inserting Columns, Rows and Cells
- Copying and Moving Data
- Fill and Flash Fill
- Drag and Drop Editing
- Copying Formatting
- Clearing Format
Formulas and Functions
- Relative Formulas
- Absolute References
- Using Basic Functions
- Status Bar Calculations
- Using the Function Button
Preparing for Print
- Fine Tuning for Print
- Page Layout View
- Page Setup Options
- Print Preview
- Controlling Page Breaks
- Page Break Preview
- Printing a Worksheet
- Print Title
Charting
- Types of Charts
- Choosing the Source Data
- Category and Value Axis
- Working with Charts
- Chart Tools
- Moving and Sizing Embedded Charts
- Creating a Pie Chart
- Charting Non-Consecutive Data
- Changing the Axis Plot Order
- Layout Tools
- Printing a Chart Themes & Graphics
Themes & Graphics
- Themes and Styles
- Adding a Picture or Graphic
- Formatting Graphic
Spreadsheet Design
- Good Design
- Analyse a spreadsheet
- Design Principles
- Planning Checklist for Spreadsheets
- Microsoft Tips for Optimising Speed
- Design Project
Available Dates
Available Excel Essentials courses
|
Event |
Event Date |
Location |
Individual Price |
Register |
|
Excel Essentials |
30-05-2022 |
Live Online |
$395.00 |
|
|
Excel Essentials |
20-06-2022 |
Live Online |
$395.00 |
|
|
Excel Essentials |
12-07-2022 |
Live Online |
$395.00 |
|
|
Excel Essentials |
03-08-2022 |
Live Online |
$395.00 |
|
|
Excel Essentials |
25-08-2022 |
Live Online |
$395.00 |
|
|
Excel Essentials |
07-09-2022 |
Live Online |
$395.00 |
|
|
Excel Essentials |
27-09-2022 |
Live Online |
$395.00 |
|
|
Excel Essentials |
10-10-2022 |
Live Online |
$395.00 |
|
|
Excel Essentials |
01-11-2022 |
Live Online |
$395.00 |
|
|
Excel Essentials |
23-11-2022 |
Live Online |
$395.00 |
|
|
Excel Essentials |
15-12-2022 |
Live Online |
$395.00 |
|
