Make Your Work Efficient with Microsoft Excel
One of the most commonly used tools but also an over-looked one is Microsoft Excel. In our age of digitization, Excel is absolutely indispensable when it comes to organizing, calculating, analyzing, revising, updating and presenting our data. And it does this in half the time that other methods take. However, most people rarely use Excel to its full extent and potential.
Zulhisham Zolkepli of Zedconsultancy.bn is here to instruct you on taking your Excel skills to the next level. With over 10 years of experience, Zulhisham wants to help data owners by sharing his practical experience on data management. With this class, Zulhisham’s intent is simple: “By the end of the session, participants will be equipped with a range of tools, techniques and formulas that can increase the productivity and efficiency of their administration tasks.”
These are the areas that Zulhisham will be covering:
Lesson 1: Recording Data and Tabulation
Participants will learn possible ways to record the type of data that will make it efficient for further use.This includes how to use data format, applying filters and sorting, adding, deleting, and editing records in a table.
Lesson 2: Using formula of SUM, SUMIF and SUMIFS
Participants will learn simple summation calculation and how to total up the values in a range that meet criteria that have been specified.
Lesson 3: Using formula of VLOOKUP
Participants will learn to find some information in a data-spreadsheet, or need to search for the same kind of information throughout the spreadsheet using the excel VLOOKUP function.
Lesson 4: Obtaining duration between two dates
Participants will learn to calculate the number of days, months, or years between two dates using the formula of DATEDIF and other alternatives formula.
Lesson 5: Analysing data for reporting
Participants will learn how to use PIVOT TABLE and apply the knowledge from lesson 1 – 4 to some real examples of practical works in an office. Some examples: Recording office supplies IN and OUT, monitoring and analysing office supplies records, recording and analyzing staff/student information (for Human Resource/Teacher)
Who is this class for?
Administrative roles: Clerks, Admin personnel, HR personnel, Personal Assistant, Educator and anyone interested in enhancing their excel skills and knowledge.
How long is this class?
How many classes are there?
How many students are required to activate this class?
What do I need to bring?
Pen and Paper.
How will this class take place?
Online via Zoom.
- Lectures 1
- Quizzes 0
- Duration 3 hours
- Skill level All levels
- Students 1
- Certificate No
- Assessments Yes