Spring+Seminar+Series


 * ===== ** Microsoft Excel - Intro ** =====

=
** Instructor: Paul Tilley **  Topics covered in the seminar include: WORKING WITH LARGE WORKSHEETS  1** . Working with large spreadsheets ** a. Viewing options b. Hiding and displaying data c. Printing large worksheets
 * COURSE TOPICS: 1. Getting started with Excel  **  a. Exploring the Excel workspace  b. Entering text and numbers  c. Saving a workbook  d. Getting help  e. Entering a formula  f. Preparing a worksheet for printing  g. Printing a worksheet  h. Closing a file and exiting  ** 2. Modifying a Worksheet  **  a. Selecting worksheet items  b. Using auto-fill  c. Inserting and deleting rows and columns  d. Copying and moving cell contents  e. Using autosum  f. Copying a formula with relative references  ** 3. Improving the appearance of a worksheet  **  a. Exploring formatting options  b. Formatting numbers  c. Aligning cell contents  d. Changing fonts and font sizes  e. Apply attributes  f. Adding colour  g. Adding borders  h. Removing formatting  ** 4. Entering formulas in well-designed worksheets  **  a. Analyzing a poorly designed worksheet  b. Adding user instructions and other documentation  c. Working with operators and order of precedence  d. Typing and pointing formulas  e. Comparing absolute and relative cell references  f. Creating and copying formulas with relative or absolute cell references  g. Freezing and splitting the worksheet  h. Displaying formulas instead of formula results  ** 5. Working with functions  **  a. Getting help with functions  b. Analyzing data with AVERAGE, MAX, and MIN  c. Calculating a loan payment with PMT  d. Crating a loan payment table  e. Using IF to display messages  f. Using IF to calculate  g. Using NOW to display the current date  h. Hiding and un-hiding rows and columns  ** 6. Sorting, filtering and editing lists  **  a. Using an Excel list as a database  b. Sorting records on the contents of one field  c. Sorting records on the contents of two or more fields  d. Using auto filter with one search condition  e. Using custom auto filter with OR search criteria  f. Using Customer auto filter and AND search criteria  g. Adding and deleting records by using a form  h. Editing records by using a form  ** 7. Working with charts  **  a. Identifying common chart types and features  b. Using chart wizard to create an embedded pie chart  c. Using chart wizard to create an embedded column chart  d. Changing the chart type  e. Charting nonadjacent data series  f. Formatting charts  g. Modifying chart formats  h. Creating a combination chart  ** 8. Developing a multiple sheet workbook  **  a. Copying data from another application  b. Renaming worksheets  c. Editing multiple worksheet simultaneously  d. Subtotaling data  e. Linking worksheets  f. Applying conditional formatting  g. Using a worksheet to solve a problem  h. Saving a worksheet with a chart as a web page   **9. Working with large spreadsheets** a. Viewing options  b. Hiding and displaying data  c. Printing large worksheets  ** 10. Muliple worksheets ** a. Linking worksheets using 3-D formulas  b. Consolidating data  c. Linking workbooks  ** 11. Customizing Excel **a. Changing options b. b. Customizing toolbars and menus  ** 12. Advanced Charting ** a. Charting formatting options  b. Creating combination charts  c. Adding graphic elements  ** 13. Advanced Formatting ** a. Borders and shading  b. Special number formats  c. Dates and times  d. Styles  ** 14. List Management ** a. Creating lists  b. Sorting and filtering lists  c. Advanced filtering  ** 15. Documenting ** a. Commands and textboxes  b. Auditing features  c. Protection  ** 16. Templates ** a. Using built-in templates  b. Creating and managing templates ** 17. Working with other MS Office programs  **a. Placing Worksheets into Word/PowerPointb. Merging using Excel & Word ===== ||  ** Microsoft Excel -  Advanced **
 * MULTIPLE WORKSHEETS AND WORKBOOKS
 * CUSTOMIZING EXCEL
 * ADVANCED CHARTING
 * ADVANCED FORMATTING
 * LIST MANAGEMENT
 * DOCUMENTING AND AUDITING
 * USING TEMPLATES
 * Working with other MS Office programs

2** . Muliple worksheets ** a. Linking worksheets using 3-D formulas b. Consolidating data c. Linking workbooks 3. Customizing Excel ** a. Changing options <span style="font-family: 'Verdana','sans-serif'; font-size: 14pt;">b. b. Customizing toolbars and menus

4** . Advanced Charting ** a. Charting formatting options b. Creating combination charts c. Adding graphic elements 5. Advanced Formatting ** a. Borders and shading b. Special number formats c. Dates and times d. Styles 6. List Management ** a. Creating lists b. Sorting and filtering lists c. Advanced filtering

7** . Documenting ** a. Commands and textboxes b. Auditing features c. Protection

8** . Templates ** a. Using built-in templates b. Creating and managing templates <span style="font-family: 'Verdana','sans-serif'; font-size: 14pt;"> ** <span style="font-family: 'Verdana','sans-serif'; font-size: 14pt;">9. Working with other MS Office programs ** <span style="font-family: 'Verdana','sans-serif'; font-size: 14pt;">a. Placing Worksheets into Word/PowerPoint <span style="font-family: 'Verdana','sans-serif'; font-size: 14pt;">b. Merging using Excel & Word ||