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
Module 1: Getting a summary to meet specific criteria
- 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
Module 2: Getting a summary to meet specific criteria
- 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
Module 3: Rules to control user input in a cell
- Dropdown list to limit entries
- Restrict value entry for number and date
- Custom user defined restriction
Module 4: Quick search, compile and compare data from multiple sheets / workbooks
- 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
Module 5: Identify data trends and patterns
- Highlight Cell Rules
- Using Data Bars
- Using Icon Sets
- Creating New Rules with Formula
