UrbanPro
true

Excel Reporting and Dashboard

LIVE
20 Hours

Course offered by Shiju Cherian

0 review

Objectives:
This course introduces some of the more advanced features of Excel, to enable the delegate to make the most effective use of the software, including the use of linked Workbooks. On completion of the course, the delegate will be familiar with most of the main features of Excel, including several features for Data Analysis.

Designed for -

This course is aimed at delegates who are familiar with the essentials of Microsoft Excel covered in the Level 1 and Level 2 courses and wish to extend their knowledge to make the most of the facilities available in the software.

Description:

The course covers some of the more advanced Functions, a range of Data Analysis techniques including Advanced Filter, Database Functions and Pivot Tables, and Workbook management facilities such as multiple linked workbooks, Auditing, Shared Workbooks, Protection and Templates.

Topics:

  • Managing Range Names
  • Date and Time Formulas
  • Custom Formats
  • IF and Related Functions
  • VLOOKUP and Related Functions
  • Advanced Filter / Subtotals
  • Database Functions
  • Multiple Workbooks / Consolidation
  • Data Validation
  • Auditing
  • Pivot Tables
  • Shared Workbooks / Tracking
  • Protecting Worksheets
  • Using Templates

Course Content:

Day 1

Module 1:  Managing Worksheet Data

  • Applying Formulas
  • Using Statistical Function
  • Applying Adv. Conditional Formatting (Using Formulae)
  • Applying Conditional Formatting on Charts
  • Using Range Names
  • Using Quick Analysis

Module 2: Charts

  • Using charts for graphical presentation
  • Use of various Types of Graphs
  • Customizing Charts
  • Creating Dynamic Chart
  • Using Sparkline

Module 3: Functions

  • Using Logical Function (IF / AND / OR )
  • Using Date Function (DATEDIF, DATE, EDATE, WEEKDAY, TEXT)
  • Using Conditional Functions (SUMIF / SUMIFS / COUNTF / COUNTFS / AVERAGEIF )
  • Creating Dashboard

Module 4: Analysing Data

  • Concept of Goal Seek
  • Concept of Scenario Table
  • Using Data Table

Module 5:  Managing List

  • Extracting Data using Filter
  • Using Advance Filter â?? With Formulas
  • Summarizing Data using Subtotals
  • SUBTOTAL as a FUNCTION
  • Using DATABASE Function
  • Using TABLES

Day 2:

Module 6:  Summarizing Report

  • Using Pivot Data Table
  • Using Recommended Pivot
  • Using Pivot Charts
  • Customizing Pivot Report â?? Using Calculated Field
  • Using Slicers
  • Pivot Table using Multiple Consolidated Ranges
  • Using VLOOKUP / Nested VLOOKUP / VLOOKUP WITH IF LOGIC
  • Using HLOOKUP
  • Using INDEX / MATCH Function
  • Using INDIRECT FUNCTION
  • Using OFFSET Function
  • Introduction to Power Pivot Addins

Module 7: Working with Multiple Workbooks

  • Create a Workspace
  • Consolidate Data
  • Managing Linked Cells in Different Workbooks

Module 8: External Data

  • Import Data from External Data Source
  • Export Data to External Data Source
  • Pivot Table using External Source

Module 9:  Automating Report

  • Introduction to Macros
  • Understanding Objects / Properties / Method
  • Excel as Application Object - Hierarchy
  • Introducing to Recording Macros â?? Absolute and Relative
  • Introducing to VB Editor
  • Customizing Recorded macro.

About the Trainer

Shiju Cherian picture

Avg Rating

0 Reviews

0 Students

1 Courses

Shiju Cherian

GNIIT

12 Years of Experience

12+ Years of Experience in Corporate as Trainer imparting Training on Office Suite and MS Project.

Students also enrolled in these courses

LIVE
1 Hours

Course offered by Ankush R Saeel

0 review
LIVE
15 Hours

Course offered by Vidyesh

0 review
LIVE
20 Hours

Course offered by Vidyesh

0 review

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Excel Reporting and Dashboard by Shiju Cherian

Shiju Cherian picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Excel Reporting and Dashboard by Shiju Cherian

Shiju Cherian picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more