MS Excel - Data Analysis, Pivot Tables and BI
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.
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.
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.
Excel Basic Course: A short introduction to Excel is needed
Who this course is for:
- Students
- Working Professionals
- Data Analysts
- Business Analysts
Instructor
- 3.7 Instructor Rating
- 3,382 Reviews
- 99,343 Students
- 32 Courses
Banking and Finance School (BFS) offers a comprehensive range of professional Online Courses and Classroom Programs in Finance and Investment Banking. BFS is the Premier Finance Training Provider around the world. BFS has built a strong online platform and caters to self-paced learning, online learning and classroom mode of learning. Our courses are taught by industry experts. Our courses are driven by a constant need to be job relevant and stimulating, taking into consideration the dynamic nature of the Financial Services and Analytics market. We empower you with practical knowledge through our courses. With us, you get the intensive experience that will expose you to new challenges, and innovative ideas to perform better in your career. We've been offering our courses for more than a decade and our alumni are already doing a remarkable job across the globe. Our academic excellence goes beyond theoretical knowledge or setting you up to memorize things, our courses are built around applied Finance. We're proud of people who give us their time and commitment. We're looking for people who are ready to level up, who care to up-skill and re-skill with changing time and work demand. One thing we preach is that any learning needs focus, commitment, and consistency. Come and Join our courses and take a leap.