Foundation Excel
These are activity-based workshops designed to cut through the chase and sieves the excess.
It covers the essential Excel command and techniques to jump start productivity for Excel users.
See our Training Assurance Plans for up to 30% savings!
 |
 |
 |
 |
| Up to Speed with Excel 2007-Basic & Intermediate Expect to pick up practical tips and tricks to use Excel at a new level that will make you better organized and more successful in creating and using Excel spreadsheets. Duration: 2 days. |
Up to Speed with Excel 2007-Advanced We’ll deal with advanced topics of Excel 2007 such as basic business reporting, data analysis & programming with VBA. Duration: 2 days. |
Automation with Excel 2007 VBA Programming With Visual Basic for Applications (VBA) programming, you can create automated & mission-critical programs in Excel to boast productivity. Duration: 3 days. |
Data Management with Excel 2003/2007 Useful for Excel users who store large amounts of data records in Excel. Make good use of external data, run queries using specific functions, or extract useful data through Access Query. Duration: 1 day. |
 |
|
 |
 |
Up to Speed with Excel 2007-Basic & Intermediate
|
Brief Outline Introduction to Excel 2007 features & improvements. Working with Workbooks and Worksheets. Advanced Cell Formatting. Must know Excel Functions. Advanced Formulas & Techniques. Introduction to Array Formulas. Tools & Methods for Debugging Formulas. Get to know your way around Excel and before long you’ll start creating workbooks and worksheets like an expert. |
|
| Up to Speed with Excel 2007-Basic & Intermediate Expect to pick up practical tips and tricks to use Excel at a new level that will make you better organized and more successful in creating and using Excel spreadsheets. Duration: 2 days. |
Things to note: Designed for participants with no prior experience with Excel. |
|
 |
Up to Speed with Excel 2007-Advanced
|
Brief Outline Introduction to Databases. What-If Analysis in Excel 2007. Pivot Tables & Pivot Charts. Charts & Graphics in Excel 2007. Introduction to Excel Macros. Introduction to VBA Programming. 80% of Excel users use it as an application to store data. We’ll teach you to use Excel as a management decision tool instead of just storing plain data. |
|
| Up to Speed with Excel 2007-Advanced We’ll deal with advanced topics of Excel 2007 such as basic business reporting, data analysis & programming with VBA. Duration: 2 days. |
Things to note: Designed for participants with basic knowledge of Excel 2007. |
|
|
Automation with Excel 2007 VBA Programming
|
Brief Outline An introduction to the VBA language. Programming with Workbooks & Worksheets. Programming with Graphical objects. Programming with Range objects. More VBA language constructs. Programming with Custom Forms. Create a complete Enterprise Information System. If you’re an intermediate or advanced Excel user, this workshop helps you take your skills (and your spreadsheets) to the next level. |
|
| Automation with Excel 2007 VBA Programming With Visual Basic for Applications (VBA) programming, you can create automated & mission-critical programs in Excel to boast productivity. Duration: 3 days. |
Things to note: Participants should have working knowledge of basic Excel functions, formulas and number formatting. |
|
 |
Data Management with Excel 2007
|
Brief Outline Importing Data: An Overview. Excel’s Data Management Features * Using the Worksheet Functions: An Overview * Locating Data with OFFSET * Finding Data with INDEX * Finding Data with MATCH * Using MATCH with Other Functions * Using VLOOKUP * Rearranging Data with TRANSPOSE * Getting Data from a Pivot Table: GETPIVOTDATA Using Microsoft Query. Importing Data: Further Considerations. Learn how to extract data from different sources and import into Excel for your business intelligence & reporting needs. |
|
| Data Management with Excel 2007 Useful for Excel users who store large amounts of data records in Excel. Make good use of external data, run queries using specific functions, or extract useful data through Access Query. Duration: 1 day. |
Things to note: Participants should have working knowledge of basic Excel functions, formulas and number formatting. |
|
 |
Data Management with Excel 2003
 |
Brief Outline Importing Data: An Overview. Excel’s Data Management Features * Using the Worksheet Functions: An Overview * Locating Data with OFFSET * Finding Data with INDEX * Finding Data with MATCH * Using MATCH with Other Functions * Using VLOOKUP * Rearranging Data with TRANSPOSE * Getting Data from a Pivot Table: GETPIVOTDATA Using Microsoft Query. Importing Data: Further Considerations. Learn how to extract data from different sources and import into Excel for your business intelligence & reporting needs. |
|
| Data Management with Excel 2003 Useful for Excel users who store large amounts of data records in Excel. Make good use of external data, run queries using specific functions, or extract useful data through Access Query. Duration: 1 day. |
Things to note: Participants should have working knowledge of basic Excel functions, formulas and number formatting. |
|
|
