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

Microsoft Excel Level 2

Suitable for versions 365 / 2019 / 2016 

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 worksheets and files
  • Learn all about working with Data Tables and Dynamic Referencing
  • Create professional looking charts and visualise data
  • Boost existing formula knowledge with super handy functions
  • 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

 

Understanding Databases and Datasets

  • A masterclass in Excel Data Tables
  • Database parameters
  • Understanding Dynamic Named Ranges
  • Managing multiple tables
  • Formatting and styling tables
  • Using Slicers to filter
  • Exporting data from other sources in tables
  • Creating calculated fields
  • Using Dynamic References
  • Introduction to PIVOT TABLES

Very Useful Functions
  • COUNTIFS, SUMIFS, AVERAGEIFS
  • Using Wild cards and Comparison operators to extend your functions
  • Efficient formula tips, tricks and expert advice

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

Data lists

  • Using the Fill handle to create lists
  • Understanding data series
  • Flash Fill

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
  • Format Painter

Excel's secrets & expert advice
  • Creating a proper database
  • Navigating a worksheet
  • Hidden views
File linking  
  • Linking spreadsheets
  • Linking workbooks
  • Linking Microsoft 365 Cloud Files (OneDrive, SharePoint and Teams)
  • Controlling links
  • Breaking links
  • Updating
  • Editing
Charts
  • Creating professional looking charts
  • Advanced properties
  • Advanced chart types
  • Multiple charts
  • Linking
  • Exporting
  • Visualising data

Microsoft 365 Cloud Features
  • What's new
  • Cloud storage, SharePoint, Teams and OneDrive
  • Versions
  • Co-Authoring
  • 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 £ 269 n/a
2 places £ 538 n/a
3 places £ 807 £ 799
4 places £ 1076 £ 1054
5 places £ 1345 £ 1305
6 places £ 1614 £ 1549
7 places £ 1883 £ 1789
8 places £ 2152 £ 2023