Parksville, May 26th
Excel is by far one of the most prolific and most versatile programs installed on desktops today. It’s everywhere, and touches most business positions in some way. Yet the reality is that by far the vast majority of Excel users are self-taught. We struggle through the program, learning what we need in order to accomplish our tasks and then… stop learning? The truth is that once we’ve worked out a method to finish our work, we usually call it a day.
Did you know that there are almost always three ways to do everything in Excel? Are you using the most efficient method possible to get things done? This “intro-mediate” Excel course is designed to quickly review the basics, giving you a solid review of techniques that you should know to be efficient, but may have missed in your own education. Once the basics are covered, we’ll also jump into more advanced tools and techniques that you’ll be able to take back to your daily work.
*This is a hands-on seminar. Please bring a laptop with Excel 2007 or higher installed.
WHO SHOULD ATTEND
Users who are self-taught in Excel and who feel that they may have gaps in their Excel knowledge, especially around the topic outline areas.
BENEFITS OF ATTENDING
At the end of this course the participant will have the ability to create and audit basic functions, as well as a deep understanding of the most intimidating Excel function: VLOOKUP. In addition, they will understand how to structure data properly with Excel tables, and the avenues it opens to data analysis with PivotTables and other techniques.
• formula & function review: essential math, logic, and text functions, including useful functions you may not have heard of
• mastering VLOOKUP: a deep dive into understanding how VLOOKUP REALLY works, common causes of the dreaded #N/A error, and how to guard against them
• Excel tables – the new way to store data
• instant insights from conditional formatting
• PivotTables: beautifully simple, blazingly fast, and unbelievably useful – from creation to useful formatting tricks
|Date:||Friday, May 26th, 2017|
|Where:||The Beach Club Resort, 181 Beachside Dr. Parksville, BC|
|Time:||Registration: 8:00 am | Seminar: 8:30 am – 5:00 pm|
|Cost:||$225.00 + GST (coffee breaks and lunch)|
|CPD | Level:||7 hours | intermediate|
|To register:||Click here|
KEN PULS, FCPA, FCMA, is the president of Excelguru Consulting Inc, a company dedicated to leveraging over 20 years of corporate accounting and IT experience to help users get the most out of Microsoft Excel and Power BI. Ken has been an active participant in many Web forums since 2002, and hosts his own website, blog and free help forums. In recognition of his online community contributions, Microsoft has awarded Ken the prestigious Microsoft MVP award every year since 2006.