Microsoft Excel Training

This is a spreadsheet program that allows for construction of data in tables. It concentrates on use of formulas, production of graphs, database management and statistical analysis.

• INTRODUCTORY
• INTERMEDIATE
• ADVANCED
• MACROS (Visual Basic)

Microsoft Excel - Introductory Level

Duration: 7 Hours

• Save dialog box
• Smart tags
• Adjusting Column Widths/Row Heights
• Print dialog box/Print Preview
• Emailing files
• Formulas
• Viewing techniques
• Comments
• Selecting ranges of cells
• Moving and copying data
• Creating a Series
• Multiple Windows
• Formatting a Spreadsheet
• Inserting and deleting columns/rows
• Inserting Page breaks
• Basic charts

Check Schedule   |   Book Now   |   Return to top

Microsoft Excel - Intermediate Level

Duration: 7 Hours

• Revision of Introductory Features
• Advanced Charts
• Absolute Cell References
• Functions in formulas
• Editing Tools
• Custom Fill Series
• Templates
• Multiple Worksheets
• Named Ranges
• Sorting
• Databases
• Subtotals
• Conditional formatting
• Error Messages Appendix

Check Schedule   |   Book Now   |   Return to top

Microsoft Excel - Advanced Level

Duration: 10.5 Hours

• Revision of Intermediate Features
• Advanced Functions in formulas e.g. IF and Vlookup
• Saving a Workbook as a Web Page
• Routing, Tracking Changes and Sharing Workbooks
• Hyperlinks
• Protecting Workbooks
• Importing and Converting Text to Columns
• Consolidating Data
• Pivot Tables
• Linking Workbooks
• Data Validation
• Recording Basic Macros

Check Schedule   |   Book Now   |   Return to top

Microsoft Excel - Macros (Visual Basic)

Duration: 17.5 Hours

• Recording Macros
• Recorder Workshop
• User Defined Functions
• Using the VBA Editor
• Understanding VBA
• Procedures
• Variables
• Using Excel Objects
• Programming Techniques
• Custom Forms
• Custom Menus
• Automatic Startup

Check Schedule   |   Book Now   |   Return to top