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.
This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.
If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.
