Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 6.5 hours on-demand video
  • 1 article
  • 50 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel

Integrated Excel For Advanced Analysis and Reporting

Learn Advanced Microsoft Excel with Pivot tables and interactive reporting
Rating: 4.3 out of 54.3 (9 ratings)
58 students
Created by Colossal Skills
Published 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

Course content

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 Function to format numbers
    09:54
  • Text Function to format dates
    02:46

  • Preview04:31
  • 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 - 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

  • 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

  • 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

  • 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

  • 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

Instructor

Colossal Skills
Qualified Accountants & Ms Excel Trainers
Colossal Skills
  • 4.2 Instructor Rating
  • 16 Reviews
  • 91 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


  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.