Advanced Microsoft Excel

Advanced Microsoft Excel Training

Register for Advanced Microsoft Excel training today! Doing your advanced spreadsheet tasks will be never be the same again.

As a supplementary course to Microsoft Excel, Advanced Microsoft Excel training will allow students to take their learning to a higher level. Through this course, you will learn how to use Microsoft Excel to present data visually, using charts and graphs that best illustrate your data patterns. Students of this course will learn how to quickly preview presentation options, and pick those that present insights most clearly. This course will also cover how to apply formatting, sparklines, charts, and tables with a single click.

Excel when and where you need it to another level

Acceleratia Microsoft Excel Course Malaysia
Course Duration

2 Days

  • Who Should Attend

    • Accounts Clerks
    • Accounts Assistants
    • Accounts Supervisors
    • Office Administrators
    • Administrative Assistants
    • Secretaries
    • Accounting Personnel
    • For Managers, or potentially to be managers, across all business units who have little or no formal education in organizational finance and accounting for a better understanding and how to support and enhance revenue generation in their businesses


Introduction to advanced worksheet functions
  • Conditional & Logical functions
  • Counting and totalling cells conditionally
  • And, Or, Not
  • Lookup functions
Views, scenarios, goal seek, solver
  • Goal seeking And solving
  • Advanced Solver features
  • Scenarios
  • Views
Using Excel to manage lists
  • Excel list terminology
  • Sorting data
  • Subtotals
  • Filtering a List
  • Advanced filtering
  • Criteria Tips
  • Multiple criteria
  • Calculated criteria
  • Data consolidation
  • Pivottables
  • Modifying a Pivottable
  • Managing Pivottables
  • Formatting a Pivottable
  • Banding
  • Slicers
  • Introduction to charting
  • Creating charts
  • Formatting charts
  • Changing the chart layout
  • Sparklines
  • Introduction to templates
  • Create custom templates
Drawing and formatting
  • Inserting, formatting and deleting objects
  • More formatting
Excel tools
  • Reviewing
  • Auditing
  • Proofing tools
Interested in this Course?

Do you have any enquiries?