Software School

For more information, please :
send email to trainer@softwareschool.ca or call us at (780) 452-8907

MS Excel

Spreadsheet

Excel - level 1

 

Course objectives:

What do spreadsheets do? Getting started with excel, workbook basics, opening and saving a file, workbook navigation, selecting workbook areas

Entering and editing data

Copying and moving entries 

Autofill feature

Inserting and deleting cells, columns, rows, and worksheets      

Spell check      

Formulas           

Formatting        

Printing  

-page set up 

    

 

Excel - level 2

 

Pre-requisites: Intro. to Excel Level 1

Linking worksheets/files

Absolute cell references

Templates

Macros

Outlining

Introduction to data management

a)    Data list features

b)    Data entry

c)    Freezing panes

d)    Filtering data

e)    Sorting data

Automatic subtotalling

Pivot Tables

Charting

 

Excel Advanced - Level 3 

 

Protecting workbooks    

Consolidating and analyzing data        

  Consolidating data, goal seek and solver utilities , scenario manager

Advanced formulas              

  Names, if function and conditional formatting ,  the vlookup function  

Converting data     

Creating complex macros             

  Recording a macro/relative reference ,  running macros,  viewing and editing vba code,                programming a macro 

Templates and quick access toolbar  

Using graphic objects        

  Adding and formatting graphic objects              

Using comments       

  Excel comments, tips            

Using data tools:   

  Text to columns, remove duplicates,  data validation