Skip to main content
Microsoft Excel Fundamentals and Advanced Skills
Excel has long been a popular choice for creating spreadsheets, analysing data and creating graphical representations of information. This course can run on Excel 2010, 2013 or 2016 and has more bells and whistles than any version before it, and can be daunting for a novice user.
There are few things in life more impressive than a properly formatted and presented spreadsheet, so if you want to dazzle colleagues with your workbook wizardry or automate a process you repeat every day then this is the course for you.
Book your team training at your premises
- Date
- Venue
- Cost
- More info
- Date and time to suit you
- VenueWe will train your team
at your offices - CostContact us for price
- Fill in the form and we'll be in touch
within a working day.
This course will introduce you to Excel and give you the skills to use the program every day as well as the knowledge of advanced functions and features.
Anyone that manages, stores or looks at data as part of their role.
- Create and customise workbooks in Excel 2010, 2013 or 2016
- Use Excel as a day to day user
- Present data graphically
- Create Pivot tables and graphs
- Use Excel functions and formulae for mathematical processes and automation
- Program Excel 2010, 2013 or 2016 using Visual Basic
This course will enable delegates to format and present data in easier to understand ways, as well as improving their efficiency through the use of advanced Excel Macros and shortcuts.
An in depth knowledge of Excel is useful for any role in an organisation and can make day to day data management quicker and easier.
Workbooks and Worksheets
File Types
Spreadsheet Navigation
The Quick Access Toolbar
Excel Ribbon
Overview of Tabs
Command Groups
Labels
Printing
Autosum and Autofill
Copy/Cut/Paste
Introduction to Formulae
Modification of Cells and Cell Data
Styles and Borders
Chart Creation and Modification
Cell Referencing
Mathematical Operators
Error Checking
Nested Functions
Array Formulae
Creation and Formatting
Sort and Filter
Excel as a Database
SmartArt
Symbols
Add and Edit Shapes
Sparkline
Automatic Grouping, Outlining and Subtotalling
Scenario Manager
Data Analysis Tools
Solver
Creation and Formatting of Pivot Tables
External Data
Slicers
PowerPivot
Creation and Formatting of Pivot Charts
Advanced Tasks
Scenarios
Advanced Functions
Logical Functions
Macros
Keyboard Shortcuts
Visual Basic
There are no prerequisites for this course though a basic knowledge of Microsoft Office would be advantageous.
About the Lead Trainer
Hamish has been training IT systems for many years and has seen MS Windows develop through all of its various versions. He can even remember some of the earlier ones! Whilst Hamish is not training for Quanta you will find him in a field somewhere, surrounded by members of the Scouts camping, climbing or playing with fire or during the run up to Christmas you will find him acting as Rudolph whilst pulling Santa on his Sleigh for the local Lions Club collecting for many local charities.
