[01] OVERVIEW

Go further with Excel by learning to create charts and tables as well as learning time saving formatting and validation features. In this course, you will work with Microsoft Office Excel create charts and tables. You will learn handy formatting and tools for error checking. You will create formulas to that use built-in functions to do advanced analysis. You will also learn to create shared workbooks and to track changes in shared workbooks. This course is designed for students who are interested in going beyond basic skills and need to chart and format using Microsoft Office Excel This course is designed to teach you the Microsoft Excel all the way to Excel mastery. It's perfect for you if you are a beginner Excel user who needs to drastically increase your Excel skills. Everything in the course is taught step-by-step in an easy, stress-free way. Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do. An Excel journey that will reshape your existing skills. We will teach you in-demand Excel techniques that will allow you to transform your way of handling spreadsheet.

[02] COURSE OBJECTIVES

• Differentiate yourself at work. Quickly and dramatically

• Format sheets and charts professionally

• Understand advanced Excel functions

• Use Cell Styles and format spreadsheets easier and faster

• Learn several hidden Excel tips and tricks

• Become comfortable and familiar with the entire Excel dashboard, tabs and ribbons

• Use the most commonly used Excel functions to make powerful calculations

• Create your own Excel charts, graphs and tables

• Create pivot tables and charts for lightening fast sorting and organizing

• Learn tips, tricks and shortcuts along the way to help you master the Excel

[03] PREREQUISITES

Microsoft Excel [Any Version] Introduction or equivalent skills. Must be able to create, open, save, format and print a worksheet. Should be able to use formulas and the SUM function. The ability to copy, move and delete values and formulas is required.

[04] REQUIREMENTS

• Delegates enrolling for this course shall possess basic MS Excel skill

• The course can be performed in either Excel 2016 or Office 365 Excel Application. Delegates are required to bring along a laptop with sufficient battery power and/or power charger

[05] WHO SHOULD ATTEND

• People who are ambitious and want to grow faster than their peers

• Anyone who wants to use Excel at its best and wants to build complete financial models

• This course is perfect for a firs time beginner who needs to learn much more than just the basics

• This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more

• This course is helpful for increasing personal productivity, efficiency at work or even developing skills to obtain a better job

• This course would not be useful for an Excel user who has already reached the advanced or expert stage

[06] DATE, TIME & FEE

Date :    13-14 April 2023 (Thu-Fri)

Time :    8:30am - 4:30pm

Mode:    Online / Webinar

Level:    Intermediate

Fee: [HRDF Claimable]

- Early Bird Offer (before 30 Mar 2023)    -    RM 630

- Special Offer (before 6 Apr 2023)    -    RM 680

- Normal Fee   -    RM 730

>> Fee includes Course Notes & Certificate of Completion and 6% Government Service Tax

** OFFER **

- 10% Cashback for SST2u Learner Card+ (SLC+) members. T&Cs applied.

[07] COURSE CONTENTS

[01] Explore Excel

• Workbook and Backstage View / Excel Options

- Working with the Ribbon

- Working with the Quick Access Toolbar

- Auto Recover

• Working with Name Range

[02] Working with Constant Values and Formulas

• COPY and PASTE AS Options

• Using AutoFill / Flash Fill

[03] Working with Formatting and Data Validation

• Applying Conditional Formatting

• Using Data Validation

• Cell Formatting

[04] Working with Advance Formula / Functions

• Text Formula

• Date & Time Formula

• Logical Formula

• Lookup & Reference Formula

• Financial Formula

• Industry related solution practices [ Formula ]

[05] Using Protection and Shared Workbook Features

• Protecting Workbooks and Worksheets

[06] Working with Data

• Converting Text to Columns

• PASTE As Options

[07] Working with Charts

• Creating Charts

• Changing the Chart Location and Size

• Changing the Chart Type

• Modifying Chart Elements

• Formatting Chart Elements

• Adding and Removing Data Series

• Applying a Chart Filter

• Printing Charts

[08] Additional:

• Reference Styles [A1] & R1C1

• Outline [ Group – Ungroup]

• View [ Panes ]

[08] TRAINER PROFILE

UMA DEVI A/P SUBRAMANIAM

HRDF Trainer, Senior Microsoft Office Trainer/ Consultant

Uma Devi has 30 years of experience in training Excel, Data Analysis, Customized Database Programming and Presentation.

She holds a NCC Diploma in Computer Studies and completed programs including CVET, Digital Citizenship, Microsoft Office Specialist Excel 2016 etc. Her key areas of training expertise are:

- Windows & File Management

- Microsoft Outlook

- Microsoft Word, Excel, PowerPoint, and Access - (Basic, Intermediate, Advance levels)

- Microsoft Excel – Power Pivot, Formula & Functions, Dynamic Charts, Dashboard

Over the years, she has trained thousands of local and overseas attendees from more than 8 countries. She is also appointed Microsoft Office trainer for some large corporation. Her ability to supplement her trainings with real-life scenarios and examples, as well as training methodology that is easy to follow make her a popular trainer.

[09] REGISTRATION & ENQUIRY

Email:  Yes@SST2u.com

Enquiry:

- Teo (011 - 3178 9203)

- Logesh (012 - 503 0346)

- Siti (012 - 383 8603)

- Han (019 - 323 0507)