Excel Intermediate Training 20 Hours OutLine

Excel   Setup & Printing Issues

• Worksheet Margins
• Worksheet Orientation
• Worksheet Page Size
• Headers and Footers
• Header and Footer Fields
• Scaling Your Worksheet to Fit a Page(S)
• Visually Checking Your Calculations
• Displaying Gridlines When Printing
• Printing Titles on Every Page
• Printing Row and Column Headings
• Spell Checking
• Previewing a Worksheet
• Viewing Workbooks Side By Side
• Zooming the View
• Printing Options
• Setting the Number of Copies to Print
• Selecting a Printer
• Selecting Individual Worksheets or the Entire Workbook
• Selecting Which Pages to Print
• Single or Double Sided Printing
• Collation Options
• Page Orientation
• Paper Size
• Margins
• Scaling
• Printing

Excel   Functions and Formulas

• Getting Help with Functions
• Nested Functions
• Consolidating Data Using a 3-D Reference Sum Function
• Mixed References within Formulas

Excel   Time & Date Functions

• Inserting the Current Time and Date
• Today Function
• Now Function
• Day Function
• Month Function
• Year Function

Excel   Mathematical Functions

• Round Function
• Rounddown Function
• Roundup Function

Excel   Logical Functions

• If Function
• And Function
• Or Function

Excel   Mathematical Functions

• Sumif Function

Excel   Statistical Functions

• Count Function
• Counta Function
• Countif Function
• Countblank Function
• Rank Function

Excel   Text Functions

• Left Function
• Right Function
• Mid Function
• Trim Function
• Concatenate Function

Excel   Financial Functions

• Fv Function
• Pv Function
• Npv Function
• Rate Function
• Pmt Function

Excel   Lookup Functions

• Vlookup Function
• Hlookup Function

Excel   Database Functions

• Dsum Function
• Dmin Function
• Dmax Function
• Dcount Function
• Daverage Function

Excel   Named Ranges

• Naming Cell Ranges
• Removing a Named Range
• Named Cell Ranges and Functions

Excel   Cell Formatting

• Applying Styles to a Range
• Conditional Formatting
• Custom Number Formats

Manipulating Worksheets within Excel  

• Copying or Moving Worksheets between Workbooks
• Splitting a Window
• Hiding Rows
• Hiding Columns
• Hiding Worksheets
• Un-Hiding Rows
• Un-Hiding Columns
• Un-Hiding Worksheets

Excel   Templates

• Using Templates
• Creating Excel Templates
• Editing Excel Templates

Paste Special Options within Excel  

• Using Paste Special to Add, Subtract, Multiply & Divide
• Using Paste Special ‘Values’
• Using Paste Special Transpose Option