In this course, you will learn how to create a dynamic template to generate business reports for customers and to better understand your own data. You’ll learn steps by steps on how to import external data, design a template using pivot tables, and add slicers, macros, and action buttons to make the template more interactive.
In this Excel data analysis course, you use advanced Excel techniques to build sophisticated spreadsheets. You learn to perform “what if” analyses, leverage features and apply functions, manipulate PivotTables to analyze large amounts of data, and present your results to make better business decisions. You also learn how to automate processes and enhance worksheet models.