Microsoft Excel
Short Course
Microsoft Excel 2007 (Spreadsheets)Level 1 Introduction - This one day course will meet the following objectives:-
Identify basic worksheet and workbook concepts and terms - Enter & edit data - Modify the worksheet - Use functions to calculate and return values - Format cells to enhance the appearance of your worksheet - Use drawing features and other enhancements - Change the page set-up to define how the printed worksheet appears.Level 2 Intermediate - This one day course will meet the following objectives:-
Using multiple worksheets, workbooks and workspaces - Working with financial functions - Use advanced formatting techniques - Using the auditing tools to track information - Using charts to display financial data - Using macros to automate your work environment - Use templates.Level 3 Advanced - This one day course will meet the following objectives:-
Creating, maintaining, filtering and using subtotals in a list - Recording, assigning and using macros - Creating and using user-defined functions - Performing "What If" analyses - Working with scenarios - Querying a database - Importing and exporting files and data - Protecting data.
Identify basic worksheet and workbook concepts and terms - Enter & edit data - Modify the worksheet - Use functions to calculate and return values - Format cells to enhance the appearance of your worksheet - Use drawing features and other enhancements - Change the page set-up to define how the printed worksheet appears.Level 2 Intermediate - This one day course will meet the following objectives:-
Using multiple worksheets, workbooks and workspaces - Working with financial functions - Use advanced formatting techniques - Using the auditing tools to track information - Using charts to display financial data - Using macros to automate your work environment - Use templates.Level 3 Advanced - This one day course will meet the following objectives:-
Creating, maintaining, filtering and using subtotals in a list - Recording, assigning and using macros - Creating and using user-defined functions - Performing "What If" analyses - Working with scenarios - Querying a database - Importing and exporting files and data - Protecting data.