Intermediate/Advanced Excel for Business Users
How to use Microsoft (c) Excel Differently for Breakthrough Performance



MP4 | Video: 1280x720 | 49 kbps | 44 KHz | Duration: 3 Hours | 446 MB

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.

Curriculum

Section 1: Identify and Clean up Raw Dates
Lecture 1   Identify and clean up dates
Lecture 2   Combining the day, month and year to create an Excel date
Lecture 3   Calculating the age of the customers
Lecture 4   Filter records based on pre-defined conditions
Lecture 5   Count the records of visible cells only
Lecture 6   Count the records of visible cells only
Lecture 7   Find the oldest person born in a selected month
Lecture 8   Differentiating customers based on cut-off age
Lecture 9   Making Excel auto-highlight the row based on your criteria

Section 2: Select Required Recods in the Shortest Time
Lecture 10   Filter records using a range
Lecture 11   Highlighting the filtered records

Section 3: Building complex formulas
Lecture 12   Retrieve Part of a Text From a Cell
Lecture 13   Retrieve Text of Varying Length Intelligently
Lecture 14   Combine Records From 2 Worksheets Together
Lecture 15   Creating a Total for Each Group of Companies (Part I)
Lecture 16   Creating a Total for Each Group of Companies (Part II)
Lecture 17   Highlighting the Subtotal Rows All At Once
Lecture 18   Separate Text in a Cell in 3 Simple Steps
Lecture 19   Combining Data from 2 Worksheets Together
Lecture 20   Remove Duplicates in a List
Lecture 21   Create Totals & Averages For Each Industry Class

Section 4: Create and Manage Pivot Tables Using Data from an Excel Spreadsheet
Lecture 22   Create a Pivot Table Using Data from an Excel Spreadsheet
Lecture 23   More Pivot Table Options
Lecture 24   Format & Sort Pivot Table

Section 5: MS Query in Pivot Tables
Lecture 25   Connect to the Source Database
Lecture 26   Format Pivot Table Created From Database
Lecture 27   Analyzing Monthly Sales Trend
Lecture 28   Using Pivot Chart

Section 6: Introduction to Maro Programming
Lecture 29   Creating & Storing Macro
Lecture 30   Delete the Macro from the Personal Macro Workbook
Lecture 31   Add the Macro to the Quick Access Toolbar (QAT)

Section 7: Consolidating Data from Multiple Sources
Lecture 32   Add Multiple Entries & Consolidate Data
Lecture 33   Remove Duplicate Records from the Database


压缩包截图：