MICROSOFT EXCEL SETUP AND VIEWING OPTIONS
- Worksheet margins
- Worksheet orientation
- Worksheet page size
- Headers and footers
- Header and footer fields
- Viewing workbooks side by side
- Zooming the view
MICROSOFT EXCEL FUNCTIONS AND FORMULAS
- Getting help with functions
- Nested functions
- Consolidating data using a 3D reference sum function
- Mixed references within formulas
MICROSOFT EXCEL TIME & DATE FUNCTIONS
- Inserting the current time and date
- Today function
- Now function
- Day function
- Month function
- Year function
MICROSOFT EXCEL MATHEMATICAL FUNCTIONS
- Round function
- Rounddown function
- Roundup function
MICROSOFT EXCEL LOGICAL FUNCTIONS
- If function
- And function
- Or function
MICROSOFT EXCEL MATHEMATICAL FUNCTIONS
MICROSOFT EXCEL STATISTICAL FUNCTIONS
- Count function
- Counta function
- Countif function
- Countblank function
- Rank function
MICROSOFT EXCEL TEXT FUNCTIONS
- Left function
- Right function
- Mid function
- Trim function
- Concatenate function
MICROSOFT EXCEL FINANCIAL FUNCTIONS
- Fv function
- Pv function
- Npv function
- Rate function
- Pmt function
MICROSOFT EXCEL LOOKUP FUNCTIONS
- Vlookup function
- Hlookup function
MICROSOFT EXCEL DATABASE FUNCTIONS
- Dsum function
- Dmin function
- Dmax function
- Dcount function
- Daverage function
MICROSOFT EXCEL NAMED RANGES
- Naming cell ranges
- Removing a named range
- Named cell ranges and functions
MICROSOFT EXCEL CELL AND RANGE FORMATTING
- Applying styles to a range
- Conditional formatting
- Custom number formats
ADVANCED WORKSHEET MANIPULATION WITHIN MICROSOFT EXCEL
- Copying or moving worksheets between workbooks
- Splitting the window view
- Hiding rows
- Hiding columns
- Hiding worksheets
- Unhiding
- rows
- Unhiding
- columns
- Unhiding
- worksheets
MICROSOFT EXCEL TEMPLATES
- Using templates
- Creating an Excel personal template
- Editing an Excel personal template
- Deleting an Excel personal template
PASTE SPECIAL OPTIONS WITHIN MICROSOFT EXCEL
- Using paste special to add ranges
- Using paste special to subtract ranges
- Using paste special to multiply ranges
- Using paste special to divide ranges
- Using paste special ‘values’
- Using paste special transpose option
PROOFING AND PRINTING
- Spell checking
- Previewing a worksheet
- Visually checking your calculations
- Scaling your worksheet to fit a page(s)
- Displaying gridlines when printing
- Printing titles on every page when printing
- Printing the Excel row and column headings
- To 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