Scribd
Upload
36 views4 pages

Excel Assignment - 2018

The document outlines a 6 day Excel training course covering topics such as creating and formatting worksheets, building formulas, charts, pivot tables, sorting and filtering data, removing duplicates, validating data, and using macros. Each day focuses on different chapters and covers specific skills like creating tables, conditional formatting, basic formulas, column and bar charts, line and scatter plots, pivot tables, sorting, filtering, and macro recording. The goal is to check the participant's current Excel level and teach them essential skills for working with data in Excel.

Uploaded by

Bao Ngoc Nguyen
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
36 views4 pages

Excel Assignment - 2018

The document outlines a 6 day Excel training course covering topics such as creating and formatting worksheets, building formulas, charts, pivot tables, sorting and filtering data, removing duplicates, validating data, and using macros. Each day focuses on different chapters and covers specific skills like creating tables, conditional formatting, basic formulas, column and bar charts, line and scatter plots, pivot tables, sorting, filtering, and macro recording. The goal is to check the participant's current Excel level and teach them essential skills for working with data in Excel.

Uploaded by

Bao Ngoc Nguyen
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Excel Assignment

Day 1

Check Excel level

Item Unit Price Quantity Price (before tax) Price with Tax
ballon 5000 35
key 20000 10
shirt 120000 2
jean 300000 2
hat 70000 5

Total
Chapter 2

1. Creating a Worksheet from a Template (p. 33 – p.38)


2. Creating a Basic Worksheet from Scratch (p. 38 – p40.)
3. Grouping Data in Tables (p. 57)
a. Filtering and sorting table data
b. Customizing your table

DAY 2

Chapter 3

1. Formatting Data for Clarity and Understanding (p. 63)


2. Using conditional formatting (p. 67)

Chapter 4:

1. Creating a basic formula (p.86)


2. Creating a formula directly in a cell
3. Creating Formulas with the Function Wizard (p. 95)
4. Adding Formulas to Multiple Worksheets at Once (p. 98)
Day 3

Chapter 5: CHART

1. Building a Basic Column Chart (p. 117)


2. Converting a Column Chart to a Bar Chart (p. 121)
3. Categorizing Data with Pie Charts (p. 124)

Chapter 5: CHART

1. Showing Progression with Line Charts (p. 130)


2. Finding Trends with Scatter Plot Charts (p. 135)

Day 4

Chapter 6: Pivoting Data

1. Creating the PivotTable (p. 155)


2. Expanding Your PivotTables (p. 159)

Chapter 10:

1. Sorting Your Data (p. 250 – p.258)


2. Filtering Your Data (p. 259 - 263)

Day 5

Chapter 11:

1. Removing Duplicate Data (p. 275 – p.280)


2. Validating Data (p. 281 – p.289)

Chapter 12: Analyzing Data using Excel

1. Setting Up Scenarios with the Scenario Manager (p. 305 – p.311)


2. Goal Seeking with Excel (p. 311 – p.314)
Day 6

Chapter 15: Programming Excel

1. Macros: Making It Easier to Do Your Work (p. 363 – p.365)


2. Repeating a Series of Steps with a Macro (p.366 – p.369)

You might also like