iTrain Scotland IT Training Edinburgh image
 

Microsoft Excel Level 3

iTrain Scotland IT Training Edinburgh image

Home > Courses > Microsoft courses > Microsoft Excel Level 3

Microsoft Excel Level 3

Suitable for versions 2016 / 2013 / 2010

Whether you are a new 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 Foundation level course is suggested.
Delegates will learn about Pivot Tables, Macros, 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.
Pivot Tables
  • Creating
  • Updating
  • Adding Fields
  • Field Options
  • Manipulating
  • Consolidation
  • Charts
  • Pivot Charts
  • Slicers and timelines

Outlining
  • Creating an Outline
  • Group/Ungroup
  • Manipulating
  • Removing

Scenario Manager
  • Adding
  • Updating
  • Merge
  • Summary
  • Printing

Advanced Functions
  • Nested IFs
  • VLOOKUP / HLOOKUP
  • Mathematical
  • Date/Time
  • Text
  • Information
  • Statistical
  • Database Functions
  • Financial 
  • General Nesting
  • Function hints and tips

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
  • Arrays
  • 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 2016 / 365 features
  • What's new
  • Cloud storage and OneDrive
  • Office 365
  • Signing-in to Office 2016
  • Using Office 2016 on multiple devices
  • Easier file sharing
  • Instant Data Analysis
  • Flash Fill
  • Chart Recommendations
  • Animations in Charts
Group discount
1 place £ 205 n/a
2 places £ 410 n/a
3 places £ 615 £ 565
4 places £ 820 £ 665
5 places £ 1025 £ 765
6 places £ 1230 £ 865
7 places £ 1435 £ 965
8 places £ 1640 £ 1065