This course introduces Microsoft Excel users to the advanced features of the software application. Participants will learn how to sort and manage data in lists; filter and query data; lookup and database functions, and PivotTables.
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.