Providing Innovative Solutions For All Your Technology Needs  
  

 
 
 


 MICROSOFT EXCEL 101

Lesson 1: Overview

Lesson 2: The Drag Handle

Lesson 3: Filling Numbers

Lesson 4: Cell Widths

Lesson 5: Formulas

Lesson 6: Cell References

Lesson 7: Functions

Lesson 8: Moving Data

Lesson 9: Columns & Rows

Lesson 10: Absolute & Relative Cell References


MICROSOFT EXCEL 102

Lesson 11: Formatting Cells

Lesson 12: Number Formats

Lesson 13: Sorting

Lesson 14: Lookup function

Lesson 15: Using Sheets

Lesson 16: Macros: Automating Tasks

Lesson 17: Charts

Lesson 18: Validating A Number

Lesson 19: Financial Functions

Lesson 20: Lookup & Date & Time Functions

 

MICROSOFT EXCEL 103

Lesson 21: Excel AND & OR functions

Lesson 22: Combing AND/OR with IF

Lesson 23: FV, NPER, IPMT & PMT Functions

Lesson 24: Excel conditional formatting

Lesson 25: Mathematical date functions

Lesson 26: Excel Pie Chart

Lesson 27: Working with Excel Worksheet

Lesson 28: The Excel Drop Down List

Lesson 29: The Excel Time Function

Lesson 30: The Excel Date Function

Lesson 31: Excel SUMIF Function

Lesson 32: Excel Text Concatenation feature