Basics of MS Excel

Insights Training is a pool of traning consultants offering their courses at an affordable investment.  We believe that training must be affordable but effective (and fun!) at the same time.Visit our website at www.insightsmanila.com for more details.Our office is located at 7F Finman Bldg., 131 Tordesillas St., Salcedo Village, Makati.  You may reach us at info@insightsmanila.com, 0977.103.1800.

Insights Training

Learn the basics of worksheet preparation, formulas, and tools using MS Excel and Google Sheets

Mpower Learning Manila

VENUE<ul><li>Mpower Training Center</li><li>222 Vivaldi Residences, EDSA cor Aurora Blvd.., Cubao, Quezon City</li><li>Bring own laptop</li></ul> INCLUSIONSFor onsite:<ol><li>printed handout</li><li>printed certificate</li><li>AM snacks</li><li>candies and coffee</li><li>WIFI access</li></ol>For via Zoom:<ol><li>PDF handout</li><li>PDF certificate</li></ol>OUTLINEModule 1. Introduction: MS Excel Module 2. Designing Your Worksheets (discussed in passing)-Formatting Cells: Borders, Fill Colors, Merging Cells, etc.-Sorting and Filtering Data-Using Freeze Panes to Improve Worksheet Interaction-Hiding and Inserting Rows, Columns, and Sheets-Adding, Deleting, and Renaming Worksheets Module 3. Essential Worksheet Functions-Basic Arithmetic Formulas: SUM, AVERAGE, etc.-Text Functions: UPPER, LOWER, CONCATENATE, etc.-Math Functions: SUM, COUNTIF, SUMIF, etc.-Absolute vs Relative Reference-Basic Logical Functions: IF-Using VLOOKUP to Relate Tables Module 4. Data and Formatting Tools-Using Text- to- Columns to Separate Texts-Applying Basic Conditional Formatting-Creating Basic Dropdown Lists Module 5. Introduction to Pivot Tables-Creating Pivot Tables-Formatting Fields-Presenting Information using Pivot Tables For fuill day classes, all schedules are set at 8AM-5PM. However, if the headcount is low, the training may be set at 9AM-4PM or 9AM-5PM. Your certificate, still, will indicate 8 hours.The start time and end time will be finalized three days before the class. Please look for an email from us or chat with us to confirm.

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}