Advanced Spreadsheets teaches you skills that can be used to produce sophisticated reports, to perform complex mathematical and statistical calculations, and to improve productivity using a spreadsheet application.
Category
Formatting
Skill Set
Task Item
Category
Formulas and Functions
Skill Set
Task Item
Use date and time functions: today, now, day, month, year.
Use logical functions: and, or, not.
Use mathematical functions: rounddown, roundup, sumif.
Use statistical functions: countif, countblank, rank.
Use text functions: left, right, mid, trim, concatenate.
Use financial functions: fv, pv, pmt.
Use lookup functions: vlookup, hlookup.
Use database functions: dsum, dmin, dmax, dcount, daverage.
Create a two-level nested function.
Use a 3-D reference within a sum, average, minimum, maximum function.
Category
Charts
Skill Set
Creating Charts
Task Item
Skill Set
Formatting Charts
Task Item
Re-position chart title, legend, data labels.
Change scale of value axis: minimum, maximum number to display, major interval.
Change display units on value axis without changing data source: hundreds, thousands, millions.
Format columns, bars, pie slices, plot area, chart area to display an image.
Category
Analysis
Skill Set
Task Item
Create, modify a pivot table/datapilot.
Modify the data source and refresh the pivot table/datapilot
Filter, sort data in a pivot table/datapilot.
Automatically, manually group data in a pivot table/datapilot and rename groups.
Use one-input, two-input data tables/multiple operations tables.
Skill Set
Skill Set
Task Item
Category
Validating and Auditing
Skill Set
Category
Enhancing Productivity
Skill Set
Task Item
Name cell ranges, delete names for cell ranges.
Use named cell ranges in a function.
Activate, deactivate the group mode.
Skill Set
Linking, Embedding and Importing
Category
Collaborative Editing
Skill Set
Reviewing and Security