Microsoft Excel: Basic to Advance

Microsoft Excel:  Basic to Advance

8:30 AM – 4:30 PM

Unit 3C Marsk Bldg., Aurora Boulevard corner Balete Drive, Barangay Kaunlaran, Quezon City 1111 (near UnionBank and Robinsons Magnolia)

No. slots: 13

​

Requirements:

• Bring your Windows laptop

• Must have MS Excel installed.  Version 2016 / 2019 / 2021 / Microsoft 365

• Must have basic computer skills

Inclusions:

• Light snacks and meal

• Softcopies of Handouts and Excel templates

• Certificate  

Objective:

• To understand the purpose of a spreadsheet

• To quickly access and use the commands in the spreadsheet

• To master Excel functions and formula

• To utilize Excel in calculating, organizing, and summarizing data

Topics

• Introduction to Spreadsheet

• Basic Commands and Tools in Excel

• Time Saving Tools and Excel Shortcuts

• Fundamentals of Excel Functions and Formula

• Concatenates

• Name Range and Structured Reference

• Math Functions

  • SUM, COUNT, COUNTA, AVERAGE, MAX, MIN

  • SUBTOTAL, AGGREGATE

  • SUMIFS, AVERAGEIFS, COUNTIFS

• Lookup Functions

  • VLOOKUP/HLOOKUP, INDEX-MATCH, XLOOKUP

• Logical Functions

  • IF, Nested IF, IFS, AND/OR

• Conditional Formatting

• Charts & Graph

• PivotTable and PivotChart

• He received certification from Asian College for training in Microsoft Excel.
• He is a Certified Microsoft Office Specialist - Excel Expert
• He develops programs using VBA, and Python and manages business data SQL and Access and other ETL and data modeling and visualization in Power BI
• He already trained hundreds of professionals, entrepreneurs, and employees from various companies such DITO Telecommunity, Frontier Towers, Froneri Philippines, ZARA Philippines, DSLU Dasmarinas, PetWarehouse etc.
• JTR Training Consultancy Services owned by him is awarded as Best Reliable Microsoft Training Service Provider at the 15th Golden Globe Award for Business Excellence