| Public Courses | |||
 |
$440 | 1 Day Group discounts available |
|
 |
Times | 9:00am - 4:30pm | |
 |
Reference | Hosted manual included or Purchase printed book |
|
 |
Certificate | Attendance or Completion upon assessment |
|
 |
Live Online |
Hands-on, Live Instructor Dedicated Training Platform |
|
| Private Courses | |||
 |
Classroom | Group Training (hired room) Get a Quote |
|
 |
In House | On your 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.
Suitable for users of Excel 365 and earlier Excel desktop versions. Choose the version when booking to let us know which version you are using.
Course Details
What you will learn:
Proficiency in Microsoft Excel is a highly beneficial for 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 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