iTrain Scotland IT Training Edinburgh image
 
Home > Courses > Microsoft courses > Microsoft Excel Level 3

Microsoft Excel Level 3

Suitable for versions 365 / 2019 / 2016 / 2013

Whether you are an occasional user or have been using Excel for years, this course will vastly increase your understanding of Excel. Existing users will learn how to get the most out of Excel, break any bad habits, learn shortcuts and discover a massive range of hints and tips from our expert Excel trainers.

This course is aimed at intermediate users of Excel who wish to exploit the full capabilities of their spreadsheet software. A complete understanding of the topics in the level 1 course is suggested.
Delegates will learn about Pivot Tables, Databases, Macros, XLOOKUPS, Arrays, and many other Excel advanced features. The course also covers a vast array of advanced formulas and functions including Lookups and nested IFs. Delegates will also learn shortcuts and tips about how to use Excel in the most efficient way.

Databases

  • Excel tables
  • Slicers
  • Dynamic named ranges
  • Extending a table
  • Styles
  • Removing duplicates

Pivot Tables

  • Creating
  • Updating / refreshing
  • Connecting to a data source
  • Data models
  • Adding Fields
  • Field Options
  • Manipulating
  • Consolidation
  • Pivot Charts
  • Dashboards
  • Slicers and timelines

Arrays
  • Arrays explained
  • Dynamic array functions
  • Spilling
  • Unique, Sort array functions

Advanced Functions
  • XLOOKUP
  • VLOOKUP / HLOOKUP
  • MATCH & INDEX
  • Logical IF, AND, OR
  • Nested IFs
  • Mathematical
  • Date/Time
  • Text
  • Information
  • Statistical
  • Database Functions
  • Financial 
  • General Nesting
  • Function hints and tips


Scenario Manager

  • Adding
  • Updating
  • Merge
  • Summary
  • Printing

Tips & tricks
  • Using Excel efficiently using shortcuts
  • Previewing all formulas on a worksheet
  • Auto calculations
  • Autofill
  • Keyboard shortcuts
  • Mouse shortcuts
  • Autoresize
  • Keyboard selection techniques
  • Mouse selection techniques

Excel's secrets & expert advice
  • Creating a proper database
  • Navigating a worksheet
  • Hidden views
General Advanced Features  
  • Custom Formatting Numbers
  • Conditional Formatting Rules
  • Goal Seek
  • Text Joining
  • Styles
  • Custom Lists
  • Auditing
  • Mixed References

Advanced Charts
  • Adding 2nd Y Axis
  • Custom Charts
  • Trend Lines

Introduction to Macros
  • Recording Macros
  • Assign to Keyboard
  • Assign to Ribbon
  • Save in Personal
  • Save in Workbook

Office 365 features
  • What's new
  • Cloud storage and OneDrive
  • Office 365
  • Signing-in to Office 365
  • Using Office 365 on multiple devices
  • Easier file sharing
  • Instant Data Analysis
  • Flash Fill
  • Chart Recommendations
  • Animations in Charts
Prices below are for scheduled courses held in our Edinburgh Training Centre or Live Virtual Classroom. Major discounts available for onsite or private courses: click General Enquiry button below to enquire about private courses.
Group discount
1 place £ 205 n/a
2 places £ 410 n/a
3 places £ 615 £ 570
4 places £ 820 £ 760
5 places £ 1025 £ 950
6 places £ 1230 £ 1140
7 places £ 1435 £ 1330
8 places £ 1640 £ 1520