Essential Excel Skills for Business € 60.50 | Subscribe | Redeem Code

In this course, we are going to discuss some essential Excel skills for business.

We will start with the basics of using Excel and get ourselves familiar with the user interface of Excel.

Afterwards we discuss how to visualize and forecast data using Trendline. Then we discuss in depth data filtering techniques with special attention to SUBTOTAL and AGGREGATE. In the last part of this course, we discuss VLOOKUP and related functions.

You can adjust playback speed when you watch a video. Most videos contain closed captions, which can be turned on in the video player toolbar.

Progress

0.00 %

Passed 0 out of 13 Tests
Upcoming Deadline

No Upcoming Deadline

Getting Started with Excel Prof. H. Zhang

In this part, we discuss the most basic Excel skills. At the end of your study, you would be able to:

  • Choose the right version of Excel to install.
  • Understand Excel user interface.
  • Use Excel Flash Fill for quick text manipulation.
  • Understand Excel cell references: absolute, relative and mixed.
  • Formatting Excel worksheets with built-in styles.

Choosing the Right Version (Length: 0:02:18 Currently at 0:00:00) Test
Self-Testing: Choosing the Right Version of Excel
Excel UI (Size: 817.71KB)
Flash Fill (Length: 0:01:37 Currently at 0:00:00) Test
UK 500 Addresses.xlsx (Size: 32.64KB)
Self-Testing: Flash Fill
Cell Reference (Length: 0:14:07 Currently at 0:00:00) Test  
Salary.xlsx (Size: 8.65KB)  
Self-Testing: Cell References
Basic Formatting (Length: 0:04:03 Currently at 0:00:00) Test  
Self-Testing: Basic Excel Formatting

Home

Basic Data Visualization and Analysis Prof. H. Zhang

In this part, we discuss basic Excel visualization and analysis skills. At the end of your study, you would be able to:

  • Create a line chart or a scatter plot.
  • Add and format chart elements.
  • Add a Trendline to fit data.
  • Understand when to work with seasonality.
  • Use FORECAST.LINEAR and FORECAST.ETS to forecast.

Charting (Length: 0:12:17 Currently at 0:00:00) Test  
Sales Revenue.xlsx (Size: 9.74KB)  
Self-Testing: Excel Charting
Trendline (Length: 0:09:43 Currently at 0:00:00) Test  
Self-Testing: Excel Trendline
FORECAST.LINEAR (Length: 0:04:21 Currently at 0:00:00) Test  
Self-Testing: FORECAST.LINEAR
FORECAST.ETS (Length: 0:09:35 Currently at 0:00:00) Test  
Soft Drink Sales (Size: 14.65KB)  
Self-Testing: FORECAST.ETS

Home

Data Filtering Techniques Prof. H. Zhang

In this part, we discuss Excel filtering techniques. At the end of your study, you would be able to:

  • Format a data set as Excel Table.
  • Understand how structured reference works.
  • Use filtering techniques to analyze data.
  • Understand how the total row works.
  • Use functions SUBTOTAL and AGGREGATE.
  • Use Advanced Filter.
  • Create formula based filters.
  • Use functions IF, AND, OR, RAND.
  • Logical operations with Boolean values.

Filtering (Length: 0:11:57 Currently at 0:00:00) Test  
HyTex (Size: 90.33KB)  
Self-Testing: Excel Filtering
Total Row (Length: 0:07:20 Currently at 0:00:00) Test  
Self-Testing: Excel Total Row
Structured Reference (Length: 0:07:21 Currently at 0:00:00) Test  
Self-Testing: Excel Structured Reference
Aggregate (Length: 0:09:09 Currently at 0:00:00) Test  
Self-Testing: Aggregate
Advanced Filter (Length: 0:08:50 Currently at 0:00:00) Test  
Self-Testing: Advanced Filter
IF, AND, OR, RAND (Length: 0:14:11 Currently at 0:00:00) Test  
Logical Operations (Length: 0:08:09 Currently at 0:00:00) Test  

Home

Lookup Functions Prof. H. Zhang

In this part, we discuss look up functions in Excel. At the end of your study, you would be able to:

  • Use VLOOKUP with approximate and exact match.
  • Use IFERROR function.
  • Apply Data Validation.

Commission Fee (Size: 24.44KB)  
VLOOKUP - Approximate Match (Length: 0:10:02 Currently at 0:00:00) Test  
TickerTable.xlsx (Size: 191.91KB)  
VLOOKUP - Exact Match (Length: 0:13:34 Currently at 0:00:00) Test  
IFERROR and Data Validation (Length: 0:06:42 Currently at 0:00:00) Test  

Home

Exercises Prof. H. Zhang

Here you will find some exercises to help you learn Excel skills that have been discussed up to now.

Exercises on Filtering (Size: 111.52KB)  
P02_03.xlsx (Size: 31.90KB)  
Income Tax Exercise (Size: 70.72KB)  
Mind Teaser (Size: 61.44KB)  

Home
Pick up from where you left.