Working Smart with Microsoft Excel

Working Smart with Microsoft Excel

Summary

Location

Location

Malaysia

Duration

Duration

1 Day
Format

Format

Public Class

Public Class

Unleash Your Potential with Our Microsoft Excel Course

If you’re looking to master Microsoft Excel, our ‘Working Smart With Microsoft Excel’ course is your gateway to unlocking its full potential. In this hands-on, instructor-led Microsoft Excel course, we cater to a diverse audience, including administration staff, financial executives, operational teams, and more. Whether you’re a beginner or have some prior knowledge of Microsoft Excel, our course equips you with essential skills to excel in the corporate world.

What to Expect

If you’re looking to master Microsoft Excel, our ‘Working Smart With Microsoft Excel’ course is your gateway to unlocking its full potential. In this hands-on, instructor-led Microsoft Excel course, we cater to a diverse audience, including administration staff, financial executives, operational teams, and more. Whether you’re a beginner or have some prior knowledge of Microsoft Excel, our course equips you with essential skills to excel in the corporate world.

Dive into Microsoft Excel's Power

Our course goes beyond the ordinary by delving into advanced Microsoft Excel functions like SUMIF, VLOOKUP, and data trend analysis. You’ll learn to control user input, compile and compare data from multiple sources, and identify data trends and patterns. With ‘Working Smart With Microsoft Excel,’ you’ll become a pro at Microsoft Excel, making your work more efficient and accurate. Microsoft Excel isn’t just a spreadsheet tool; it’s your key to working smarter, not harder. Enroll today and take your skills to the next level with our Microsoft Excel course.

Don’t miss this opportunity to excel in Microsoft Excel!

Course Details

Course Code: Instructor-led

Audience

  • Administration Staff
  • Financial Executive
  • Operational Staff
  • Resource and planning team
  • Supervisors
  • Engineers

Prerequisites

Basic knowledge of Windows is essential with the following pre-requisites:

  • Able to switch between task applications
  • Able to create a spreadsheet with simple formatting
  • Able to use Auto Filter command
  • Able to use basic functions – AutoSum, Count, Max, Min and Average functions

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.

Course Objectives

Upon completion of this program, participants should be able to:

  • The Basics
  • Setting Up A Project
  • Scheduling Work
  • Managing Resources
  • Managing Tasks
  • Creating A Timeline
  • Working With Task Calendar, Lag And Lead Time
  • Creating Baselines
  • Resolving Resource Conflicts
  • Tracking Progress
  • Creating Progress Lines
  • Managing Project Costs
  • Comparing Projects
  • Printing And Sharing Your Project
  • Creating Reports
  • Project and other Software

Outlines

  • Adding up value with SUMIF / SUMIFS
  • Finding number of entry with COUNTIF / COUNTIFS
  • Average up value with AVERAGEIF / AVERAGEIFS
  • return an alternative result with IFERROR
  • Adding up value with SUMIF / SUMIFS
  • Finding number of entry with COUNTIF / COUNTIFS
  • Average up value with AVERAGEIF / AVERAGEIFS
  • return an alternative result with IFERROR
  • Dropdown list to limit entries
  • Restrict value entry for number and date
  • Custom user defined restriction
  • Vertical search for exact matching data using VLOOKUP
  • Horizontal search for matching data using HLOOKUP
  • VLOOKUP as alternative for Nested IF function
  • Multiple searches with INDEX and MATCH
  • Highlight Cell Rules
  • Using Data Bars
  • Using Icon Sets
  • Creating New Rules with Formula

Trainers

Reviews

Interested In

Working Smart with Microsoft Excel

Starting From
RM300
Intake Date
6 DEC 2024
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Book Now

Course Name: Working Smart with Microsoft Excel
Duration: 1 Day
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Download Details

Name *
Email *
Contact No. *