THIS CLASS IS IN ILOILO.
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.
Outline
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
