Intermediate/Advanced Excel for Business Users

How to use Microsoft (c) Excel Differently for Breakthrough Performance
0.0 (0 ratings) 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.
3 students enrolled
Instructed by Jason Khoo IT & Software / Other
$45
Take This Course
  • Lectures 33
  • Contents Video: 2 hours
  • Skill Level Intermediate Level
  • 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 3/2015 English

Course Description

A solution-based Microsoft® Excel course tailored for managers and executives who are seeking practical solutions to their Excel problems in raw data management, business analysis and reporting.

  1. This Excel course is conducted based on business case studies to facilitate your understanding of the commonly used functions and worksheet functions and how these functions are applied in business.
  2. It is a tried and tested course from face to face workshops which has been running for a number of years. It has received rave reviews for introducing new perspectives to the way Excel is used, tips & tricks that help you complete the usual Excel tasks in double quick time.
  3. The course is designed to show you the entire process of preparing an Excel report, starting from cleaning up of raw data downloaded from the system to generating a Pivot Table report for analysis, and Pivot Chart for presentation.
  4. The course aims to help you acquire the skills of building complex formulas like an Excel expert.

The entire course is 90 minutes long and it is divided into mini videos so that you could watch them using pockets of free time you have between your activities.

What are the requirements?

  • They must have some basic to intermediate knowledge of Excel i.e. navigate around a worksheet, format cells, auto-filter, sorting, create a simple template and enter simple formulas (e.g. SUM) into the worksheet.

What am I going to get from this course?

  • •Apply useful built-in functions in Excel to process data and enhance the usefulness of the data.
  • •Apply the function learnt to consolidate records.
  • •Acquire skills to analyse the records for operations and reporting purposes.
  • •Employ new ways of tabulating and managing data.

What is the target audience?

  • Managers and Executives who have to manage, analyse and prepare reports using data downloaded from systems. They must have some basic to intermediate knowledge of Excel i.e. navigate around a worksheet, format cells, auto-filter, sorting, create a simple template and enter simple formulas (e.g. SUM) into the worksheet.
  • This is not a beginner course and those who do not have practical Excel Experience should not take this course

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: Identify and Clean up Raw Dates
Identify and clean up dates
Preview
03:27
Combining the day, month and year to create an Excel date
Preview
02:51
Calculating the age of the customers
Preview
04:14
Filter records based on pre-defined conditions
03:41
Count the records of visible cells only
02:17
Count the records of visible cells only
03:44
Find the oldest person born in a selected month
02:34
Differentiating customers based on cut-off age
05:51
Making Excel auto-highlight the row based on your criteria
04:10
Section 2: Select Required Recods in the Shortest Time
Filter records using a range
04:14
Highlighting the filtered records
02:23
Section 3: Building complex formulas
Retrieve Part of a Text From a Cell
04:59
Retrieve Text of Varying Length Intelligently
03:26
Combine Records From 2 Worksheets Together
05:59
Creating a Total for Each Group of Companies (Part I)
04:11
Creating a Total for Each Group of Companies (Part II)
02:31
Highlighting the Subtotal Rows All At Once
02:34
Separate Text in a Cell in 3 Simple Steps
02:38
Combining Data from 2 Worksheets Together
12:04
Remove Duplicates in a List
02:19
Create Totals & Averages For Each Industry Class
04:18
Section 4: Create and Manage Pivot Tables Using Data from an Excel Spreadsheet
Create a Pivot Table Using Data from an Excel Spreadsheet
05:33
More Pivot Table Options
04:50
Format & Sort Pivot Table
03:41
Section 5: MS Query in Pivot Tables
Connect to the Source Database
04:23
Format Pivot Table Created From Database
02:46
Analyzing Monthly Sales Trend
04:56
Using Pivot Chart
04:05
Section 6: Introduction to Maro Programming
Creating & Storing Macro
03:48
Delete the Macro from the Personal Macro Workbook
01:58
Add the Macro to the Quick Access Toolbar (QAT)
02:03
Section 7: Consolidating Data from Multiple Sources
Add Multiple Entries & Consolidate Data
05:12
Remove Duplicate Records from the Database
01:39

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jason Khoo, Chief Trainer at everydayExcel Business Lab Pte Ltd

Jason Khoo is the author of the two books "Excel Secrets for Highly Effective Marketers", "Hidden Secrets of Data Analysis with Excel" which are sold in all the major book stores in Singapore and in online Amazon. An expert in spreadsheets and databases, Jason also founded SynergyWorks, a consultancy firm which has helped many companies extract valuable information from databases using Microsoft® Excel. He has helped companies save significant amount of money by providing solutions using existing PC applications such as MS Excel instead of purchasing new systems. His clients include multi-nationals corporations such as Discovery Asia, 3M, NCS, Cold Storage, Nippon Paint Singapore, Heinz Asean, Tanah Merah Country Club, and etc.

Ready to start learning?
Take This Course