Microsoft Excel Intermediate
About Microsoft Excel Intermediate
The training covers the intermediate level of Microsoft Excel.
Course Duration
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
- Headers and footers
- Header and footer fields
- Viewing workbooks side by side
- Zooming the view
- Getting help with functions
- Nested functions
- Consolidating data using a 3D reference sum function
- Mixed references within formulas
- Inserting the current time and date
- Today function
- Now function
- Day function
- Month function
- Year function
- Round function
- Rounddown function
- Roundup function
- If function
- And function
- Or function
- Sumif function
- Count function
- Counta function
- Countif function
- Countblank function
- Rank function
- Left function
- Right function
- Mid function
- Trim function
- Concatenate function
- Fv function
- Pv function
- Npv function
- Rate function
- Pmt function
- Vlookup function
- Hlookup function
- Dsum function
- Dmin function
- Dmax function
- Dcount function
- Daverage function
- Naming cell ranges
- Removing a named range
- Named cell ranges and functions
- Applying styles to a range
- Conditional formatting
- Custom number formats
- Copying or moving worksheets between workbooks
- Splitting the window view
- Hiding rows
- Hiding columns
- Hiding worksheets
- Unhiding
- rows
- Unhiding
- columns
- Unhiding
- worksheets
- Using templates
- Creating an Excel personal template
- Editing an Excel personal template
- Deleting an Excel personal template
- 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
- 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
Trainer
SENTHIVALU KRISHNASAMY
Certified Assessor for Skills Training under “Jabatan Pembangunan Kemahiran” (JPK), Ministry of Human Resources, Malaysia
About Us
Elev8 Asia Sdn Bhd is a HRDF Certified Training Provider in Malaysia which founded in year 2015.
Services
- Corporate Training
- Competency Assessment
- e-Learning
- Platform Development
Help
- Privacy Policy
- Contact Us
- News