Common Tips and Tricks from Mr. Biz Analyst - Online Self Learning

Common Tips and Tricks from Mr. Biz Analyst course focuses on the best practices for using Excel as a data analysis tool. Keep a close watch as we reveal some of the interesting facts and tricks of MS Excel 2013.

USD 199

Enroll
1-year e-learning access
Exercises and Data sets
Simulated Mock Exams

Course Description

Microsoft Excel just might be the ultimate piece of software ever developed. Enormous portion of the economy rely on the program, and becoming skilled at Excel has become a license to grow in the business. So while there are a lot of basic tricks that you have to know, there are also a few tricks that will set you head and shoulders above the competition.

This course explains powerful tools that have become engrained in business processes worldwide. Businesses will continue to use Excel as a primary tool for diverse functions and applications ranging from IT projects to company anniversaries and party times.

The industries and functional specializations such as Information Technology, Administration, accounting, Finance, Marketing, Operations, Human Resource Management, Health care benefit the most by using Excel.

  • High impact, proven training – 30000+ professionals trained globally

  • Experienced, expert instructors – Our Instructors come with a rich, 10+ years of industry experience.

  • Classroom Training programs delivered across 50+ locations globally

  • Content is developed in-house in GreyCampus by highly experienced industry experts

Course Objectives

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:

  • Understand Excel’s backstage view

  • Appreciate some of the frequently used functions in Excel

  • Explore the protection features of Excel

  • Work with Business data and prepare relevant Charts

Course Inclusion

  • 1-year e-learning access

  • Audio video lectures

  • Exercises

  • Data sets

  • Mock Exams and End of module tests

  • Additional material

  • 5 PMI PDUs for PMP credential holder.

Course Inclusion

  • Understanding Cell References

  • The Backstage view - Analysis Perspective

  • Excel protection features (password Protecting sheets, and hiding Formula)

  • Exporting Excel data to other formats - CSV, PDF, and others

  • Tabs, Toolbars and Ribbons

  • Entering Formulas - Thumb Rules

  • Best Practices for Spreadsheet Models

  • Frequently used Functions in Excel

  • Creating and formatting Charts containing business data

  • Formatting data as Tables

FAQs

Q. What are the Pre-requisites for this course?

A. Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment.

Q. How do I get certified?

A. Visit the page for more details:

https://www.microsoft.com/learning/en-in/exam-77-420.aspx

Please note – This module only covers a part of the actual MOS curriculum.