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

Microsoft Excel Level 1

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 designed for new or existing basic users of Microsoft Excel.

 

Delegates will learn:
  • How to create spreadsheets
  • Understand formulas and functions
  • Format spreadsheets
  • Work with data lists, sorting, filtering
  • Delegates will also learn shortcuts and tips about how to use Excel in the most efficient way

 

Editing Spreadsheet  
  • Enter different data types
  • Change existing formulae
  • Re-size columns, auto-fitting, text wrapping
  • Copy and Pasting inc. paste special

Creating Basic Formulae
  • How to create a formula
  • Understanding Functions
  • Autosum and all aggregate functions

Creating a Basic Spreadsheet
  • Create a table with titles
  • Use text, numbers and formulae
  • Copy formulae
  • Total columns
  • Format the cells
  • Hide gridlines

Presentation
  • Resizing columns / text wrapping
  • Formatting numbers
  • Formatting cells
  • Applying borders, cell colour, etc.
  • Using the Format Painter to copy formatting

Lists
  • Creating number series
  • Creating customised text lists
  • Creating date lists
  • Creating sequential number / date lists

Dates
  • Understanding dates in Excel
  • Formatting dates inc. custom format
  • Using dates in formulae
  • Using the TODAY functions

File Procedures
  • Save Vs Save as
  • Saving as older versions
  • Compatibility Mode

Printing
  • Print Preview
  • Scaling to print on 1 page
  • Define Print Area
  • Using Page Break Preview
  • Printing multiple worksheets / selected cells
  • Printing to PDF

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
Managing Formulae  
  • Using brackets (BODMAS)
  • Relative and Absolute references (Using the $ signs in references)
  • Changing formulae to values

Page Setup
  • Orientation / scaling
  • Margins
  • Headers / footers

Functions
  • Min/Max
  • Average/Count
  • Sum
  • The IF function
  • Comparison Operators

Spreadsheet Efficiency
  • Cell Notes
  • Sorting
  • Page Breaks
  • Freeze Titles / Print Titles

Charts
  • Creating a simple chart
  • Changing chart type

Basic Filtering
  • Applying a filter
  • Creating a custom filter
  • Sorting
  • Remove Filter
  • Instant Data Analysis
  • Flash Fill

Integration with Microsoft 365
  • Cloud storage and OneDrive
  • Office 365 Cloud Apps
  • Signing-in to Microsoft 365
  • Using Microsoft 365 on multiple devices
  • Easier file sharing
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 £ 250 n/a
2 places £ 500 n/a
3 places £ 750 £ 683
4 places £ 1000 £ 900
5 places £ 1250 £ 1113
6 places £ 1500 £ 1320
7 places £ 1750 £ 1523
8 places £ 2000 £ 1720