This course is intended for the data analysts and end users who are willing to explore the self-service business intelligence tools in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers.

Microsoft Excel is by far the world’s most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building sophisticated financial models or designing complex dashboards. Most BI, CRM & Analytics products in the market use an “export to Excel” feature as their selling proposition. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel’s data analysis features to the maximum, rather than focusing on individual Excel functions and features.Since most of the organizations already have highly skilled Excel users, they migrate swiftly to a self-service BI capability and tend to create their own BI solution intuitively without much dependence on IT. Whether you are new to Excel or an advanced user, Certybox Excel courses will cover what you need to know to become an Excel Power User.

Some knowledge about basic data warehousing and data modelling concepts would be an added advantage. Working knowledge with Excel is mandatory.

Not mandatory. However, people with such background would be able to apply the concepts easily to their working environment.

All business professionals, developers, data analysts, project managers and other IT professionals can take up this course.

The latest options and tools introduced in the MS Excel 2013 helps you generating Pivot Tables and Charts from complex datasets, implement Slicers and Sparklines to dashboards, use ‘What-If-Analysis’ and Data representation techniques and many more that will be covered in the Training.
Learning Ms Excel is useful for everything from analysing basic household budgets to building sophisticated financial models or designing complex dashboards.
COURSE OBJECTIVE
At the end of the training the participants would learn/use/acquire the following techniques/ knowledge:
  • Excel Advancements – some amazing features incorporated only in last few years
  • Generating Pivot Tables and Charts from complex datasets, instantly
  • Implementing Slicers and Sparklines to build interactive dashboards
  • Exploring Data Validation techniques and creating dynamic lists
  • Using ‘What-If-Analysis’ and Data representation techniques
  • Explore and connect to data sources using Power Query
  • Extract and transform data using Power Query
  • Comprehend the Power Pivot user interface
  • Build a cascading relationship and manage data models
  • Build a relationship between tables from different sources
  • Build a report using Power View
  • Hide columns, sort, change data types, and filter

Course Curriculum

INTERESTING FEATURES OF MICROSOFT EXCEL
Exploring Volatile functions and other lesser known functions 00:00:00
Protecting data and implementing restricted access 00:00:00
Formula Auditing and Tracking Changes 00:00:00
Data Import and Export utilities 00:00:00
Comparing Excel files – a case study 00:00:00
DATA FORMATTING AND STYLES
Converting text to columns 00:00:00
Using Flash Fill, Quick Analysis and chart recommendations 00:00:00
Exploring Accessibility tools 00:00:00
Conditional Data Formatting 00:00:00
Interactive approach to Conditional formats 00:00:00
Exercise – Conditional Formatting 00:00:00
DATA VISUALIZATION CONCEPTS (CHARTS AND GRAPHS)
Understanding Data Visualization concepts and principles 00:00:00
Creating effective charts — using thought starter 00:00:00
Exploring new components of Charts ¡n MS Excel 00:00:00
Exercise – Creating Dual Series Chart (implementing Pareto Analysis) 00:00:00
SLICING AND DICING OF DATA - SOME POWERFUL TECHNIQUES (ADV. CHARTS & DASHBOARDS)
Creating Pivot Tables using complex datasets 00:00:00
Generating Pivot Charts Instantly 00:00:00
Implementing Slicers to build Interactive dashboards 00:00:00
Beautifying reports / tables using Sparklines 00:00:00
ADVANCED DATA VALIDATION AND ANALYSIS
Exploring Data Validation techniques and controlling inputs 00:00:00
Creating dynamic lists using data validation and Name Ranges 00:00:00
What-If-Analysis tools – Goal Seek, Data Table, Scenario Manager 00:00:00
EXPLORING IDE OF MS EXCEL AS AN AUTOMATION TOOL
Introduction and classification of Macros 00:00:00
Overview VBA IDE – components and features 00:00:00
VBA Modules – Coding simple Sub Procedures in VBA 00:00:00
Working with Objects (Properties, Events & Methods) 00:00:00
Application, Workbook, Worksheet & Range Objects 00:00:00
AUTOMATION USING EXCEL MACROS AND VBA
Recording simple Macros 00:00:00
Introduction to Error Handling 00:00:00
Editing Recorded Macros 00:00:00
Debugging Program Code 00:00:00
EXPLORING POWER TOOLS OF EXCEL (POWER PIVOT & POWER VIEW)
Steps involved in designing and managing data models 00:00:00
Introduction to Power Pivot tool to create instant Data Models and link tables 00:00:00
Define entity relationships and check cardinality 00:00:00
Develop Interactive Dashboards using Power Views 00:00:00
Using Timelines and Tab views for Dashboards 00:00:00

Course Reviews

5

5
8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

Copyright © 2019 Certybox All Rights Reserved