By the end of this course, you will be able to:

• Identify the need for thinking differently to get the most out of Excel
• Discuss the procedure for using the camera tool in Excel
• Summarize the various development principles
• Identify the multiple tips for formula editing in Excel
• Describe the working principle behind the Excel Calculation Engine
• Recognize the ways of writing better formulas in Excel
• Explain the various LOOKUP functions used in Excel
• Outline the methods of using array formulas in Excel

By the end of this course, you will be able to:

• Identify the main rules and the advantages of using Excel tables
• Describe the Excel function that allows making decisions easier
• Distinguish between the sorting and decision functions
• Outline the concept of data aggregation
• Explain the process of creating filters on Excel tables
• Compare the pros and cons of Excel Form and ActiveX controls
• Summarize the shortcomings of classic Excel development
• Discuss the notion of formula-driven development

By the end of this course, you will be able to:

• Explain the concept of dashboards
• Identify the functions of interactive dashboards in MS Excel
• Discuss the dynamics of information–transformation–presentation in the context of interactivity
• Explain how to set up, format and maintain an interactive legend dashboard
• Describe how to set up, format and maintain an interactive chart dashboard
• Outline the procedure for setting up, formatting and maintaining an interactive dashboard
• Describe the importance of visual perception in the process of presenting information
• Outline the concept of the Gestalt laws of grouping
• Identify the various tips for using special and bullet charts
• Recognise the need for using data visualisation
• Explain the advantages of infographics in MS Excel

By the end of this course, you will be able to:

• Identify the various tips for formula editing in MS Excel
• Describe the working principle behind the MS Excel calculation engine
• Describe how to write better formulas in Microsoft Excel
• Identify the main rules and the advantages of using MS Excel tables
• Distinguish between the sorting and decision functions
• Analyse the pros and cons of MS Excel Form and ActiveX controls
• Discuss the notion of formula-driven development
• Explain the concept of dashboards
• Discuss the dynamics of information–transformation–presentation in the context of interactivity
• Describe the importance of visual perception in the process of presenting information
• Identify the various tips for using special and bullet charts
• Explain the advantages of infographics in MS Excel

By the end of this course, you will be able to:

• Define the concept of data visualization
• Discuss the differences between Data graphics and infographics
• Explain the principles of data visualization
• State the guidelines for tables and charts
• Describe the procedure of adding a developer tab and a camera tool
• Outline the pros and cons of sparklines and heatmaps
• Summarize the different types of KPI charts
• Identify the process of creating infographics in Excel
• Indicate the process of creating a Checkbox and a Tornado Drilldown Dashboard

By the end of this course, you will be able to:

• Discuss the history of the Microsoft Excel Power Query tool
• Explain the process of manipulating data with Power Query in Excel
• Summarize the steps for wrangling data to solve various problems
• Define the concept of M code
• Indicate the process of locating the M code
• Outline the Power Query features and items
• List the stages involved in merging several datasets from various systems
• Describe how to change the sample file
• Summarize the process of combining data from other folders

By the end of this course, you will be able to:

• List the most frequently used lookup and decision formulas
• Outline the methods for creating and applying formulas in a spreadsheet to locate specific data
• Identify the correct formula for calculating a specific value, counting cells, or adding the provided data
• Explain the syntax of several new Excel functions
• Discuss the concept of named ranges
• Outline the tools that can be used to customize the named ranges
• Recognize the range operators that appear in the formula syntax
• Describe the operations that may be performed within an Excel table
• Discuss the mechanics of a pivot table and its capabilities
• Summarize the steps for counting, averaging, and running totals with pivot tables
• Explain how to use filters, slicers, timelines, and pivot charts to display dynamic views of data
• Describe the process of creating a pivot chart

By the end of this course, you will be able to:

• Analyze the Power BI workflow
• Describe different Power BI visualizations
• Outline the stages involved in building an interactive dashboard
• Identify and create various types of charts in Power BI
• Define the concept of M code and indicate the process of locating it
• Outline the Power Query features and items
• List the stages involved in merging several datasets from various systems
• Recognize how to change the sample file and combine data from other folders
• Explain the DAX language concept
• Describe the benefits and drawbacks of implied measures
• Discuss the capabilities of time-intelligence functions
• Classify the parameters used in Power BI and illustrate their functions