Excel 2013 Intermediate Training Materials 12Hrs.
Excel 2013 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 when printing
• Printing the Excel 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
Functions and formulas
• Getting help with functions
• Nested functions
• Consolidating data using a 3-D reference sum function
• Mixed references within formulas
Time & date functions
• Inserting the current time and date
• Today function
• Now function
• Day function
• Month function
• Year function
Mathematical functions
• Round function
• Rounddown function
• Roundup function
Logical functions
• If function
• And function
• Or function
Mathematical functions
• Sumif function
Statistical functions
• Count function
• Counta function
• Countif function
• Countblank function
• Rank function
Text functions
• Left function
• Right function
• Mid function
• Trim function
• Concatenate function
Financial functions
• Fv function
• Pv function
• Npv function
• Rate function
• Pmt function
Lookup functions
• Vlookup function
• Hlookup function
Database functions
• Dsum function
• Dmin function
• Dmax function
• Dcount function
• Daverage function
Excel 2013 named ranges
• Naming cell ranges
• Removing a named range
• Named cell ranges and functions
Excel 2013 cell formatting
• Applying styles to a range
• Conditional formatting
• Custom number formats
Manipulating worksheets within Excel 2013
• 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 2013 templates
• Using templates
• Creating Excel templates
• Editing Excel templates
Paste special options within Excel 2013
• Using paste special to add, subtract, multiply & divide
• Using paste special ‘values’
• Using paste special transpose option |
