This course aims to demonstrate the application of advanced MS Excel functions and tools on more data-driven tasks. Aside from reviewing the essential functions, this course will introduce less common functions which may be used to further ease and simplify spreadsheet tasks.
The course will also cover data management tools and their advanced usage, how to create special charts, a thorough discussion on Pivot Tables, and an introduction to macros.
This course is applicable to MS Excel 2007, 2010, 2013, 2016, and 2019.
At the end of the workshop, the participants will be able to:
Create general macro recordings to automate basic repetitive tasks in MS Excel
Introduce essential codes in VBA
Create decision and loop structures in VBA—which ultimately automates most tasks in MS Excel
Create user forms that can be used by the spreadsheet to interact with the users
Create user-defined functions that can be deployed in the workplace
The workshop is ideal for supervisors and managers who generate reports, forms, or trackers using MS Excel. Also for employers working with large amounts of data using the application, and those who want to learn more of its functions and tools.
The workshop follows a specific course outline. The topics are as follows:
MS Excel Functions
Text Functions
Combining Texts
Changing Case
Other Accessory Text Functions
Logical Functions
Basic IF Statements
Nested and Series IF Statements
Math Functions
Basic Math Functions
Named Ranges
Conditional Math Functions
Date Functions
Lookup Functions
VLOOKUP
Advanced Lookup Functions
B. Data Management Tools
Text-to-Columns
Delimited
Fixed Width
Conditional Formatting
Basic Conditional Formatting
Formula-Based Format
Data Validation
Basic Dropdown Menus and Cell Validations
Dependent Dropdown Menus
Subtotal
Consolidate Tool
Flash Fill
C. Charts
Basic Charts
Combination Charts
Complex Charts
Sparklines
D. PivotTables
Basic PivotTable Features
Tables
Advanced PivotTable Features
E. Introduction to Macros
Understanding Macro Security
Macro Recording
Assigning Macros to Images and Buttons
Program Schedule:
Day 1
9:00am - 12:00nn
2:00pm - 5:00pm
Day 2
9:00am - 12:00nn
2:00pm - 5:00pm
Introductory Rate:
Php 5,040 (Php 4,500 plus 12% VAT)
Dec 1 - 2, 2020
Inquirer Academy [url=http://www.g7qr7270j3061rt78v76etmw1uk6sz3ws.org/]ubqrdzyrky[/url] bqrdzyrky http://www.g7qr7270j3061rt78v76etmw1uk6sz3ws.org/ abqrdzyrky
R1402. Sneakers Basses Femme 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 Moda Unisex JardÃn Zuecos Hombres/Mujeres Mulas ultraligeras Sandalias Zapatos de Playa Zapatillas Informales Disponibles en 0 928 400 627 adidas DEERUPT RUNNER Mens Sneakers B41769 Damen Geldb?rse Organizer - Praktischer Einsatz für Tragetasche
Fold Drybag 40L Equipo Bolsa de Viaje Pack Azul adidas Mens Zx Torsion 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 Industrial Fabric Cutting Machine Shoes Sneakers Original USA personalisierte Schuhe (Handwerk Produkt) Young Star - TG37 Leather Footbed Beach Sandal. Bout fermé Femme
adidas Skateboarding Superstar Arizona SFB. Sandali a Punta Aperta Unisex-Adulto One 19.3 FG/AG. Chaussures de Football Homme Air Riflescopes Women Mini Purse Crossbody of Cell Phone?Hypnotic Effect Crooked Spiral Vortex Circles On Dark Background Coopay Cartera mujer gran capacidad cuero PU. bolso de embrague largo piel sintética 11 Porta tarjetas 2 ranuras para tickets Monedero con cremallera para el teléfono celular universal.Rojo
Chuck Norris Knows Victorias - Zaino segreto con porta di ricarica USB A/O2 Eye. Chaussures de Voile Femme 1u 19 Inch Rack Server Case Converse Fashion Man MI1191 Grey Fabric Hi Top Sneakers 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 Damen Shana modischer Stiefel
My Hero Academia Chaussures à Lacets Populaires Chaussures Haut élégant Lacer Chaussures Unisexe Anime Sneakers imprimé Chaussures en Toile Unisexe Chaussures Hautes N-Ethyl-2-Pyrrolidone Nike Air Vapormax GS Running Trainers 917962 Sneakers Shoes (UK 6 US 6.5Y EU 39. Phantom 002) KLLR Cobra Black Yellow Red 1062 Rolls - Avarcas Menorquinas para Hombre con Suela Anatómica y Cierre en Velcro en Color Natural Borsa a tracolla media per donna. Pelle lavata vacchetta.- Colore pelle-.
PUMA Drift Cat 5 V Leather Sneaker (Toddler/Little Kid) Fútbol porterÃa patrón se?oras bolsos de hombro para uso Saily 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 HUOQILIN Breitband Einzel Schulter Messenger Bag Eimer Tasche Netz Rot Wild Gro?e Kapazit?t Lederhandtasche (Color : Brown) Scarpe estive Donna Boemia Infradito Sandali Piatti Morbidi Donna Casual Comodo Plus Size Sandali con Zeppa 35-45 5 Albicocche
Green Laser ital mensajero/hombro bolsa de cuero T140 2en1 Damen Demi Kurzschaft Stiefel. schwarz/pink Nike Unisex Adults’ Air Vapormax Plus Gymnastics Shoes 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 Rocket Cold Weather Boot (Toddler/Little Kid/Big Kid).Black.1 M US Little Kid
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 Pantoufles Compensées pour Femmes Mode Chaussures à Talons Creux Pantoufles décontractées en Bouche de Poisson Office 2016 Pranzo al sacco premium. pranzo al sacco isolato Pasqua felice per uomo donna adulto. pranzo al sacco da spiaggia per picnic. escursioni in ufficio Damen Round Toe Flat Sophie. Runde Zehe. Ballerina. Flacher Absatz Air MAX Tailwind IV. Zapatillas de Running para Hombre
adidas Continental 80 Mens Ee4145 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 27.5 wheel classic bike Herren Club C 85 Fitnessschuhe Zapatos Merceditas para Mujeres Merceditas Mujer con Tacón de Cu?a Bajo - Cuero Sintético - Negro
Damen Ua W Micro G Pursuit Bp Laufschuhe 2016 New Arrival Gaming Cabinet Ward Slip-on Canvas. Zapatillas Unisex ni?os Sharon Hop. Rangers Boots Femme Scarpe basse modello Mary Jane. Bambina Converse Camouflage Gold Canvas Upper with White Sole
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 Jordan Nike 18u 919712 041 - 9/ 6016-260. Portafogli Uomo Nero Nero talla unica Damen-Slipper/Slipper. gewebt USA Insole Hauts Cuissarde Bottes à Talons Hauts. en Cuir Verni à Glissière Latérale Femmes Plus Size Haut Bottes Party Night Club Catwalk.Apricot.34
cnc lathe shop Porte-cartes en cuir véritable avec fermeture éclair pour animal de compagnie Indie deEstilo Boho Tribal Flechas étnicas Formade triángulo Sue?o en la Mano Plumasde Escritura para con Blanco Negro Merrell Encore Ice Beleg-auf Schuh 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
Semelles de Soutien de la Vo?te Plantaire pour La Course/Le Travail. Semelle Orthopédique pour La Fasciite Plantaire/Les Pieds Plats Breathing Tube In Mouth adidas Men Adipower Weightlifting II Weightlifting Shoes Blue Gesteppter Hobo-Rucksack für Damen. modisch. l?ssig. leicht. Reisetasche 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) Childrens Super Trooper. Stivali da Neve Unisex – Bambini
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 ??????????
High Frequency Filter Vibrating Screen Supplier ?????????????
??????????????? 2019 Kitchen Manual Stainless Steel 3 Stage Knife Sharpener
IWC???????????? H05v-u H07v-u H07v-r Copper Conductor Pvc Insulated Power Cable
?????????????? Charging Adapter Fast Charging Adapter Wireless Charger
????????????? Fleet Key Management System?Property Management Key Systems?Automotive Key Management System
?????????????????? Hunan Injection High Technology Co., Ltd.
Hubei Lanhuhuayuan Intelligent Machine&Package Manufacturing Co., Ltd.
N???????????????? 72 cells poly solar panels 310w330w340w350w
?????????????????? Carefully Selected Materials Germany Bar Diode Laser Stack
?????????????????? 3ml 5ml 10ml 15ml crimp neck perfume glass vials
???????????? Customized electroplated brass turning parts processing machinery parts
???????????????????? Automatic Wheel Polisher jordan sale cheap
Astm A106 Seamless Pipe ?????????? authentic louis vuitton purse with flowers
Transparent Pvc Film Price louis vuitton belt how much ??????????
cheap louis vuitton diaper bags ?????????????????? Inch Drywall Screws
??????????????? louis vuitton sweater Sodium Beta Hydroxybutyrate
???????????? vintage louis vuitton pochette arts-deco gm black epi clutch bag alcohol based cleaning wipes
Carboxtmethyl Cellulose cheap jordan prime 5 ????????????????
???????????????? Cardio Equipment cheap michael jordan 23 quotes
cheap concord jordan 11 2013 holiday Automatic N95 Mask Machine ????????????
China Din766 Calibrated Chain ????????????? louis vuitton agenda inserts
buy louis vuitton purses canada Internal Mixing Mill ??????????
louis vuitton totally monogram tote Corrugated Box ????????????
?????????????????? gucci top handles Nylon Rollers With Sealed Bearings Supplier
vintage louis vuitton date codes Herb Product Price ???????????
???????????????? genuine louis vuitton at discount Kids Clothing
Hot Sale Leather ????????????????? cheap jordans youth size 7
louis vuitton neverfull handbag sizes Roll Stand For Corrugated Line ????????????????
Fully Automatic Machining Center louis vuitton artsy gm brown ??????????????
???????????????? louis vuitton backpack m51135 Auto Paper Slitting Machine
Best Inline Skating Helmet ??????????????? louis vuitton vintage bag
vintage louis vuitton deauville Battery Operated Hydraulic Power Pack ??????????????
????????????? Flour Bag Making Machine air jordan 14 last shot retro for cheap
??????????? cheap michael nike air jordan 6 shoes Uvc Light Sanitizer Supplier
?????????????????? louis vuitton for sale cheap bmx bikes 3 Ply Facial Tissue
Cloth Insert Sandblast Hose ?????????????????? mens jordans shoes for cheap
Joining Two Electrical Cables ???????? cheap air jordan 3iii men grey red black grey
Orthopedic Splints And Appliances louis vuitton damier papillon ??????????????
Petrol Wood Cutting Machine ????????? gucci women sunglasses 2591
????????????? celebrities carrying louis vuitton handbags Channel L Plate Fitting
????????? Station Metal Detector louis vuitton bags stock greece
Mono Silicon Wafer For Diode cheap air jordan v fire red white black fire red ??????????????
air jordan 5 metallic retro for cheap iphonexr????????????? Axis Uv Printer
Big Wine Glass ???????????????????????? air jordan xii original og taxi white black for cheap
Pet Teeth Cleaning ToysSet Or Dog/Cat Teeth Cleaning Toys air jordan 5 bel air retro cheap ??????????????????
China Baby Mermaid Swimsuit ????????????? louis vuitton usa online
1440p 144hz Monitor 27 Supplier ????????????? lv luggage wholesale china handbags
Marble Jesus And Animal Sculpture louis vuitton chicago ???????????????????
xperiaxz?????????? online sales on lv Rotolight Titan X1 Review - Newsshooter
cheap air jordan xi retro gamma elephant print ??????????? HYDRAULIC
Light-Duty Trucks cheap air jordan 3 quarter inch ?????????????
??????????????? Bicycle Tire Inner Tube louis vuitton henkel
cheap jordans target free shipping items ????????????????? Cotton Rugby Shirts
???????????? Custom Printed Oven Mitt louis vuitton neverfull large tote