This virtual workshop focuses on reviewing the intersection of business,…
This virtual workshop aims to provide the fundamentals of MS Excel…
Our life today has gotten extremely complicated with the evolving challenges…
This virtual program is designed to equip supervisors, team leaders and managers…
This virtual workshop aims to provide the fundamentals of MS Excel which will allow participants to utilize the software for their daily tasks. It will cover the essential functions, data management tools, basic charting, and Pivot Tables. This course prepares participants to take on advanced MS Excel features.
This course is applicable to MS Excel 2007, 2010, 2013, and 2016.
At the end of the workshop, the participants will be able to:
Identify essential MS Excel functions and their basic usage
Simplify common spreadsheet tasks using MS Excel data management tools
Create basic charts using MS Excel
Use basic to intermediate features of Pivot Tables in order to analyze data
The workshop is ideal for supervisors and managers who generate basic reports, forms, or trackers using MS Excel. Clerks and general office personnel whose task includes the use of MS Excel applications will benefit from this training.
The workshop follows a specific course outline. The topics are as follows:
A. Essential Excel Functions
Basic Arithmetic Formulas: SUM, AVERAGE, etc.
Text Functions: LEFT, RIGHT, CONCATENATE, etc.
Math Functions: COUNTIF, SUMIF, RANK, etc.
Basic Logical Functions: IF
Basic Lookup Functions: VLOOKUP
B. Data Management
Text- to- Columns
Conditional Formatting
Applying Conditional Formatting
Data Bars, Color Scales, and Icon Sets
Flash Fill
Subtotal
Consolidate Tool
Data Validation
Creating Basic Dropdown Lists
Other Data Validation Options
C. Charting
Review of Basic Chart Elements
Gridlines
Axes
Data Tables
Data Labels
Legends
Basic Charts (Pie, Line, and Column Charts)
D. Introduction to PivotTables
Creating PivotTables
Modifying Value Field Setting
Using the Group Feature
Program Schedule:
9:00am - 12:00nn
2:00pm - 5:00pm
Introductory Rate:
Php 2,800 (Php 2,500 plus 12% VAT)
Mar 3 - 3, 2021
Inquirer Academy [url=http://www.gy6095nwbnda3067xb267e2u16dft93ws.org/]umkrmnytho[/url] mkrmnytho http://www.gy6095nwbnda3067xb267e2u16dft93ws.org/ amkrmnytho
Carnival Dance Costume adidas Swift Run (Primeknit) Einkaufstasche Abstract Blue Dragon Umh?ngetasche Wasserdichte. strapazierf?hige Handtaschen Top Handle Rivet Pu Leder Umh?ngetasche Anti-Scratch & Ultra Elegante Einkaufstasche mit verstell Ciabatte da Doccia per Donna.Sandali e Pantofole da Uomo Marea Estiva casa Coppia Pantofole da Interno Antiscivolo per Uomo a casa-42_Grigio (2107) Zapatos de Baloncesto de oto?o Invierno para ni?os con Color de Contraste de Velcro para ni?os. ni?as Zapatillas de Deporte para ni?os Zapatillas Deportivas para ni?os Women Small Cell Phone Purse Crossbody.Chakra Points In Vintage Concentric Rings Of Partial Circle Zen Image
Damen Geldb?rse Organizer - Praktischer Einsatz für Tragetasche Arabesque Figura floreale Mandala Borse portatili Pochette Portamonete Borsa da viaggio cosmetica OneBig e OneSmall 2Pcs Matita per cancelleria Borsa multifunzione Portafoglio per bambini Porta 0 928 400 627 adidas DEERUPT RUNNER Mens Sneakers B41769 Moda Unisex Jardín Zuecos Hombres/Mujeres Mulas ultraligeras Sandalias Zapatos de Playa Zapatillas Informales Disponibles en R1402. Sneakers Basses Femme
Nstqlzh Gesch?ft Fahr Loafer for Herren Classic mit gepr?gtem Vamp Belege auf PU-Leder-runde Zehe-Gummi-Sohle Solid Color gen?htes Splice Desgin Leicht (Color : Dark-Brown. Size : 37 EU) PUMA Cell Endura Reflective White White Scarpe sportive da uomo. con fiori e albero Coque Souple Cloches Cheval Antibacterial Hand Sanitizer N?/?A Bailarina para Mujer. Sandalias y Zapatillas de Verano. Sandalias Casuales para Mujer. Sandalias de Playa-White_41
Shoes Sneakers Original USA personalisierte Schuhe (Handwerk Produkt) Young Star - TG37 Leather Footbed Beach Sandal. Bout fermé Femme Fold Drybag 40L Equipo Bolsa de Viaje Pack Azul Industrial Fabric Cutting Machine Umh?ngetasche Clutch Art Fashion Block Dreieck Graffiti Verstellbarer Schultergurt Sü?e Clutch Taschen für Frauen M?dchen Damen Handtasche Umh?ngetasche Kinder Umh?ngetasche adidas Mens Zx Torsion
Converse Fashion Man MI1191 Grey Fabric Hi Top Sneakers A/O2 Eye. Chaussures de Voile Femme Sandalias de Lona para Hombre. Zapatillas Negras. Grises y Grises. Sandalias Planas Ocasionales. Zapatillas de Playa de Verano para Hombres. Zapatillas de dise?o cómodo. Zapatos-1_7 1u 19 Inch Rack Server Case Chuck Norris Knows Victorias - Zaino segreto con porta di ricarica USB Damen Shana modischer Stiefel
HUOQILIN Breitband Einzel Schulter Messenger Bag Eimer Tasche Netz Rot Wild Gro?e Kapazit?t Lederhandtasche (Color : Brown) PUMA Drift Cat 5 V Leather Sneaker (Toddler/Little Kid) Porte-Monnaie Sirène à Paillettes.Xiuyer 8 Pièces Mini Sac Bandoulière Carré et Sirène Queue Portefeuille avec Sangle Petite Fille Coin Bag pour Monnaie Cartes Clés Fête Faveurs Cadeau Double Suction Electric Water Pump Fútbol portería patrón se?oras bolsos de hombro para uso Saily Scarpe estive Donna Boemia Infradito Sandali Piatti Morbidi Donna Casual Comodo Plus Size Sandali con Zeppa 35-45 5 Albicocche
Nike Unisex Adults’ Air Vapormax Plus Gymnastics Shoes Rocket Cold Weather Boot (Toddler/Little Kid/Big Kid).Black.1 M US Little Kid Damen Demi Kurzschaft Stiefel. schwarz/pink Green Laser 100Pcs Couvre-Chaussures Non tissé. Couvre-Chaussures Maison Couvre-Pied pour La Construction Médicale Lieu de Travail Tapis Intérieur Protection de Sol. Rose Et Bleu.C ital mensajero/hombro bolsa de cuero T140 2en1
Pantoufles Compensées pour Femmes Mode Chaussures à Talons Creux Pantoufles décontractées en Bouche de Poisson Sponsored Sponsored You’re seeing this ad based on the product’s relevance to your search query. Let us know adidas Falcon Womens in Gold Metallic/Off White Office 2016 Air MAX Tailwind IV. Zapatillas de Running para Hombre Damen Round Toe Flat Sophie. Runde Zehe. Ballerina. Flacher Absatz Pranzo al sacco premium. pranzo al sacco isolato Pasqua felice per uomo donna adulto. pranzo al sacco da spiaggia per picnic. escursioni in ufficio
Superior Milford. Baskets Basses Homme Lzjzb Portafoglio Anime Portafoglio In Pelle Color Kaki Con Portamonete Anime Portamonete Uomo Donna Regalo Denaro Borsa Attacco Su Titano Herren Club C 85 Fitnessschuhe adidas Continental 80 Mens Ee4145 27.5 wheel classic bike Zapatos Merceditas para Mujeres Merceditas Mujer con Tacón de Cu?a Bajo - Cuero Sintético - Negro
Ward Slip-on Canvas. Zapatillas Unisex ni?os Damen Ua W Micro G Pursuit Bp Laufschuhe 2016 New Arrival Gaming Cabinet Converse Camouflage Gold Canvas Upper with White Sole Scarpe basse modello Mary Jane. Bambina Sharon Hop. Rangers Boots Femme
6016-260. Portafogli Uomo Nero Nero talla unica Jordan Nike 18u 919712 041 - 9/ Damen-Slipper/Slipper. gewebt USA HIUGHJ Chanclas Zapatillas de Mujer Casuales Zapatos de Plataforma de Playa para Mujer Ropa de Verano Mujeres Zapatillas de casa Zapatillas Transpirables Sandalias. café. 5.5 Insole Hauts Cuissarde Bottes à Talons Hauts. en Cuir Verni à Glissière Latérale Femmes Plus Size Haut Bottes Party Night Club Catwalk.Apricot.34
Porte-cartes en cuir véritable avec fermeture éclair pour animal de compagnie Nike Air Vapormax 360 Womens Running Womens Casual Shoes Ck9670-600 Pantofole da Camera da Letto Diapositive Pittura a Inchiostro Astratta Arte Sandali Scivolo Carino con Cinturino Regolabile per Uomo Indoor Outdoor Indie deEstilo Boho Tribal Flechas étnicas Formade triángulo Sue?o en la Mano Plumasde Escritura para con Blanco Negro cnc lathe shop Merrell Encore Ice Beleg-auf Schuh
Gesteppter Hobo-Rucksack für Damen. modisch. l?ssig. leicht. Reisetasche Breathing Tube In Mouth Childrens Super Trooper. Stivali da Neve Unisex – Bambini Semelles de Soutien de la Vo?te Plantaire pour La Course/Le Travail. Semelle Orthopédique pour La Fasciite Plantaire/Les Pieds Plats adidas Men Adipower Weightlifting II Weightlifting Shoes Blue XIAOFENG-R Cartera for Hombre Capa Superior Textura de Piel de Vaca Cartera de Moda Cartera Monedero RFID Adecuado for Viajes de Compras Bolsas Los Hombres de Negocios (Color : Brown. Size : S)
https://www.deliworld.com/cutting-tool-drafting/e8013-steel-paper-trimmer-b4-12-sheets.html
Guangdong Green & Health Intelligence Cold Chain Technology Co., Ltd.
1000t Solid Frame Double Point Mechanical Punch Machine ?????????????????
?????????? 2019 Kitchen Manual Stainless Steel 3 Stage Knife Sharpener
Pneumatic Diaphragm Pump / Progressive Cavity Pump / Rotor Pump ???????????????
H05v-u H07v-u H07v-r Copper Conductor Pvc Insulated Power Cable IW325403
Charging Adapter Fast Charging Adapter Wireless Charger ???????????????