Please login to view your account dashboard

Account Dashboard

Loading...

Microsoft Excel Level 1

$165.00

The aim of this course is to provide a good introduction to Creating and Managing Spreadsheets using Microsoft Excel.  Even if you have been using Excel for a long time, the shortcuts and extra hints will enable you to be more efficient with the spreadsheets you use. 

Loading...
The aim of this course is to provide a good introduction to Creating and Managing Spreadsheets using Microsoft Excel.  Even if you have been using Excel for a long time, the shortcuts and extra hints will enable you to be more efficient with the spreadsheets you use. 

COURSE CONTENT 

  • Creating, Pinning and Saving Spreadsheets 
  • Using key Shortcut keys for File Management Cell selection 
  • Working with column and row widths 
  • Formatting Text and Numbers 
  • Using Speedfill 
  • Formulas and functions 
  • Subtotals and Grandtotals 
  • Absolute References 
  • Managing Large Files 
  • Working with Multiple sheet files 
  • Printing 
  • Headers and Footers 
  • Filtering and Sorting 
  • Charts and Pivot Tables 

Upon completion of the course, participants will be able to: 

  • Create and manage Spreadsheets for everyday use 
  • Understand the principal of Functions 
  • Create and use Multiple Sheet files 
  • Filter and sort Data within  a spreadsheet 
  • Create and Manage Charts and Pivot tables 

 

The online course consists of the theory with a range of interactive activities that include: 

  • Experiential learning activities 
  • Individual exercises 
  • Questionnaire 
  • Reflective practices 
  • Workbook 

 

5-6 hours 

Copyright © 2022 Smarter Training Online. All rights reserved.

website design by Content Creative Agency.
Scroll to Top