Description

Microsoft Excel Essentials

Self-taught Excel users with basic Excel knowledge would benefit from attending the Discovering Excel Course.
In this course you will be taught how to not only develop spreadsheets using formulas and formatting but will be shown how to create charts ensuring you leave with a comprehensive knowledge of how to make Excel work for you

  • What is Microsoft Excel, the Microsoft Excel screen and the ribbon
  • File Formats and Columns and Rows
  • Working with Formulae, creating, copying and using formulae
  • Creating Multiple Views
  • Formatting and Editing Worksheets
  • Printing and Page Setup
  • Using Functions
  • Charts
  • Formula Auditing

Excel on Steroids

Excel on Steroids is a more than just an advanced Excel course, it focuses on Excel features that are key for business reporting

Who should attend?
Finance professionals: Create and analyse powerful financial reports to keep your finger on the pulse of your business
Sales professionals: Effectively track your sales against target and identify performance by sales rep, area or product
Marketing professionals: Maximize your ROI by keeping track of your campaigns
HR professionals: Utilize employee turnover reports, leave reports or training and development reports to cultivate the right environment for your people

EXCEL ON STEROIDS (Course Overview)

  • Data Analysis:
  • Tell Me Text Box
  • Smart Lookup
  • Sorting, Subtotalling and Filtering Data
  • Data Validation
  • What-If Data Analysis
  • Forecast Sheet
  • Macros
  • Formulas & Functions:
  • Data Consolidation
  • Conditional Formatting Worksheet Protection
  • Managing and Preparing Data
  • Using Cell References
  • Lookup, Text and Logical Functions
  • Statistical and Mathematical Functions
  • Date and Time Functions
  • PivotTables and PivotCharts:
  • PivotTable Basics
  • PivotTable Options
  • Formatting a PivotTable
  • Calculated Items and Fields
  • Sort & Filter a PivotTable
  • Consolidated PivotTable
  • PivotCharts and Sparklines
  • 3D Maps

In this course you will learn how to take advantage of some of the more advanced features of Microsoft ® Excel® to prepare and present your business data

Prerequisite:
A sound knowledge of the advanced features and functionality in Excel used for business reporting (prior attendance of our Excel on Steroids course qualifies you as an advanced Excel user

Learning Outcomes:

    • Create dynamic data models which will serve as the back-end of your Dashboard using advanced functions and formula.
    • Create PivotTables and Pivot Charts.
    • Explore alternative visualization techniques like sparklines and conditional formatting for at-a-glance analysis
    • Create advanced and custom charts
    • Create an interactive, macro-charged Dashboard.
    • Design meaningful Dashboard Reports catering to your audience’s requirements and goals following Dashboard design best practise

Additional information

Select Course

Microsoft Excel – Data Analysis and Dashboards, Microsoft Excel Essentials, Microsoft Excel Intermediate, Microsoft Excel on Steroids, Microsoft Excel on Steroids PLUS, Microsoft Excel Powerview & PowerPivots

Virtual Training or E-Learning

Classroom, E-Learning, Virtual

Microsoft Excel Courses

From: R1,415

Our Microsoft Excel courses include everything from Essentials, Powerview & PowerPivots, Microsoft Excel Intermediate, Microsoft Excel on Steroids and Advanced Microsoft on Steroids PLUS. Choose from E-Learning or Classroom Training.

SKU: N/A Categories: ,