Excel 2007: Power Charting

This course is designed for the user experienced with creating and formatting basic charts in Excel but needing or desiring to expand their charting skills. Upon completion of the course students will be able to: understand chart types and what to use when, create custom chart types, create combination charts, chart from multiple worksheets and workbooks, work with trend lines and error bars, utilize advanced chart techniques and tricks, use Excel charts in other applications and avoid common chart-making mistakes. ...

Continue Reading →

Excel 2007: PivotTables and PivotCharts

PivotTables are powerful! PivotTables allow users to combine, compare and summarize thousands of rows of data into just a few rows. What’s more, pivot tables are interactive. Rows and columns are easily rotated, allowing users to analyze your data from different perspectives. Users can then drill down into specific data points for areas of interest. After this course students will be able to: build and manipulate a basic PivotTable, filter and group PivotTable data, format a PivotTable, change and create ...

Continue Reading →

Excel 2007 Skill Builder Topics

The current economical climate presents paradoxical challenges. With a reduced work force employees must be more productive to meet increased individual work demands. But funds and time for the training to learn skills that would increase productivity are limited. Skill Builder Sessions allow employees to get the exact training required to be more productive with a minimum commitment of time and financial resources. They are also excellent review sessions. Course Length – 1 ½ hours Price – $30/topic. Each additional ...

Continue Reading →

Excel 2007: VBA

In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of the spreadsheet development. In this course, you will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks ...

Continue Reading →