Name: Excel: Using Tables to Manage Excel Databases
Overall Rating:
Category: All Learners
Duration: 1.50 hour(s)
Individual Fee: $25.00

Have you struggled to use PivotTables, and Excel formulas and functions like VLOOKUP, SUMIF, etc.? The struggle is for one reason; your data is in the wrong format. Join this webinar to learn how to analyze large data sets in Excel, how to set up data in the perfect format and to learn about the tools to best utilize that data.

A table is a powerful feature to group your data together in Excel. Think of a table as a specific set of rows and columns in a spreadsheet. You can have multiple tables on the same sheet.

You might think that your data in an Excel spreadsheet is already in a table simply because it's in rows and columns. However, your data isn't in a true "table" unless you've used the specific Excel data table feature.

This Development Activity has not been scheduled.
College of Lake County
19351 West Washington Street
Building E, Suite E186
Grayslake, IL 60030
United States
Do and Show: Important tasks or skills you will be able to perform and demonstrate to others.

We will do a deep dive into how to organize data in Excel for analysis using Excel’s Table feature, which offers numerous opportunities to vastly improve the integrity of your worksheets

Topics
  • Setup a usable database
  • Navigate a large database
  • Use Data Validation to create drop down lists for easy data entry
  • Import a text file into Excel
  • Learn the benefits of tables
  • Create and modify tables
  • Add and delete data in a table
  • Calculate data in a table
  • Use the table’s total row
  • Convert tables to normal ranges of data and why
  • Summarize table data with a PIvotTable
  • Learn the benefit of refreshing PIvotTables based on tables

SkillPrerequisiteExpected Outcome
Excel1 - BeginnerNot specified
Excel Advanced1 - BeginnerNot specified
Excel Intermediate1 - BeginnerNot specified

Cathy Horwitz

Years of Experience: 44+ years 

Area of Expertise: Microsoft Office

Class Costs
Class ValueNo Charge
Individual Fee$25.00
Private Class Fee$0.00
No reviews have been provided for this development activity.
To enter a review for this development activity, select Add above