Advanced Excel Training


June 14, 2018 - June 15, 2018 at 09:00 AM - 04:00 PM

Bonds Coworking Space, Iloilo

09771031800

inquire@insightsmanila.com



Advertisement


Click an image to zoom. Advanced Excel Training

EVENT #: 20526

EVENT DESCRIPTION

THIS CLASS IS IN ILOILO.




Get details faster: inquire@insightsmanila.com, 0977.103.1800




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 this event:  

EVENT LOCATION

Bonds Coworking Space, Iloilo
June 14, 2018 to June 15, 2018
09:00 AM - 04:00 PM
09771031800

RELATED EVENTS


TALK ABOUT THIS EVENT


OUR AFFILIATES



ADVERTISEMENTS