Introduction to Spreadsheets with Excel

The following shows a table of contents for the Excel Course:                                                   
Introduction
What is a spreadsheet?                                          
What can Excel do for you?                                    
Starting Excel                                                    
Examining the Excel Environment                                        
Row and Column Headers Explained                                 
Cell references                                                  

Getting Started
Creating a New Folder for all your work                              
Copying the required files from the “Excel Intro” Folder           
How to paste the copied files into the work folder              
Opening and Viewing Spreadsheets                                  
Closing Workbooks                                          
Exiting Excel                                                             
Starting a New Workbook                                              
Entering data Excel                                                 
Editing and Formatting your Spreadsheet                          
Modifying Column Widths                                              
Modifying Row Heights                                           
Inserting New Rows and Columns                         

Working with Worksheet Tabs
Renaming Tabs                                                 
Repositioning Tabs                                                 
Deleting Tabs                                                    
Inserting New Worksheets                                             
Merging Cells                                                    
Saving your work                                                      
Formatting Font Size, Color and Background color                 

Working with formulae
Formula Basics                                                 
Entering a Formula – Exercise                                      
Entering a Formula with the Point and Click Approach                   
Using the Fill Handle                                                

Using Absolute and Relative Cell References     
What is a Relative Cell Address?                                        
What is an Absolute Cell Address?                              
Absolute Cell Referencing in practice                                 

Working with Functions in Excel
What are Functions?                                               
The SUM Function                                                   
The MIN and MAX Functions                                         
The AVERAGE Function                                               
Displaying Formulae and Functions                             

Working with Comments
Inserting Comments
Editing Comments
Deleting a Comment

Working with Charts
Overview of when to use the various Chat types                
Practice Plotting Charts in Excel                                   
Create a Chart using keyboard shortcut 
Changing the Chart Background

Go back to our list Office Courses