As an experienced user of Microsoft Excel, you now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will learn how to use Microsoft Office Excel to streamline and enhance your spreadsheets with advanced features such as pivot tables, formulas, templates, and graphics.
As a new user of Microsoft Excel, you have the need to learn the most basic functionality offered by the program. You will become familiar with the user interface, how to use the help feature, modify cells, create basic formulas and use functions to calculate cell values.
This Intermediate level is intended to help everyday users of Excel become more proficient by expanding their knowledge of functions, formulas, and new Excel features.
As a knowledge worker, you have a need to produce compelling PowerPoint presentations. You know your data for charts and graphs is already available in Excel. This one-day course will be an opportunity to see how these two great software products from Microsoft can work in concert to be greater than the sum of their parts!
In this course, you will apply Macros and the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel.
In this course, you will learn how to use Excel and its Power Pivot tools to mine large amounts of sophisticated data to provide better data analysis, business insights and inform decision making.