The College" brings you education in Network Marketing (enabling you to start your own marketing business), Computer Literacy (Microsoft applications

By: Network Marketing College  11-11-2011

 Module 1 -  The Excel 2007 Interface
  • Title Bar
  • Ribbon
  • Office Button
  • Sheet tabs
  • Name Box
  • Formula Bar

Module 2 -  Entering and Editing Data

  • What is a Cell?
  • Typing in Excel
  • Alignment of text and numbers
  • Editing data and making corrections
  • Autofill

Module 3 - Fun with Formatting

  • Font formats
  • Alignment formats
  • Number Formats

Module 4 - Working with columns and Rows

  • Changing columns width and Row height
  • Inserting and deleting Rows and columns
  • Inserting and Deleting Cells

Module 5 - An Open and Shut Case

  • Opening worksheets
  • Closing worksheets
  • Saving worksheets
  • Restore, Minimize and Maximise

Module 6 - Clever Excel Tables

  • Formatting as a table
  • Converting Text to columns
  • Sorting and Filtering
  • Conditional formatting

Module 7 - Copy Cat

  • Moving and Copying within Excel
  • Using the format painter

Module 8 - Getting started with Formulas

  • What are formulas?
  • Order of Operations
  • Using Cell references in your formula
  • The Autofill feature

Module 9 - Getting Started with Functions

  • What are functions?
  • Autosum, average, minimum, maximum
  • Relative and Absolute referencing

Module 10 - Ways with Worksheets

  • Moving around a worksheet
  • Freezing areas of your worksheet
  • Hiding and Revealing rows and columns
  • Find and Replace
  • More exciting AutoFill options

Module 11 - Managing Multiple Worksheets

  • Adding and Deleting worksheets
  • Copying and Moving worksheets
  • Changing Sheet Tab colors
  • Applying changes to multiple sheets
  • Creating 3D Formulas for Worksheets

Module 12 - Charts

  • Creating Charts
  • Modifying Charts

Module 13 - More Handy Functions

  • Count and Counta
  • CountIf and SumIf
  • VLookup
  • Concatenate

Module 14 - Final Touches

  • Proofing your work
  • Document Security - Protecting and Sharing
  • Printing your worksheets


Contact Network Marketing College

Email

Print this page

Share