Title : Introduction to Excel



Duration - 1 day


Fees :    £300 for 1 to 6 delegates        £350 for 7 to 10 delegates

(Fees are inclusive of all expenses)



Content
 

  • About Workbooks and Worksheets
  • Navigating Excel
    • Moving around the workbook
    • Menu tabs
    • QAT
  • Creating a table
    • Labels
    • Numbers
    • Dates
  • Formatting the table
    • Cell Styles
    • Currency formats
    • Number formats
    • Font formats
    • Merging cells
  • Formula Building
    • Order of operations
    • Arithmetic operators
    • Autofill formulas and series
  • Introduction to Pivot Tables
  • Introduction to charts
    • Bar charts
    • Pie charts
    • Line Charts
    • Formatting charts
  • Introduction to functions
    • Autosum
    • Average
    • Min
    • Max
    • Count
    • Using the function pallet
  • Printing the worksheets