Adv Excel & Dashboard Reporting

By attending this course, you will learn how to apply data analysis techniques to improve your operational and project based work. You will be able to review a range of tools and choose the right ones for the particular application and produce analyses and diagrams that make your reports and business cases easier to read and more effective.

Microsoft Excel is one of the most widely used applications in business. It’s the backbone for almost all companies.

Course Objective

This course covers how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions and use the sorting and filtering features to manage and analyse data

Course Content

• Conditional Formatting
• Sorting Data
• Filtering Data
• Filling Data
• Pivot Tables
• Dynamic table (New feature)
• Charting Techniques
• Creating Charts
• Advance Validation
• Text options
• Macros
• File / Data Security
• Formulas
• Formula Referencing
• Logical Functions
• Lookup Functions

Learning Outcome

• Use the fill operations available to fill a data series
• Understand and use formula cell referencing to create more complex formulas
• Use a range of logical functions
• Apply conditional formatting to ranges in a worksheet
• Create and use labels in a workbook
• Work with various elements of a worksheet
• Use a range of techniques to work with worksheets
• Use a range of find and replace techniques
• Apply a variety of page setup techniques
• Sort data in a list in a worksheet
• Filter data in a table
• Create effective charts in Microsoft Excel
• Use a range of techniques to enhance charts
• Apply formatting techniques to text on charts