EasyPC Training provides public Microsoft Excel training courses in Gladstone Queensland, from beginners to advanced, using Microsoft Excel 2019.
Create spreadsheets to collect, analyse, share and manage information to make the most informed decisions.
Microsoft Excel Training Courses available
Choose from our standard Microsoft Excel training courses:
- Microsoft Excel Essentials
- Microsoft Excel Intermediate
- Microsoft Excel Advanced
- Basic computer experience, including keyboard and mouse skills
- Familiarity with Microsoft Windows
- If you are not familiar with using a computer or Microsoft Windows, the Introduction to computers course will give you the skills to take this Excel course.
- Create, Save and Close Workbooks
- Change Worksheet Views
- Enter, Copy and Edit Data
- Custom Lists
- Insert & Delete Rows & Columns
- Hide & Unhide Rows & Columns
- Group Data
- Use Find and Replace
- Formulas, Functions & Linking Data
- Insert, Name & Delete Worksheets
- Move and Copy Worksheets
- Apply Font Formatting
- Apply Alignment & Number Formatting
- Column Widths & Row Heights
- Apply Built-in Formatting
- Customise and Create Charts
- Sort and Filter Data
- Protect Data
- Printing Worksheets
- Basic experience in using Microsoft Excel
- Knowledge of simple formulas and functions
- Alternatively, completion of Excel Essentials training course
- Customise Quick Access Toolbar
- Customise the Ribbon
- Custom Lists
- Custom Formats and Cell Styles
- Conditional Formatting
- Themes and Templates
- Data Validation
- Use Statistical, Math, Date & Text Functions
- Absolute Referencing
- Define Names
- Linking Data
- Populate Data using IF
- Populate Data using VLOOKUP
- Work with Tables
- Sort, Subtotal, Group & Filter Data
- Create and Analyse Data with Pivot Tables
- Protect your Data
- Good level of experience in using Microsoft Excel
- Knowledge of basic functions and linking data
- Alternatively, completion of Excel Intermediate training course
- Text to Columns
- Data Cleansing
- What-If Analysis
- Macros
- Data Consolidation
- Filter Data
- Database Funtions
- Logical / Lookup Functions
- Formula Auditing
- PivotTable and PivotCharts
- Sparklines
- Insert Pictures
- Checkboxes
- Import Web Data
Microsoft Excel Essentials |
|
| Duration: 2 days
Aimed at: those who want to be able to create and edit basic spreadsheets containing simple calculations, links, and charts, and produce formatted and printable reports. Pre-requisites: |
Course Overview:
|
Microsoft Excel Intermediate |
|
| Duration: 2 days
Aimed at: those who want to improve the efficiency of their workbooks, improve the quality of data and effectively, analyse data using various Excel tools and functions. Pre-requisites: |
Course Overview:
|
Microsoft Excel Advanced |
|
| Duration: 2 days
Aimed at: those who want to effectively analyse and populate data and produce professional-looking workbooks. Pre-requisites: |
Course Overview:
|