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
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
  • 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

Help

© Copyright 2020 Elev8 asia sdn bhd - All Rights Reserved