Basic Excel

Course details

Course Outline
 
 Data - Numbers and Text in Excel

• Entering Numbers and Text
• Overflowing Numbers and Text

 

• Editing Numbers and Text

 

• Selecting Multiple Cells

 

• Autofill: Numbers, Months, Days of Week, Dates

Removing Duplicates
 
 Calculations Concept
 

• Relative and Absolute Reference Use of F4 Key

 

• Entering Formulas

 

• Using the Mouse to Enter Cell References in Formulas

 

• Editing Formulas - Using F2 Key the Order of Evaluation: BODMAS

 

• Using Parentheses to Change the Order Entering Functions

 

• The Structure of Functions the =SUM () Function

 

• Using the Mouse to Enter Range References Entering Functions in the Formula Bar Inserting Functions

 
Applying AutoSum
 
 Formatting Numbers, Text, Reports

• Number Formatting

 

• Dates Formatting

 

• Text Formatting

 

• Row and Column Formatting
• Additional Formatting Options: Styles

 

• Other Advanced Formatting

 

• Merging Cells

 

• Wrapping Text
• Transposing Data

 

• Using Paste Special Operations

Multiple Worksheets and Workbooks

• Viewing Large Worksheets

 

• Locking Row and Columns Heading in Place Hiding and Unhiding Worksheets Minimizing the Ribbon to see more of the

 

• Worksheet

 

• Using Multiple Worksheets

 

• Inserting Worksheets
  Moving and Copying Worksheets
• Deleting Worksheets

 

• Naming Worksheets

 

• Coloring Worksheets Tab

 

• Linking Worksheets
• Linking Workbooks

 

• Workspace

 
 Printing

• Preparing to Print
• Using the Spelling Checker

 

• Using Page Break Preview Page Setup Options

 

• Page Orientation Page Size Scaling

 

• Margins

 

• Custom Headers and Footers

 

• Print Titles: Rows or Column to Repeat Printing Worksheets

 
 Power of IF and VLOOKUP - a Teaser
=IF () Function
 
=VLOOKUP () Function
 
Conditional Formatting - the Basics

• Bars

 

• Highlight Cell Rule

 

• Top-Bottom Rule

 

• Finding Duplicate

 
Intro - Pivot Tables
 

• Reports with ZERO Errors & ZERO Formulas Using Styles to Format Pivot Reports

 
Intro - Charts

• Creating Charts with One Key Press!
• The FOUR Critical Steps

 

• Pie and Column Charts

 

• Relevant Shortcuts

 

• Demonstration: The Power of Macros

 
  Updated on 31 May, 2018