₱2,870 – ₱3,073.98

Advanced MS Excel Training (Cebu)

Event Information

Share this event

Date and Time

Location

Location

Career First Institute

1 Salinas Drive

Cebu City, Central Visayas 6000

Philippines

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

THIS CLASS IS IN CEBU.

This course aims to provide learners with a foundation for MS Excel knowledge and skills, which they can build upon to eventually become an expert in data manipulation.

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

Topics:

I. MS Excel Functions

a. Text Functions

i. Combining Texts

ii. Changing Case

iii. Other Accessory Text Functions

b. Logical Functions

i. Basic IF Statements

ii. Nested and Series IF Statements

c. Math Functions

i. Basic Math Functions

ii. Named Ranges

iii. Conditional Math Functions

d. Date Functions

e. Lookup Functions

i. VLOOKUP

ii. Advanced Usage of VLOOKUP

iii. Advanced Lookup Functions*


II. Data Management Tools

a. Text-to-Columns

i. Delimited

ii. Fixed Width

b. Conditional Formatting

i. Basic Conditional Formatting

ii. Formula-Based Format

c. Data Validation

i. Basic Dropdown Menus and Cell Validations

ii. Dependent Dropdown Menus

d. Subtotal

e. Consolidate Tool

f. Flash Fill (if 2013 or 2016 version)


III. Charts

a. Basic Charts

b. Combination Charts

c. Sparklines


IV. PivotTables

a. Basic PivotTable Features

b. Tables

c. Advanced PivotTable Features


V. Introduction to Macros

a. Understanding Macro Security

b. Macro Recording

c. Assigning Macros to Images and Buttons

Share with friends

Date and Time

Location

Career First Institute

1 Salinas Drive

Cebu City, Central Visayas 6000

Philippines

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved