Integrated Excel For Advanced Analysis and Reporting

Name: Integrated Excel For Advanced Analysis and Reporting
Rating: 3.9 (13 reviews)

Learn Advanced Microsoft Excel with Pivot tables and interactive reporting

(13 ratings)

65 students

Created by Colossal Skills

Last updated 2/2016

English

English [Auto]

30-Day Money-Back Guarantee

What you'll learn

Apply some of excel's advanced functions and features for efficient data analysis
Build interactive comments for dashboards and standard reports
Use some of excel's most powerful features and tools to achieve effective reporting
Create reports with a visual impact and lasting impressions

Requirements

Have Microsoft Excel 2013 , Windows 7,8 ,XP or vista
Though prepared with Ms Excel 2013, most of the lectures are compatible with MS Excel 2010 and MS Excel 2007

Description

This course is made up of over 70 video lectures, divided into 11 sections and is more than 6 hours long. Assuming that the student takes one lecture per day, this course will take approximately 2 and half months to complete. More lectures can however be taken in a day, which enables the student to complete in a shorter period. It is advisable to practise and apply the excel functions in order to firmly grasp these functions and tools

The course is designed for excel users with basic skills and would like to upgrade their skills to advanced level. As the course name "Integrated Excel for Advanced Analysis and Reporting" suggests, the main focus is on analysis of data and reporting using Excel's advanced functions and tools. The course will benefit mostly those students involved in analysis and reporting functions. Nonetheless, as the course covers Excel's key functions used in most organisations, the course still adds value even to users in other spheres

Who this course is for:

Users with basic excel skills and want to take their skills to advanced level
Professionals who want to refresh and improve their advanced excel skills

10 sections • 77 lectures • 6h 28m total length

Preview08:04
Working Files
00:10

VLOOKUP Function exact match to extract values from a table
08:09
Preview05:53
Preview07:35
HLOOKUP inexact match
06:47
INDEX and MATCH Functions introduction
05:01
INDEX Function basic form to return value at the intersection
04:22
INDEX Function reference form
05:24
MATCH Function to determine row number
02:18
INDEX and MATCH combined to replace the VLookup function
05:39

IF Function to calculate a conditional result
10:18
Nested IF Function for results based on multiple conditions
03:38
Preview09:23
OR Function and OR combined with IF
07:54
SUMIF to add cells based on one condition
05:03
SUMIFS to add cells based on multiple criteria
07:18
COUNTIF Function to count conditionally
06:46
COUNTIFS for counting based on multiple criteria
04:02
AVERAGEIF Function
03:31
IFERROR Function to suppress error values
07:41

Text Strings - Introduction
01:32
CONCATENATE Function to join text strings
08:02
CONCATENATE to create interactive report commentary
12:36
Ampersand operator in place of concatenate
04:32
Ampersand to create interactive report commentary
11:40
Text to columns for splitting text into columns
08:25
SUBSTITUTE Function to replace text
06:47
REPLACE function to replace text
10:58
SEARCH Function to find text
06:16
FIND Function to find text
07:10
TRANSPOSE Function
04:52
LEN to determine length of text string
04:17
TRIM to remove spaces
02:23
LEFT to extract leftmost text
01:39
RIGHT to extract rightmost text
01:44
LEFT and RIGHT combined to extract middle text
02:15
MID to extract middle text
02:07
LEFT, MID and RIGHT combined
02:59
UPPER and LOWER to change case of text
02:03

Preview01:22
Create a pivot table
06:41
Summarise data using pivot calculations
08:52
Two dimensional pivot table
03:43
Update pivot table
07:13
Drilling down the values in a pivot
03:41
Moving the pivot table
03:45
Sort values in a pivot table
02:10
Pivot Filter
05:15
Slicer to replace pivot filter
05:24
Grouping and ungrouping data in a pivot
07:10
Grouping data by date in a pivot
04:58
Preview05:43
Multilevel Pivot percentage of values
03:48
Pivot Chart
05:29
Frequency table and chart
05:11

Colossal Skills

Qualified Accountants & Ms Excel Trainers

3.9 Instructor Rating
20 Reviews
102 Students
2 Courses

Colossal Skills is a South African based emerging company which provides premier quality video based and e-learning training to students world wide. The lecturers are qualified and experienced professionals with in depth and diverse knowledge and skills.

The thrust of our training is not only imparting knowledge but knowledge application with a difference

Integrated Excel For Advanced Analysis and Reporting

What you'll learn

Requirements

Description

Who this course is for:

Course content

Introduction2 lectures • 8min

Index and Match Functions9 lectures • 51min

IF Functions10 lectures • 1hr 6min

Text Function2 lectures • 13min

IS Functions3 lectures • 11min

Text Strings19 lectures • 1hr 42min

Scenarios and Goal Seek5 lectures • 17min

Pivot Tables16 lectures • 1hr 20min

Financial Functions4 lectures • 20min

Conditional Formatting7 lectures • 21min

Instructor