 # Microsoft Excel Intermediate

The training covers the intermediate level of Microsoft Excel.

2 days

## Who Should Attend This Course?

People with Foundation level understanding of Microsoft Excel

## What Will You Learn?

At the completion of the training, candidates will be able to:
• Setup and view options
• Use functions and formulas
• Use time & date functions
• Use mathematical functions
• Use logical functions
• Use mathematical functions
• Use statistical functions
• Use text functions
• Use financial functions
• Use lookup functions
• Use database functions
• Work with named ranges
• Work with cell and range formatting
• Perform advanced worksheet manipulation within Microsoft Excel
• Use Microsoft Excel templates
• Use Paste special options within Microsoft Excel
• Perform Proofing and printing

## Programme Outline

MICROSOFT EXCEL SETUP AND VIEWING OPTIONS
• Worksheet margins
• Worksheet orientation
• Worksheet page size
• 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
• Sumif function
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
• 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

## Trainer

### SENTHIVALU KRISHNASAMY

Certified Assessor for Skills Training under “Jabatan Pembangunan Kemahiran” (JPK), Ministry of Human Resources, Malaysia