PLEASE CLICK HERE to view upcoming event. Information here is outdated

Microsoft Excel Intermediate Microsoft Office Mastery Series

19 Nov, 2021, Virtual Classroom Training

IPA Training is Registered with

Venue Details

Virtual Classroom Training


Contact us

FOR COURSE DETAILS

Juliany,

Office: 03 2283 6109

Mobile: +60 122281247

juliany@ipa.com.my

Phoebe,

Office: 03 2283 6100

Mobile: +60 193637822

phoebe@ipa.com.my

Bee Teng,

Office: 03 2282 6112

Mobile: +60 172566121

beeteng@ipa.com.my

FOR CUSTOMISED IN-HOUSE TRAINING

Jane,

Office: 03 2283 6101

Mobile: +60 129418251

jane@ipa.com.my

Keith,

Office: 03 2283 0000

Mobile: +60 162272735

keith@ipa.com.my

ADDRESS

A-28-5, 28th Floor, Menara UOA Bangsar,
No.5, Jalan Bangsar Utama 1,
59000 Kuala Lumpur

FOCUSING ON
  • References & Names | COUNT Functions
  • Text Functions | Date Functions
  • Logical Functions | Lookup Functions
  • Database Functions | Paste Special | Print Setup
COURSE OVERVIEW

Microsoft Excel is a software for storing numerical data and analyzing them. It is one of the most flexible and commonly used applications in Office. Whatever career path you choose, you will probably have to use Excel to achieve your professional goals, some of which may happen every day. For one way or the other, we all work with numbers. When we want to record, analysis and save such numeric data, Microsoft Excel comes in handy. At this intermediary level, it provides an overview of the Excel forms and features used every day for preparing reports and analytics for our managers.

COURSE LEARNING OUTCOMES (CLO)
  1. Classify Excel Data thoroughly and preventing common mistakes in Excel Reports
  2. Display accurate and consistent Reports using the right Formula or Functions.
  3. Perform the Logic in the Formula by using Logical Functions to automate outcome.
  4. Convert information and Summarizing Data accurately quick and easy.
  5. Select the proper Print Setup to present the final print professionally.
WHO SHOULD ATTEND
Personnel who use Microsoft Excel to analyse and prepare management reports, especially Administrative, Operational and Middle Management Staff.
METHODOLOGY
  • Guided Learning, group-paced, hands-on classroom with real life examples for business applications.
  • Challenging exercises are set based on practical applications for typical organizational functions such as HR, Admin, Production, Sales etc.
COURSE OUTLINE
9:00

Excel References

  • Consolidating Data Using a 3-D Reference Sum Function
  • Mixed References within Formulas
 

Excel Named Ranges

  • Naming Cell Ranges
  • Removing a Named Range
  • Named Cell Ranges and Functions
 

Excel Statistical Functions

  • COUNT Function
  • COUNTA Function
  • COUNTIF Function
  • COUNTBLANK Function
10.45

Excel Text Functions

  • Left function
  • RIGHT Function
  • MID Function
  • TRIM Function
 

Excel Time & Date Functions

  • Inserting the Current Time and Date
  • TODAY Function
  • WORKDAY Function
  • Functions
  • EDATE & EOMONTH Functions
1.00 Lunch
2:00

Excel Logical Functions

  • IF Function
  • AND Function
 

Excel Lookup Functions

  • VLOOKUP Function
  • HLOOKUP Function
3.45

Excel Database Functions

  • DSUM Function
  • DAVERAGE Function
  • DMAX Function
  • DMIN Function
  • DCOUNT Function
 

Paste Special Options within Excel

  • Using Paste Special to Add, Subtract, Multiply & Divide
  • Using Paste Special ‘Values’
  • Using Paste Special Transpose Option
 

Excel Setup & Printing Issues

  • Worksheet Margins
  • Worksheet Orientation
  • Worksheet Page Size
  • Headers and Footers
  • Scaling Your Worksheet to Fit a Page(S)
  • Printing Titles on Every Page
  • Previewing a Worksheet
5.00 End of Course