Microsoft Excel Fundamentals and Advanced Skills
Course Code: MSE102AF
Get to grips with Excel
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 a Private Event
If you require the content of this event tailored or have around 7 or more people to train it maybe better for you to host a Private Event, please get in touch to discuss this.
Get in touchDescription
Who is this course for
Anyone that manages, stores or looks at data as part of their role.
Purpose of the course
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.
You will learn how to
Create and customise workbooks in Excel 2010, 2013 or 2016Use 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
Prerequisites
There are no prerequisites for this course though a basic knowledge of Microsoft Office would be advantageous.Benefits for you as an individual
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.
Benefits for your organisation
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.
Welcome to Excel
- Workbooks and Worksheets
- File Types
- Spreadsheet Navigation
Excel Interface
- The Quick Access Toolbar
- Excel Ribbon
- Overview of Tabs
- Command Groups
Excel Basics
- Labels
- Printing
- Autosum and Autofill
- Copy/Cut/Paste
- Introduction to Formulae
Workbook Formatting
- Modification of Cells and Cell Data
- Styles and Borders
- Chart Creation and Modification
- Cell Referencing
Functions and Formulae
- Mathematical Operators
- Error Checking
- Nested Functions
- Array Formulae
Tables
- Creation and Formatting
- Sort and Filter
- Excel as a Database
Data as a Graphic
- SmartArt
- Symbols
- Add and Edit Shapes
- Sparkline
Advanced Data Management
- Automatic Grouping, Outlining and Subtotalling
- Scenario Manager
- Data Analysis Tools
- Solver
Pivot Tables
- Creation and Formatting of Pivot Tables
- External Data
- Slicers
- PowerPivot
Pivot Charts
- Creation and Formatting of Pivot Charts
- Advanced Tasks
- Scenarios
Advanced Excel Tasks
- Advanced Functions
- Logical Functions
Excel Programming
- Macros
- Keyboard Shortcuts
- Visual Basic
Get Started
Forget trawling through endless course catalogues – Find the training that’s right for you
Learn MoreLatest from our blog
Kanban and Agile: Bridging the Gap
Kanban and Agile: Bridging the Gap Quanta’s Kanban University Certified Trainer Steve Church explores the way in which Agile and…
Read More
How a Ballerina could move into Cybersecurity
Jason Ford, Quanta Cybersecurity and IT Trainer talks about the limitations in Cybersecurity Training courses. Jason discusses a safe and…
Read More
Boost Team Performance and Productivity: Unlocking the Advantages of Emotionally Intelligent Leadership
Quanta People Development and Leadership Trainer, Giles Collins outlines the key elements of Emotionally Intelligent Leadership and how it impacts…
Read More