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