• Have you hired new staff and need them to sharpen their Excel skills
• Are you finding Excel to be frustrating, not knowing how to get things done effectively and efficiently?
• Do you feel you are lacking Excel support?

Start your Excel journey well! Join us as we help give new Excel users a back-to-basics foundation in using Microsoft Excel.

NOTE: This is a practical session whereby the presenter will demonstrate various Excel functions and features.

• Enabling delegates to:
• Open and create Excel workbook files
• Use the Excel interface
• Enter and edit data in a variety of ways
• Understand basic formulas and functions
• Use the new Quick Analysis feature
• Format worksheets and data
• Print and share workbooks

Content:

• Introduction: Terminology / layout and interface / move or copy sheets / Status Bar / Print Preview / Formatting / Format Painter / various ways to Paste data
• Recovering Lost Documents: Saving documents / Attaching to emails / Auto-save function / Finding lost documents.
• Built in Templates: Budgets / expense tracker / invoices.
• Navigating Seamlessly: Freeze panes / Quick access toolbar / How to navigate without a mouse / Line breaks.
• Data Editing: Adding filters and sorting
• Building Formulae: Useful everyday formulae / functions, Mathematical operators within Excel.
• Tables / Graphs: Quick analysis / charts.
• Printing: Set print area.

Who Should Attend:

• Delegates that make use of Microsoft Excel as part of their daily work duties in a receptionist capacity or other administrative area
• Delegates that are involved in various finance fields including auditing, accounting, taxation and financial management.
• Delegates that prepare reports and need to be able to edit text and numbers.