Microsoft Excel Courseware
Microsoft Excel is one of the most widely distributed desktop spreadsheet programs. Providing the opportunity to upload data from a number of sources in various file formats or to enter data directly via the keyboard, Excel provides the tools that allow business leaders to quickly analyze and present complex data in easy to read charts and diagrams that make reporting and decision making easier. With the ability to link Excel files to other Microsoft Office products generating professional reports with linked data updates is easy.
Learn how to get the most out of Excel in your environment through the courses included in this category.
This 1/2-day course teaches students how to utilize the more advanced features of Excel 2007, like nested "if" functions, customized data views, advanced charts and graphs, and page formatting techniques. This course is suitable for self-study. Learn More
This 1/2-day course provides students with an introduction to Excel 2007 and instruction on transitioning from older versions of Excel. This course is suitable for self-study. Learn More
This 1/2-day course helps students expand their fundamental knowledge of Excel 2007 to include using formulas and functions, moving and copying data, working with multiple worksheets, and formatting cells for appearance. This course is suitable for self-study. Learn More
This course will teach you how to better analyze and visually display your data with Pivot Tables and Charts. This course covers extensive techniques in using these powerful, but underutilized, Excel tools. Learn More
This course also provides direction as to how to transition from older Excel versions to Excel 2010. Learn More
This half-day course teaches students about the different formulas and functions available in Excel 2010 that are available to make spreadsheets more powerful and functional. Learn More
This one day course covers extensive techniques in using these powerful, but underutilized, Excel tools. PivotTables: creating, sorting and filtering data, Formatting styles, numbers, and layouts, grouping data, comparison and total options, calculated fields and items, combining multiple data sources, conditional formatting PivotCharts. Charts: creating, modifying Design, Layout and Format, creating charts from non-consecutive data, drop-lines, axis formatting, replacing chart series with pictures or shapes, analysis tools, trending tools, using secondary axis, highlighting relationships differences with charts, combining 2 charts into 1. Learn More