Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Integrated Excel For Advanced Analysis and Reporting to your Wishlist.

Add to Wishlist

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.
9 students enrolled
Last updated 2/2016
English
$10 $80 88% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • 1 Article
  • 50 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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
View Curriculum
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 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 77 Lectures Collapse All 77 Lectures 06:28:25
+
Introduction
2 Lectures 08:14
+
Lookup Functions
4 Lectures 28:24
VLOOKUP Function exact match to extract values from a table
08:09



HLOOKUP inexact match
06:47
+
Index and Match Functions
5 Lectures 22:44
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 Functions
10 Lectures 01:05:34
IF Function to calculate a conditional result
10:18

Nested IF Function for results based on multiple conditions
03:38


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 Function
2 Lectures 12:40
Text Function to format numbers
09:54

Text Function to format dates
02:46
+
IS Functions
3 Lectures 10:46

ISBLANK Function to check if formula refers to blank cell
02:40

ISERROR Function to check if calculation is an error
03:35
+
Text Strings
19 Lectures 01:42:17
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
+
Scenarios and Goal Seek
5 Lectures 16:41
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
+
Pivot Tables
16 Lectures 01:20:25

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 percentage of values
03:48

Pivot Chart
05:29

Frequency table and chart
05:11
+
Financial Functions
4 Lectures 19:52
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
1 More Section
About the Instructor
4.5 Average rating
1 Review
9 Students
1 Course
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

Report Abuse