Managing Databases in Excel
Duration: 90 minutes
Speaker: Melissa Esquibel
Webinar Description
When many people think about “Microsoft Office” and “databases,” they think about Microsoft Access. Access is the right tool for the right job, if the right job is relational databases. But Microsoft Excel, with its available robust features, can do many database jobs. If you don’t have access to Access or simply don’t have time to learn a new tool, Managing Databases in Excel, with Microsoft Certified Trainer, Melissa Esquibel, will give you strategies to manage your databases without Access. You’ll learn how to:
-
Transform your unruly data into a “database”
-
Solve 3 “big list” issues with Table Style formatting
-
Create formulas to access your database for forms and queries
-
Add new records without scrolling (and scrolling and scrolling)
-
Get reports from your data in just a couple of clicks
-
Stop fighting your big lists and tame them with forms, queries and reports created in Excel.
Agenda
-
Data import and clean-up tools
-
Working with Table Style formatting
-
VLookUp, DSum and other Dfunctions
-
Filter, Advanced Filter and Pivot Tables
Logistics
- 90-minute webinar (Travel-Free) delivered over the phone and Internet.
- Unlimited listeners per connection - bring the entire department.
- Q&A session with the expert.