INTRODUCTION

Open Microsoft Excel   : seconds

Explore the ribbon   : seconds

Explore the quick access toolbar  

Explore the Microsoft office window frame   : seconds

Explore the dialog box launchers   : seconds

Obtain help using the search button   : seconds

Obtain help from the table of contents   : seconds

Excel the basics

Basic Spreadsheet

Add numbers in Excel

Second way to add numbers

Subtract your numbers

Add dollar signs

Take me home

Get rid of the dollar signs

Close a document

Customize the quick access toolbar   : seconds

 WORKING WITH AN EXCEL WORKSHEET

Open an existing excel file   : seconds

Create a drop down list

Navigate through a worksheet using the mouse              

Navigate through cells using the keyboard         

Create a new workbook               

Select a worksheet        

Enter data in a excel spreadsheet

Save a new workbook   

Save changes made to an existing workbook     

Save a copy of an existing workbook

Convert a file to the xlsx format              

Perform a compatibility check on a worksheet 

Save a workbook in an earlier version of excel 

MODIFYING A WORKSHEET

Move data between cells            

Copy data between cells             

Fill cells with a series of data using auto fill       

Copy cells using auto fill options             

Edit cell data     

Insert a column               

Insert a row       

Insert multiple rows or columns              

Insert a single cell          

Insert multiple cells      

Delete rows      

Delete columns               

Delete cells       

Find cell data    

Replace cell data            

Name a cell       

Go to cell data  

Spell check a worksheet              

PERFORMING CALCULATIONS

Customize the formula bar        

Order of operations      

Create a formula             

Apply a formula using the formula auto complete feature          

Apply a formula using the function library          

Work with calculations options

Copy a formula or function        

Copy a formula or function using the paste special feature        

Create an absolute reference   

Create a mixed reference           

Switch between relative, absolute, and mixed references      

FORMATTING A WORKSHEET

Split the contents of a cell by setting column breaks     

Change the font type    

Change the font style   

Change the font size     

Use galleries and live preview  

Format all cells in a row or column

Add borders to cells      

Remove cell borders     

Add background color  

Set an image as the sheet background  

Remove a sheet background     

Paste data from a bordered cell without pasting borders             

Transpose data during paste     

Change column width and row height by dragging          

Change column width to a specific value             

Change row height to a specific value   

Modify column width to fit its contents               

Wrap cell contents         

Change column width and row height by dragging boundaries  

Change column width to a specific value             

Change row height to a specific value   

Modify column width to fit its contents               

Wrap cell contents         

Modify row height to fit its content

Hide columns   

Hide rows           

Merge cells       

Split merged cells          

Apply number formats 

Create a custom number format              

Copy formats using auto fill       

Copy contents without formatting using auto fill             

Align cell contents         

Find and replace             

Add the autoformat command to the quick access toolbar          

Apply an autoformat     

Apply a cell style            

Modify a cell style          

Apply a theme 

DEVELOPING A WORKBOOK

Change the name of a workbook

Change the color of worksheet tabs

Manually reposition worksheets in a workbook               

Reposition worksheets using the move or copy dialog box         

Insert a worksheet         

Delete worksheets        

Copy and paste worksheets       

PRINTING WORKBOOK CONTENTS

Set a print title

Remove print titles       

Preview the workbook 

Create a header in page layout view

Create a footer in page layout view

Create a header using the page setup dialog box            

Create a footer using the page setup dialog box              

Set page margins using the margins options      

Set page margins using the page setup dialog box          

Set page margins using the print preview window          

Change page orientation            

Insert page breaks         

Remove page breaks    

Print an excel sheet      

Set print area   

Scale the range to be printed    

Print a range of cells  

CUSTOMIZING LAYOUT

Split a worksheet window           

Arrange workbook windows      

Arrange worksheets in new windows    

Freeze rows or columns               

Unfreeze rows or columns          

Hide worksheets             

Unhide worksheets       

ENHANCING WORKBOOKS

Customize the color scheme     

Hide or show the screen tips     

Hide or show mini toolbar on cell selections     

Mimic a watermark in a worksheet

Add elements to the header and footer              

Hide gridlines and headings in a worksheet       

Modify elements in a header and footer             

Remove elements from the header or footer in a worksheet    

Create a new theme color          

Create a new theme font            

Create a custom theme from an existing theme              

Create a custom theme               

Create a hyperlink to an existing file or webpage            

Create a hyperlink to an email address

Create a hyperlink to a new document

CREATING WORKBOOKS USING TEMPLATES        

ORGANIZING DATA USING TABLES

Create a table with the default table style          

Create a table with the desired table style         

Add rows and columns 

Delete rows and columns           

Resize a table by specifying a different range   

Add a header and total row        

Remove a header and total row               

Remove duplicate rows in a table

Change the summary function of the total row in a table             

Delete a custom table style       

Remove a table style    

PRESENTING DATA USING CHARTS

Create a chart   

Add chart elements       

Horizontal axis display

Vertical axis display options      

Remove chart elements              

Move a chart     

Change a chart type       

Resize a chart   

Apply a chart style         

Apply a chart layout      

ANALYZING DATA USING PIVOT TABLES AND PIVOT CHARTS       

Create a picot table       

Customize the calculations in a pivot table        

Change the field settings            

Modify the PivotTable report   

Format the pivot table report   

Print the pivot table report        

Create a pivot chart       

ENHANCING VISUAL APPEAL USING GRAPHIC OBJECTS  

Insert clip art    

Apply a picture style     

Resize a picture               

Apply a picture shape   

Apply a picture border 

Apply a picture effect   

Draw/Insert a shape      

Rotate a drawn shape   

CALCULATING DATA WITH ADVANCED FORMULAS          

Name a cell range from the formula bar              

Name a cell range with the new name dialog box            

Name a cell range with the create names from selection dialog box

Select a named range   

Change the name of a named range

Delete a range name    

Use named ranges in formulas 

Enter cells and ranges from multiple worksheets into a formula              

Calculate data across worksheets using a three dimensional cell reference        

Insert datea and time function 

Insert a function with the function wizard           

Insert function arguments with the function wizard       

Insert a math and trig function 

Insert other functions (engineering, cube and informational)   

Lookup data with the HLOOKUP function             

Look up data with the VLOOKUP function            

Insert a logical function       

   SORTING AND FILTERING DATA

            Sort data             

            Filter data          

            Remove a filter               

            Insert the DSUM, DCOUNT, or DAVERAGE function         

   STREAMLINING WORKFLOW      

            Create a macro

            Run macros using the macros dialog box             

            Run macros using the keyboard shortcuts           

            Edit a macro      

            Apply conditional formatting    

            Create a new conditional formatting rule            

            Edit an existing conditional formatting rule       

            Delete a conditional formatting rule

            Sort data using conditional formatting 

            Filter data using conditional formatting               

            Add a data validation rule          

            Create a drop down list from a range of cells     

            Update a workbooks properties               

            Modify excels default settings 

            Change the default file storage location              

   COLLABORATING WITH OTHERS               

            Protect worksheets       

            Inspect a workbook to remove specific content               

            Allow users to edit specific cell ranges in a password protected worksheet        

            Protect the structure and window layout of workbooks from being altered        

            Protect workbooks from being open or modified            

            Share a workbook           

            Set revision tracking using the protect and share workbook command  

            Set revision tracking using the track changes command               

            Display all the changes made to the workbook 

            Accept or reject tracked changes

            Display the compare and merge workbooks option on the quick access toolbar

            Merge workbooks          

            Display the developer tab on the ribbon             

            Adjust macro settings   

            Add a digital signature to a file

            Install another person’s certificate on your computer   

            Remove a digital signature from a file  

            Restrict permission to contents in a file               

            Set an expiration date for a file               

            Mark a workbook as final            

   AUDITING WORKSHEETS              

            Trace cell precedents   

            Trace cell dependents  

            Trouble shoot errors in formulas

            Trouble shoot invalid data         

            Trouble shoot invalid formulas

            Watch formulas               

            Evaluate formulas          

            Group and outline data using auto outline         

            Group and outline data using the group options              

            Add subtotals to grouped data using the subtotal option            

   ANALYZING DATA

            Create a trend line with default settings             

            Create a trend line with user-defined settings 

            Create a scenario            

            Perform what-if analysis using goal seek             

            Load the solver add-in 

            Perform what-if analysis using solver   

            Load analysis toolpak   

            Perform statistical analysis with the analysis toolpak    

            Use the sampling analysis tool for performing analysis

   WORKING WITH MULTIPLE WORKBOOKS             

            Create a workspace       

            Consolidate data            

            Link cells in different workbooks

            Edit links            

   IMPORTING AND EXPORTING DATA

            Save Excel data in a different file format             

            Export excel data to use in Microsoft Word        

            Import a table from Word           

            Import a delimited text file by opening it           

            Import a text file by connecting to it