Advance Microsoft Excel
Course Description
In this course, the student will learn basic, intermediate and advance Microsoft Excel features
You Will Learn How To
  • Create and Define a Simple Worksheet
  • Develop the Worksheet
  • Use formulas and macros
  • Perform special Operations
    		•
    Who Should Attend
    This course is for students who would like to learn various function in Excel. This course also enable the student to utilize the advance features taught in this course in an office environment with maximum efficiency.
    Topics Covered
    Unit 1. Create and Define a Simple Worksheet
  • Define worksheet/workbook
  • Access / Navigate / Exit the program
  • Formulas
  • SUM function/AutoSUM button
  • Formatting numbers and text with the toolbar
  • Save/Save as/Name a file
    		•
     
    Unit 2. Develop the Worksheet
  • Plan a worksheet
  • Row and Column labels
  • Split worksheet / box / bar
  • Copy data and formulas
  • Display / move toolbars
  • Enhance worksheet appearance
    		•
     
    Unit 3. Formulas and Macros Formulas
  • Use the Function Wizard
  • Common functions (AVERAGE,MIN, MAX, COUNT,
        COUNTA,ROUND,INT)
  • Nested functions
  • Name cells/ranges/constants
  • Relative, Absolute, Mixed cell references
  • >,<,= operators
  • Logical functions using IF, AND, OR, NOT
  • The LOOKUP function
  • Date and time functions
  • Annotating formulas
  • Correcting circular references

    • Macros
  • Definition and use
  • Record a macro
  • Assign a macro
  • Run a macro
  • Store a macro
  • Use the Personal Macro Workbook
    		•
     
    Unit 4. Special Operations
  • Use multiple windows
  • Copy/paste between worksheets
  • Link worksheets
  • Consolidate worksheets
  • Import and link from other Applications
  • Use AutoFormat
  • Create, use and modify styles and templates
  • Print features
  • Create/edit an outline
    		•
     
    Unit 5. Graphics Operations
  • Create charts
  • Enhance charts
  • Drawing features
    		•