RM635

Virtual Workshop: Excelling In Excel (Advance)

Event Information

Share this event

Date and Time

Location

Location

Online Event

Event description
Get the answers you need from the vast amounts of data your organization generates through Excelling In Excel (Advance).

About this Event

Virtual Workshop: Excelling In Excel (Advance)

The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

DETAILS

Duration:

8th July 2020 (Wednesday): 9.00am - 1:00pm

9th July 2020 (Thursday): 9:30am - 12:30pm

Online Platform: ZOOM

OBJECTIVES

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

You will:

  • Work with multiple worksheets and workbooks.
  • Use Lookup functions and formula auditing
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Create sparklines and map data.

TARGET STUDENTS

This course is intended for students who are experienced Excel 2016 users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

PREREQUISITES:

To ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel 2016. To meet these prerequisites, students can take the following Logical Operations courses, or should possess the equivalent skill level:

  • Microsoft® Office Excel® 2016: Part 1
  • Microsoft® Office Excel® 2016: Part 2

COURSE CONTENT

Lesson 1: Working with Multiple Worksheets and Workbooks

  • Use 3-D References
  • Consolidate Data

Lesson 2: Using Lookup Functions

  • Using VLOOKUP
  • Using MATCH
  • Using HLOOKUP

Lesson 3: Validating Data

  • Apply Data Validation
  • Edit Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Using Excel tools to work efficiently

Lesson 4: Macro

  • What is a macro
  • Recording a macro
  • Edit macro recording
  • Running a macro from Toolbar

Speaker

Suryamunawarah Usmani Othman

The System Support line with K U Sistem Sdn. Bhd. is where my career path began. For 2 years I have been involved with cabling, installation and configuration of networks, AutoCAD system, both for the company's internal and external customers.

Other employment is with UNIKL– IIM,as a Corporate Trainer. My main job function is to teach and at the same time handlingsupport using my previous experience. As a trainer, I taught various computer subjects such as Application courses, networking; which include troubleshooting, cablingand installation of Computer Network, Math subjects for Pre-Diplomaand other modulesas needed by the Academy.

With experience conducting training for various government and corporate Customers, I have always managed to get a very good feedback from my participants.

Surya's Qualifications:

Obtained American Associate Degree in Computer Science in 1994.Professional Qualifications include Microsoft Office Users Specialist for Word 2010 Expert, Excel 2010 Expert, Microsoft Access 2010 and PowerPoint 2010.

Train-the-trainer certificate from HRDC.

GET YOUR SPOT TODAY!

**HRDF CLAIMABLE**

This is a complimentary course (All you need to know) on Excel tailored for you. Attend Excelling In Excel (Advance) for RM599 only! Seats are limited.

*Price without SST

For more info do contact:

Amirah 017- 353 0453.

Share with friends

Date and Time

Location

Online Event

Save This Event

Event Saved