Intermediate Microsoft Excel 2019

This Intermediate Microsoft Excel 2019 course is perfect for companies aiming to enhance their employees’ proficiency in advanced Excel formulas and data visualization techniques, as well as individuals looking to upskill themselves. By the end of this course, participants will know how to utilize Excel’s powerful functionalities to streamline their data management processes and make informed business decisions.

We start with Advanced Formulas, where you’ll master using named ranges in formulas, enabling a more organized and efficient workflow. You’ll also learn about formulas that span multiple worksheets, enhancing your ability to compile and analyze data from different sources. Functions such as IF, AND/OR, SUMIF, AVERAGEIF, and COUNTIF will be covered to build more dynamic and responsive spreadsheets. Additionally, you’ll get hands-on practice with advanced functions like PMT, LOOKUP, VLOOKUP, and HLOOKUP, and string manipulation functions, ensuring you can handle a variety of data formats and requirements.

In the Working with Lists lesson, you’ll learn to convert lists to tables, remove duplicates, sort, filter, and add subtotals effectively. These skills are essential for managing and analyzing large datasets, ensuring accuracy and efficiency in your data processes.

Next is Working with Illustrations, where you’ll explore the use of Clip Art, shapes, icons, and SmartArt to make your reports and presentations visually appealing. You’ll also be introduced to Office Ink for easily adding personal notes and annotations directly within your documents.

With Visualizing Your Data, you’ll learn to insert, edit, and customize charts using the Chart Recommendation feature and Chart Tools. This lesson includes exercises on using the Quick Analysis tool to enhance the visual representation of your data, making it easier to communicate insights and trends effectively.

The Working with Tables lesson focuses on formatting data as tables, moving between tables and ranges, and modifying tables by adding or removing cells. You’ll also master table styles and band rows and columns to create neatly structured and easy-to-read datasets. The exercises provided will reinforce these concepts, ensuring you become proficient in working with tables in Excel.

The course also includes a lesson on Advanced Formatting, where you’ll apply conditional formatting, utilize styles, and create and modify templates. These advanced formatting techniques will help you present your data in a clear and professional manner, enhancing readability and interpretation.

By completing this course, you or your team will have gained a solid understanding of advanced Excel functionalities, enabling more efficient data management, better business insights, and improved overall productivity. These skills are beneficial in various business contexts, ensuring you can handle complex data tasks with ease and confidence.