EXCEL 2007 -- WHAT YOU WILL LEARN:
- EXCEL BASIC
- EXCEL INTERMEDIATE
- EXCEL ADVANCED
- Entering and editing text, values, formulas
- Using Autofill
- Inserting and deleting ranges
- Using relative and absolute references in formulas
- Using the SUM, AVERAGE, MIN MAX, COUNT, and COUNTA functions
- Creating charts based on worksheet data
- Freezing panes, splitting worksheets, and hiding and unhiding data
- Renaming and color-coding worksheet tabs
- and much more ...
- Creating 3-D formulas to link worksheets and workbooks
- Linking workbooks, creating external links, and redirecting links
- Applying built-in and custom number formats
- Using functions to format text
- Creating subtotals and using multiple subtotal functions
- Naming cells and ranges, and using names in formulas
- Defining and applying 3-D names
- Using advanced filtering options
- Saving a workbook as a PDF file
- Using advanced chart formatting options
- and more ...
- Using the IF, SUMIF, and ROUND functions
- Using the VLOOKUP, MATCH, and INDEX functions
- Creating, rearranging, and formatting PivotTables
- Creating Pivot Charts
- Importing and exporting XML data
- Installing and using the Analysis ToolPak
- Running and recording macros
- Editing VBA modules
- Applying conditional formatting to represent data graphically
- Inserting and modifying SmartArt graphics
- and more ...