Loading Events

« All Events

  • This event has passed.

PowerConcepts: Excel Expert Part 2 – Database Management

February 6, 2020 at 8:30 am - 4:30 pm

$259

Do you need to track the time of various staff on various projects? Need to download reams of data from an online data source? Finally, 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

Register

Details

Date:
February 6, 2020
Time:
8:30 am - 4:30 pm
Cost:
$259

Venue

PowerConcepts Kelowna
Stewart Centre. 280 - 1855 Kirschner Rd
Kelowna, BC V1Y 4N7 Canada
+ Google Map
Phone
250-861-8324

Additional Info

Registration/RSVP Required
Yes (see event description)
Event Type
Workshop/Course
Topic
Personal and Professional Development
Audiences
Faculty, Staff