Scheduled CoursesMicrosoft Office ›Excel Expert Part 2 Database Management

Excel Expert Part 2 Database Management

Need to do time tracking of various staff on various projects? Need to download reams of data from an online data source? Now you need to make sense of it all!

Learn how Excel will capture potential data errors, minimize input errors and then automate the updating of datasets into Excel tables and then into Pivot Tables and Pivot Charts. Also, learn strategies for collecting and validating data with tables. Understand how to automate the collection and cleaning up of data using Power Query and then how to analyze with Pivot Tables. And also learn how to create dashboards for visually displaying data and using slicers to quickly filter and change graphical reports. Learn to use the new Excel’s Business Intelligence (BI) Tools that can make updating and analyzing data a breeze.

Course duration:7 hours.

Detailed PDF description

Select Your Time Zone

Dates Location Price
Monday, August 12, 2024
08:30 AM -12:00 PM
Tuesday, August 13, 2024
08:30 AM -12:00 PM
Remote $299
Wednesday, September 18, 2024
08:30 AM -12:00 PM
Thursday, September 19, 2024
08:30 AM -12:00 PM
Remote $299
Price: $0
+ GST:
Total Price: