Computer Training Course Outline for PC Training Experts
Home
About
Contact
Courses
Tutorials
Hot Articles
Blog
Forums
Excel Advanced Pivot Tables & Reporting Tools B
(
0.5 days
)
Wouldn't it be great if you could effortlessly format huge datasets, instantly, and access a variety of powerful tools without more than a thought? Tables can do this for you, and this is the lead-in topic to this complimentary section to Pivot Tables A section. You'll also discover the upgraded Conditional Formatting tools to effortlessly highlight important line items. You'll learn how to use the coveted VLOOKUP feature to cross-reference values in other parts of your spreadsheets, and also learn how to break up cells into smaller parts, effortlessly, with Text to Columns. This power-packed section is the perfect compliment to our Pivot Tables A section; you'll greatly expand your skillset with this amazing course!
Performance-Based Objectives
Discover the amazing power of Tables and how they can benefit Pivot Tables and all your large data sets
Learn how to use the upgraded Conditional Formatting feature to instantly highlight important line items
Effortlessly import and export Excel data with a variety of other applications such databases, text files, and even the web
Use the VLOOKUP feature to dramatically simplify your cross-referencing needs on large spreadsheets
Harness the incredible power of Text-to-Columns to easily break apart stubborn data fields into component parts
Course Outline*
Module 1: Harness the Power of Tables
Introduction to Tables
"Live Preview"
Adding Calculated Columns and Total Rows
How to insert/delete rows or columns the more effective way
Other table perks
Module 4: Creating Excel Lists or Outlines
How to create an outline list
Automatic and manual options
Clearing lists
Module 2: The Amazing Power of Conditional Formatting
How to use Conditional Formatting
Creating and Managing Rules
Instantly clearing all rules from your sheet
Create Custom Rules to suit your needs
Module 5: VLOOKUP and Other Functions
How to use VLOOKUP
the IF function
Variations of IF functions
Module 3: Importing & Exporting Data
Import data from text files or databases or the web
Export data to text files or databases
Practicality discussion
Module 6: Heavy Lifting Powertools
Create subtotal in lieu of Pivot Tables
Learn how to transpose your Data
The power of Text-to-Columns for breaking apart cell data
Create Drop-down Lists
Register
Dates Offered
Email
Print Friendly
Show All
*Note: webinar courses cover only essential topics due to time constraints. Please discuss topics with your instructor prior to webinars to ensure your necessary topics are covered.
Dates Offered
Email Me
this Outline
Print Friendly
Version
Tuition
Live, In-Person:
$147.00
Live, Webinar:
$88.20
Home
|
About
|
Contact
|
Schedule Training
|
Course Catalog
|
Blog
|
Terms of Use
|
Privacy Statement
Copyright © 2011 Mike Phillips