Mastering Excel 2019 - Intermediate

Become proficient in using the world’s most popular software tool for organizing and analyzing data.When you master Excel, you have one of the most practical and valuable skillsets in modern business. You can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course builds on your existing Excel knowledge and teaches you how to efficiently manage data using charts and tables, and how to use powerful reporting tools such as Pivot Tables, Pivot Charts, Slicers, Timelines, and more.This is our most requested training course!As you learn to use Excel effectively, you will start to see how powerful it is in managing small or large datasets. If you are comfortable with the basics of Excel, let our Microsoft Certified Trainer Kathy Jones walk you through more advanced topics that will take your spreadsheets to the next level and help you to be more efficient in analyzing your data.Topics covered include:Working with named rangesInserting functionsUsing advanced sorting and filtering techniquesInserting TablesApplying advanced Conditional FormattingInserting charts and graphicsApplying advanced charting toolsWorking with Pivot Tables, Pivot Charts, Slicers, and TimelinesOver five hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!