Business Intelligence BI using Microsoft Excel
$100 | Created by Institute of Investment Banking | Last Updated 11/2018
Duration: 5 hours | Video: h264, 1280x720 | Audio: AAC, 44 KHz, 2 Ch | 2.4 GB
Genre: eLearning | Language: English + Sub | 35 Lectures

Learn Sorting Algorithm, Filtering, Conditional Formatting, Data Charts in Excel, Pivot Table and Data table in details

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
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.

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 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.

Who is the target audience?
Students
Working Professionals
Data Analysts
Business Analysts