Learn top tips for querying and displaying information in Microsoft Excel.
Get more from Excel and learn to use Forms, Lookup Functions, Charts, PivotTables, and Slicers to turn data into answers
Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards.
The ability to easily query and display information from your Excel data is a helpful tool for reporting and decision-making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, Pivot Tables, and Slicers) that will do just that.
If you are comfortable with the basics of Excel, let our Microsoft Certified Trainer Barbara Evers walk you through even more useful Excel topics and tools.
Topics covered include: • Using range names in formulas • Creating nested functions • Working with forms, form controls, and data validation • Using lookup functions • Combining multiple functions • Creating, modifying, and formatting charts • Using sparklines, trendlines, and dual-axis charts • Creating a Pivot Table and analyzing Pivot Table data • Presenting data with Pivot Charts • Filtering data with slicers
Over 2 hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!
Powering Productivity, One Brain at a Time!
Combining TV-style video production with modern graphics and animation, Bigger Brains courses are popular with both learners and training professionals around the world. Our top teachers and subject matter experts have real-world experience and create the most realistic and comprehensive training courses possible. Bigger Brains courses are built in a unique “Teacher/Learner” style, featuring two people on camera to recreate some of the interactivity and physiological benefits of classroom training, including dialogue, humor, and practical use case examples. This Uniquely Engaging™ video-based format is more enjoyable and more effective than traditional eLearning formats.
Professional Training, Instructional Design, Published Author, Editor/Proofreader, Motivational Speaker
It doesn’t take long for people who meet Barbara Evers to recognize her talents in written and verbal communication. Tapping into this strength, Barbara has found success in many facets of her life. Her mission is to help others do the same professionally and personally. Barbara received a Bachelor of Arts degree in Zoology and a Master of Arts in Professional Communication from Clemson University. She is an active member of South Carolina Writers Association, and her certifications include: Myers Briggs Type Indicator (MBTI) Coaching Using Multiple Models Global Corporate College (GCC) Development Dimensions International (DDI) Zig Ziglar Achieve Global Barbara has over twenty-five years’ experience in training and public speaking with an emphasis in Career and Leadership Development. With a broad list of clients in the corporate, non-profit, and government arenas, she excels in teaching participants the skills and techniques needed to meet their professional goals. Her educational and career pursuits provide a diverse background of knowledge for her to use in instructional design and in training or coaching sessions. She draws from this experience to customize her materials and provide a valuable, interactive experience for each participant. Her areas of expertise include Communication, Public Speaking, Business Writing, Customer Service, MBTI, and Leadership as well as software training. Barbara lives in Greer, SC and is the author of The Watchers of Moniah trilogy as well as several short stories and essays. She’s honored to have received multiple writing awards, including a Pushcart Prize nomination.
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.
