## Essential Excel Skills for Business € 60.50 | |

Progress

### 0.00 %

Passed 0 out of 13 Tests

### 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 ) Test
Self-Testing: Choosing the Right Version of Excel
Excel UI (Size: 817.71KB)
Flash Fill (Length: 0:01:37 ) Test
Self-Testing: Flash Fill
Cell Reference (Length: 0:14:07 ) Test
Salary.xlsx (Size: 8.65KB)
Self-Testing: Cell References
Basic Formatting (Length: 0:04:03 ) 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 ) Test
Sales Revenue.xlsx (Size: 9.74KB)
Self-Testing: Excel Charting
Trendline (Length: 0:09:43 ) Test
Self-Testing: Excel Trendline
FORECAST.LINEAR (Length: 0:04:21 ) Test
Self-Testing: FORECAST.LINEAR
FORECAST.ETS (Length: 0:09:35 ) 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 ) Test
HyTex (Size: 90.33KB)
Self-Testing: Excel Filtering
Total Row (Length: 0:07:20 ) Test
Self-Testing: Excel Total Row
Structured Reference (Length: 0:07:21 ) Test
Self-Testing: Excel Structured Reference
Aggregate (Length: 0:09:09 ) Test
Self-Testing: Aggregate
Advanced Filter (Length: 0:08:50 ) Test
IF, AND, OR, RAND (Length: 0:14:11 ) Test
Logical Operations (Length: 0:08:09 ) 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 ) Test
TickerTable.xlsx (Size: 191.91KB)
VLOOKUP - Exact Match (Length: 0:13:34 ) Test
IFERROR and Data Validation (Length: 0:06:42 ) 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)
P02_35 (Size: 44.35KB)
Income Tax Exercise (Size: 70.72KB)
Mind Teaser (Size: 61.44KB)

Home