Integrated Excel For Advanced Analysis and Reporting

Learn Advanced Microsoft Excel with Pivot tables and interactive reporting
4.5 (1 rating) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
8 students enrolled
$19
$80
76% off
Take This Course
  • Lectures 77
  • Length 6.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2016 English

Course 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




What are the 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

What am I going to get from this course?

  • 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

What is the target audience?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction - Course Structure
Preview
08:04
Working Files
Article
Section 2: Lookup Functions
VLOOKUP Function exact match to extract values from a table
08:09
VLOOKUP Function inexact match
Preview
05:53
HLOOKUP exact match to extract values from a table
Preview
07:35
HLOOKUP inexact match
06:47
Section 3: Index and Match Functions
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
Section 4: IF Functions
IF Function to calculate a conditional result
10:18
Nested IF Function for results based on multiple conditions
03:38
AND Function and AND combined with IF
Preview
09: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
Section 5: Text Function
Text Function to format numbers
09:54
Text Function to format dates
02:46
Section 6: IS Functions
ISNUMBER Function to check if value is a number
Preview
04:31
ISBLANK Function to check if formula refers to blank cell
02:40
ISERROR Function to check if calculation is an error
03:35
Section 7: Text Strings
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
Section 8: Scenarios and Goal Seek
Creating Scenarios
05:18
Scenario analysis results
02:14
Scenario summary
02:35
Add,edit and delete scenarios
02:58
Goal Seek for calculating input required to achieve given result
03:36
Section 9: Pivot Tables
Introduction to pivot table
Preview
01: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
Multilevel Pivot
Preview
05:43
Multilevel Pivot percentage of values
03:48
Pivot Chart
05:29
Frequency table and chart
05:11
Section 10: Financial Functions
FV for calculating future value
08:14
PV to determine present value
03:34
PMT to calculate periodic payment
03:48
RATE to calculate interest in a loan or investment
04:16
Section 11: Conditional Formatting
Introduction to conditional formatting
01:14
Greater or Less than through conditional formatting
04:04
Conditional formatting to identify duplicate values
03:14
Conditional formatting to identify top or bottom values
02:24
Data bars to add visual impact to a report
02:45
Icon sets to enhance data visualisation
05:33
Clearing the rules of conditional formatting
01:34

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jeffrey Misihairabwi, Qualified Accountant & Ms Excel Trainer

Jeff is a qualified accountant with a passion for part-time training in Ms Office, Excel in particular, and accounting. He has worked in the financial sector for more than 10 years, in different financial roles

Jeff provides part time training in Ms Excel , financial and management accounting to university students and professionals

Ready to start learning?
Take This Course