iTrain Scotland IT Training Edinburgh image
 

Microsoft Excel Level 2

iTrain Scotland IT Training Edinburgh image

Home > Courses > Microsoft courses > Microsoft Excel Level 2

Microsoft Excel Level 2

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 those who have a good understanding of Excel at a Foundation level.
Delegates will learn how to improve existing spreadsheet knowledge with linking workbooks, protecting cells / worksheets, charts, and overall better formulae understanding including functions and multi-sheet referencing. Delegates will also learn shortcuts and tips about how to use Excel in the most efficient way.
Linking worksheets
  • Multiple sheets
  • Selection techniques
  • Copying data between sheets
  • Filling across multiple sheets
  • Group mode
  • Consolidating data across worksheets

Consolidated formulae
  • Functions: MAX, MIN, AVERAGE, COUNT, COUNTA
  • Formula ranges spanning multiple worksheets
  • Efficient formula tips

Protection
  • Protecting worksheets
  • Protecting cells
  • Protecting files
  • Permissions
  • Multi-user access
  • Passwords

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
File linking  
  • Linking spreadsheets
  • Linking workbooks
  • Controlling links
  • Breaking links
  • Updating
  • Editing

Lists
  • Advanced sorting
  • Advanced filtering
  • Slicers
  • subtotaling

Charts
  • Creating charts
  • Advanced properties
  • Advanced chart types
  • Multiple charts
  • Linking
  • Exporting

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