MS Excel - Data Analysis, Pivot Tables and BI

Learn Data Analysis with Sorting Algorithm, Filtering, Conditional Formatting, Data Charts, Pivot Table and Data Table

MS Excel - Data Analysis, Pivot Tables and BI
MS Excel - Data Analysis, Pivot Tables and BI

MS Excel - Data Analysis, Pivot Tables and BI udemy course

Learn Data Analysis with Sorting Algorithm, Filtering, Conditional Formatting, Data Charts, Pivot Table and Data Table

What you'll learn:

  • Learn about Sorting Algorithm in Excel, Filtering, Conditional Formatting, Data Charts in Excel
  • Hands on with Pivot Tables, Data Tables in Excel

Requirements:

  • Basic computer knowledge
  • Familiarity with the Microsoft Office work environment
  • You will need MS Excel 2013 in your PC

Description:

The course is good for students, data analysts, financial analysts, business analysts and other working professionals. The shortcuts and process used in this course will minimize the time require to solve any problems in Excel.

Business intelligence (BI) is essentially the collection of tools and processes that are used to gather data and turn it into meaningful information that people can use to make better decisions. Using Excel, you can create powerful reports, scorecards, and dashboards. You can bring data into Excel, sort, and organize data, and use it to create reports and scorecards. You can also use powerful analytic capabilities in Excel to visualize and explore data.  MS Excel - Data Analysis, Pivot Tables and BI Udemy

This training will help you learn about Sorting Algorithm in Excel, Filtering, Conditional Formatting, Data Charts in Excel, Hands on with Pivot Tables, Data Tables in Excel.

The focus of this course is to help users develop an advanced understanding of Excel Graphs and Charts features. Hence, users are required to have the following basic knowledge prior to taking up the course.

  1. Basic understanding of Windows operating system, so you’re familiar with file-handling operations. This is required for you to create Excel Workbooks, alter, and save your work in Excel.

  1. Excel Basic Course: A short introduction to Excel is needed

Who this course is for:

Course Details:

  • 5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion

MS Excel - Data Analysis, Pivot Tables and BI udemy free download

Learn Data Analysis with Sorting Algorithm, Filtering, Conditional Formatting, Data Charts, Pivot Table and Data Table

Demo Link: https://www.udemy.com/course/business-intelligence-bi-using-microsoft-excel/