Manage and analyze data

At the end of the training, learners will be able to:

• Understand the process of utilizing business data (Business Intelligence)
• Automate common data cleansing operations according to database standardization principles
• Efficiently combine and transform data from a variety of sources
• Permanently connect their reports to data sources, in order to automate transformation operations when updating source data

With this training, you will be able to:

• Master the Excel work environment
• Use quick methods for data entry 
• Know how to move quickly through a table
• Manipulate your rows and columns efficiently (insert, delete, show, hide, width and height)

With this training, you will be able to:

• Understand formulas and master basic mathematical operations ( + – X / )
• Understand the most used functions (SUM, AVERAGE, COUNT, COUNTIF, etc.)
• Work with references in formulas (A5, A$5, $A$5)
• Apply these calculations on multiple Excel sheets

With this training, you will be able to:

• Use formatting to customize the look and feel of your tables and reports 
• Improve the layout of your tables and reports for efficient printing
• Master the most popular conditional formatting options

With this training, you will be able to:

• Organize your data lists better and faster 
• Avoid input errors through data validation (drop-down list, etc.)
• Use simple or custom sorting and standard or advanced filters 
• Display and group the main data of a table (Outline)

With this training, you will be able to:

• Learn how to choose the right chart based on your data 
• Illustrate your different reports with graphs 
• Manipulate all elements of a chart
  (title, legend, etc.) 
• Add options to your charts
  (secondary axes, trendline, etc.)
• Save and reuse your custom templates

With this training, you will be able to:

• Calculate statistics (IF, AND, OR, SUMIF, AVERAGEIFS…) 
• Create and modify complex and nested functions
• Merge values from multiple cells into one
• Search for a value in another table according to a criterion (VLOOKUP, XLOOKUP, etc.)

With this training, you will be able to:

• Analyze and group data
• Synthesize your data by date or segments
• Correctly add new data to update a table
• Make calculations in a PivotTable
• Have a global overview of the data  in a table and keep it up to date

With this training, you will be able to:

• Save execution time with the use of macros
• Automate repetitive tasks to reduce the risk of error
• Differentiate a relative macro from an absolute macro
• Associate an icon with a macro
• Use a macro with multiple workbooks

Learn how to use Power Pivot to analyze millions of recordings.

At the end of the course, learners will be able to :

• Relate (model) your data in Power Pivot;
• Create simple calculations using DAX formulas;
• Analyze data as a pivot table or pivot chart.

At the end of the training, learners will be able to:

• Describe the applications of Power Bi and its main features;
• Import and Connect Data;
• Model and Visualize Data;
• Publish, share and collaborate on reports.