Excel Training Program

Topic Highlight

Day 1 Training Introduction to Macro's, Pivot tables, Lesson 1, 2, 3, 4, 5, 6 Lesson 1: Preparing an Excel Workbook Topic 1A: Creating worksheet, saving editing, printing, closing and exiting workbook Topic 1B: Using automatic entering features, such as auto complete, auto correct and auto fill Topic 1C: Inserting formulas, sum buttons to add and average numbers, fill handle to copy Topic 1D: Selecting cells using mouse, keyboard, data within the cells Topic 1F: Formatting with predesigned styles, Cell and Table styles Lesson 2: Inserting Formulas in a Worksheet Topic 2A: Writing formula's with mathematical operations Topic 2B: Inserting formula's with functions (statistical and financial functions) Topic 2C: Writing formula's with date, time functions, and IF logic function Topic 2D: Using absolute and mixed cell reference in a formula Lesson 3: Formatting an Excel Worksheet Topic 3A: Changing column width, row height Topic 3B: Inserting and deleting cells, rows and columns, clearing data in the cells Topic 3C: Applying formatting, font, mini-toolbar, alignment Topic 3D: Previewing a worksheet-zoom setting, applying theme Topic 3F: Formatting using group buttons and format cells dialogue box Topic 3G: Alignment and indent of data, adding borders, fill and shading cells Topic 3H: Formatting with format painter, repeating last action Lesson 4: Enhancing a Excel Worksheet Topic 4A: Formatting a worksheet, margins, centering, orientation, size Topic 4B: Inserting and removing page breaks, printing row and column titles, scaling data Topic 4C: Inserting background picture, various print options, inserting headers, footers Topic 4D: Spell checking, undo and redo, finding and replacing data, sorting and filtering Lesson 5: Moving Data within and between Workbooks Topic 5A: Creating workbook with multiple worksheets Topic 5B: Cutting, copying, pasting selected cell. Paste option button and office clipboard Topic 5C: Managing worksheets, hiding, formatting, splitting windows, Freezing Topic 5D: Working with ranges, windows, multiple workbooks Topic 5E: Linking data between worksheets, 3-D reference Lesson 6: Maintaining Excel Work Books Topic 6A: Maintaining workbooks, creating and renaming a folder Topic 6B: Copying and moving sheets to other workbooks Topic 6C: Saving workbook in different format, version Topic 6D: Formatting with cell styles, working with comments Day 2 Training Introduction to Macro's, Pivot tables contd, Lesson 7, 8, 9, 10, 11, 12 Lesson 7: Creating a Chart in Excel Topic 7A: Creating a chart, sizing, moving, deleting chart Topic 7B: Changing the chart design, custom chart style, data series, layout, style, location Topic 7C: Changing chart layout, chart labels, shapes, images, formatting Lesson 8: Adding Visual Interest to Workbooks Topic 8A: Creating a webpage, saving workbook as webpage Topic 8B: Creating hyperlinks Topic 8C: Inserting symbols, special characters, images, watermarks Topic 8D: Inserting a Smart-Art Diagram, formatting and changing the diagram design Topic 8E: Creating, sizing, and moving WordArt Lesson 9: Advanced Functions and Formulas Topic 9A: Conditional formatting, creating new rule, editing, deleting, formatting Topic 9B: Fraction and scientific formatting, special number format Topic 9C: Creating a custom number format Topic 9D: Wrapping and shrinking text to fit within a cell Topic 9E: Filtering a worksheet using custom autofilter Topic 9F: Filtering and sorting data using conditional formatting or cell attributes Lesson 10: Advanced functions and formulas Topic 10A: Naming Ranges Topic 10B: Statistical functions, COUNTA, COUNTIF, AVERAGEIF Topic 10C: Managing ranges. Lookup functions(VLOOKUP, HLOOKUP) Topic 10D: Financial functions,PPMT, PV, NPV Topic 10E: Logical functions,AND, OR,and NOT,IFERROR Topic 10F: Text functions Lesson 11: Working with Tables and Data Features Topic 11A: Creating, modifying, sorting, filtering tables Topic 11B: Data tools; removing duplicate records, Validating and restricting data entry Topic 11C: Converting a table to a Normal range Topic 11D: Subtotaling related data, grouping and ungrouping data Topic 11E: Using database functions- DSUM, DAVERAGE Topic 11F: Using Math and Trig subtotal functions Lesson 12: Working with Tables and Data Features Topic 12A: Summarizing data in multiple worksheets, range names Topic 12B: Summarizing data by linking ranges to other workbooks Topic 12C: Maintaining external references Topic 12D: Summarizing data using consolidated features Topic 12E: Creating Pivot tables and charts Topic 12F: Advanced chart formatting techniques, chart axis, gridlines, trend-lines Day 3 Training Lesson 13, 14,15, 16, 17, 18 Lesson 13: Summarizing and Consolidating Data Topic 13A: Summarizing data in multiple worksheets, range names Topic 13B: Summarizing data by linking ranges to other workbooks Topic 13C: Maintaining external references Topic 13D: Summarizing data using consolidated features Topic 13E: Creating Pivot tables and charts Topic 13F: Advanced chart formatting techniques, chart axis, gridlines, trend-lines Lesson 14: Using Data Analysis Features Topic 14A: Data-Paste special option, transporting, performing math operation Topic 14B: Using goal seek to populate cells Topic 14C: Creating assumptions of what-if analysis using scenario manager Topic 14D: Scenario- applying, editing, deleting, compiling Topic 14E: Performing what-if analysis using data tables, variable data Topic 14F: Using auditing tools, trace precedent and dependents Topic 14G: Troubleshooting formulas, circling invalid data, watching data Lesson 15: Protecting and Sharing Workbooks Topic 15A: Adding workbook properties using document information panel Topic 15B: Sharing workbook, changing user name, resolving conflicts Topic 15C: Protecting worksheets, un-protecting Topic 15D: Assigning permission to specific users to edit ranges Topic 15E: Protecting the structure of the workbook, un-protecting workbook Topic 15F: Adding and removing passwords to the workbooks Topic 15G: Tracking changes to the workbook. Accepting and rejecting changes Topic 15H: Protecting and sharing workbook Lesson 16: Automating Repetitive Tasks and Customizing Excel Topic 16A: Creating a macro, saving workbooks containing macros Topic 16B: Running macros,assigning macro to shortcut key Topic 16C: Changing macro security settings Topic 16D: Editing,deleting and creating macro Topic 16E: Creating a custom fill series, deleting a custom list Topic 16F: Pinning workbooks to the recent document list Topic 16G: Customizing quick access toolbar Topic 16H: Changing display options to customize the work area Topic 16I: Creating a custom theme,modifying, applying saving themes Topic 16J: Saving workbook as a template, using and deleting custom template Lesson 17: Importing, Exporting, and Distributing Data Topic 17A: Importing data into Excel Topic 17B: Importing from Access, website, text file Topic 17C: Exporting data from Excel Topic 17D: Copying and pasting worksheet data to Access, word Topic 17E: Breaking a link to Excel object, copying to PowerPoint Presentation Topic 17F: Preparing workbook for distribution Topic 17G: Using the compatibility checker Topic 17H: Signing the work book with digital signature, restricting permissions Topic 17I: Creating own digital signature, removing, viewing digital signature