Excel Level 3 (Advanced)
This Level 3 or Advanced course teaches how to use PivotTables to quickly summarize and analyze large volumes of business data, including lookup functions, data tools, advanced functions, protection commands, and shortcuts.
Date:
Tuesday, June 24, 2025
Time:
08:00 AM PDT | 11:00 AM EDT
Duration:
60 Minutes
More Trainings by this Expert
Product Id : 507139
Price Details
Live: One Dial-in One Attendee
Corporate Live: Any number of participants
Recorded: Access recorded version, only for one participant unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
Corporate Recorded: Access recorded version, Any number of participants unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
Overview:
In this Level 3 or Advanced course, learn how PivotTables quickly summarize and analyze large volumes of business data.
Use lookup functions to automatically look up data. Use many advanced tools and functions. Plenty of shortcuts and time-saving tips included.
Areas Covered in the Session:
- Use Names in Formulas
- Lookup Functions (Xlookup; 2 way lookups)
- PivotTables
- Data Tools (Drop Downs, Text to Columns, Remove Duplicates)
- Advanced Functions
- Protection Commands
- Shortcuts and Time-Saving tips
Who Will Benefit:
- Managers
- Business Professionals
- Administrative Personnel
- Legal Professionals
Speaker Profile
Craig Brody runs Craig Brody, LLC, a software training and consulting business. Craig has trained thousands of employees, managers, executives and students in application software including Microsoft 365 and Adobe Acrobat Pro. Conducts and facilitates in person and online training workshops for professionals in the fields of Accounting, Business, and Law. Conducts workshops, classes and consulting services for the University of Pennsylvania’s Wharton Business School and Penn Carey Law School. Provides clients with spreadsheet analysis and design, software programming, consulting services and course curriculum including videos, reference guides and related materials