This course teaches participants how to use macros to automate their daily tasks in MS Excel. They will also be taught how to enhance automation through Visual Basic for Application (VBA) which is a programming language used by the MS Office suite.
Knowledge of this skill ultimately simplifies reports by creating modules that would execute spreadsheet tasks in just one click! This saves the company time,from tedious and manually-completed reports.
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 advanced MS Excel functions and their usage
Combine Basic MS Excel functions with advanced functions in order to address more complex scenarios
Simplify common spreadsheet tasks using MS Excel data management tools
Create basic and special charts using MS Excel
Use advanced features of Pivot Tables in order to analyze data
Create macro recordings to automate tasks in MS Excel
The workshop is ideal for advanced users of MS Excel who wish to expand their knowledge of Excel with VBA in order to automate tasks. Also for employers working with large amounts of data using the application, and those who want to learn how to automate reports.
The workshop follows a specific course outline. The topics are as follows:
Macro Recording
Creating Macros
Exploring Macro Security
Recording and Running a Macro
Using Relative Reference
Assigning a Macro to an Excel Object
B. Introduction to VBA
Exploring the VBA Interface
Exploring the Properties Window
Defining the Properties
Modifying Properties
Introduction to Creating Codes
C. Programming Basics
Essential VBA Codes
Different Ways of Calling Cells
Creating Basic Modules
D. Control Structures
Decision Structures
Then If, Then Statement
If, Then, Else Statement
If, Then, Elself Statement
Loop Structures
For, Next Loop
For Each, Next Loop
Do Until, Loop
E. Creating Your Own Functions
Declaring Variables and Constraints
Using IF to Create Functions
F. Creating UserForms and UserForm Events
Adding UserForms
Adding Form Elements
Creating Modules for UserForms
G. Handling VBA Module Errors
*Program fee is PHP 11,800 + VAT
Aug 28 - 29, 2019
Inquirer Academy yfzoccnkx http://www.gc379384ws0cy5patmt4s0558a38poi0s.org/ [url=http://www.gc379384ws0cy5patmt4s0558a38poi0s.org/]uyfzoccnkx[/url] ayfzoccnkx
Damen Verbier Tiny Neckpouch Lvz Geldb?rse FeiFei156 Sandali Femminili di Estate di Nuovo Boemia Punta della Clip Infradito Open Toe Tacco Sandali delle Donne Pearl Bassi Ciabatte da Spiaggia Antiscivolo (Color : Apricot. Size : 41) COTTON vest Portefeuille Femme Porte-Cartes de Portefeuille Simple Conception Rivet for Femmes (Color : Noir. Size : One Size) adidas Originals EQT Support MID ADV PK SolesTM - Chanclas ortopédicas con soporte de arco para adultos. unisex. color Azul. talla 36 2/3 EU
Clkdasjd Borsa a Tracolla da Donna. Borsa per Cellulare Portafoglio da Viaggio [Pelle Vintage]. Gialla Sacs Bandoulière Nouveau Sac Carré Simple à Bandoulière En Paille Pour Femme CafePress – Mancuernas – Bolsa de lona natural. bolsa de la compra de ropa. lona. caqui. Medium AN-JING Tragbar Gro?r?umige Schultertasche Mann Oxford Taschen Reisetasche Mode-Studenten (Color : Black. Size : 19 INCHES) adidas Crazylight Boost Basketball Shoes MS Plain Weave Wire Mesh
Bullet-M - Zapatillas para Hombre Azul/US Maenner Sac à Main/Epaule/Bandoulière/Porté à la série de princesse avec n?ud à deux boucles Populaire Fashion Mode Elegant pour Filles/Femmes Shopping en PU #BBFB467 (gris) Moonlight Wolf Print Fashion Round PU Leather Crossbody Handtasche Round Shoulder Bag For Women Girls adidas Originals Ozweego. core Black-Solar Green-Onix. 4.5 1-10v Dimmable Led High Bay Light Suppliers for Sale Sneaker da donna Basket Heart Patent
Scarpe da Uomo Scarpe di Pelle British Business Morbida Sole Coreano Uomini di Modo Traspirante Youth Shoes Formale Abbigliamento da Lavoro. 36-47 Calzature Sportive (Color : Black. Size : 44) adidas Sneakers Unisex AW Ball Soccer EG0903 Nero Hjbds De la Goma de Interior Ejercicio Yoga Zapatos Zapatillas Gimnasio Los ni?os Bailan Ballet Zapatos de Las Muchachas de la Bailarina Mujer Ni?os (Color : Red. Shoe Size : EU45(26cm)) RSL Lacet 1 Paire 14 Couleurs Chaussures Solides Lacets Lacets Ronde extérieure Chaussures de Sport et Bottes Lacet 80cm 100cm 120cm 140cm 160cm Shoestring (Color : Red Brown) Einzigartige Abstrakte Polygonale Dunkelblau Frauen Trifold Brieftasche Lange Geldb?rse Kreditkarteninhaber Fall Handtasche Best Mini Laser Engraver
Cireuse de chaussure Service de cireur perceuse électrique. portable Accueil Mini cireuse de chaussure réglable Brosse automatique de chaussures. for le nettoyage de soins en cuir Pinceaux. rouge poli Babypac 100 Ventilator XXD Mocasines para Hombre Zapatos de Cuero Casual de los Hombres Zapatos Planos Mocasines Zapatos de Negocios Mocasines de conducción de ZapatosBlack-6UK PUMA Unisex Adults’ Lqdcell Optic Sneaker Ultime Nigeria Svizzera Laces di Alta Qualità Svizzera Voile Laces Svizzera Cotone africano secco Tessuto di Pizzo per Uomo Donne A983 WZLJW Klassische Bequeme Sandale. Stein Acupoint Fu?massage Hausschuhe-Red_44-45. Klassische Bequeme Sandale ggsm
Sneaker Bambina Pelle Sintetica Nero Mujer Cartera/Billetera Piel Alargado Cartera de Mano. Marrón MICEROSHE Chausse-Pied Confortable Chaussures en Alliage métallique Horns Forme Dolphin Chausse 60cm Heavy Duty Chaussures Corne Chaussures Helper baton très utile Gadget Design élégant et Léger Converse Fashion Woman MI1253 White Fabric Hi Top Sneakers Women Mini Purse Crossbody of Cell Phone?Wavy Curved Tone Stripes with Spiral Swirl Lines Arabesque Pattern Packing
adidas Ozweego Sneaker Men Harley Davidson Uomo Diversion Pelle Stivali Triactive Knit. Sneakers Basses Homme Monedero peque?o para teléfono Celular Cartoon Animated Patrick Star Lightweight Small Crossbody Bags Leather Cell Phone Purses Travel Pouch Shoulder Bag Wallet with Credit Card Slots for Women Products AN-JING Tragbar Leder Herrenhandtasche 14 Zoll Computer Tasche Business Einfache Herrenhandtasche Einzigen Haupttasche Dünnschliff Aktentasche (Color : Black. Size : XL)
AQ6272 Stan Smith J. Basket Mixte Enfant SDCVRE Bolsa de la Compra.Bolso de Compras Reutilizable Bolso de Mujer ecológico Bolso de Playa Plegable Bolso de Hombro de Uso Diario Bolso de Lona con Estampado de Flores Casual. Azul Ciel China Sandals and Slippers price Hardworking person-ZHL Zaini La Scuola Borse per Adolescenti. Zaino per La Scuola. Superiore Zaino da Giorno College. Borse Scuola Secondaria. Grande Zaino da Giorno. con Porta di Ricarica USBBlack Spring Summer 20 Herren Ua Speedform Gemini 2 Turnschuhe
Womens Go Run 600 Sports Lace Up Mesh Trainers adidas Arkyn W 10kw Generator Engine Homme X -MISSION 3. Chaussures de Trail Running Borsa Pu. Borse a zainetto Donna Standard Kartenetui - Leder genarbt
Dans Sacs à Main Portés épaule Femme Nouveau Sac De Tissage Du Vent Tissage Sac De Paille Sac Sac à Bandoulière Sacs à Main Sac De Plage Vacances PUMA Basket Trim Block Low Boot Sneaker Schwarz-Gold-Weiss Zainetto per bambini per Asilo o Tempo Libero con Cintura Toracica/ Mini Backpack. Starlight Magenta Schlanke Leder Geldb?rse Herren mit RFID-Schutz. Geldbeutel mit Münzfach und Zwei Geldscheinf?chern 12x10x1cm Baby Diaper Counting Machine Vonda - Botas de piel suave con 14 ojales para mujer. color negro
PUMA Mens BMW MMS Motorsport Drift CAT 7S Ultra Black Athletic Driving Shoes 3 in 1 Baby Walker Miss99 1 Paar Flache Schnürsenkel elastische No Tie Schnürsenkel Unisex Turnschuhe Schnürsenkel Schnell Faul Schnürsenkel Trainer Schnürsenkel Ersatz K?nigsblau Siren Edge 3 WP. Chaussure de Marche Femme Rider Pool Fem Sandalia Mujer Negra/Rosa Da donna Scarpe Finta pelle Autunno Inverno Anfibi Fodera di lanugine Stivali da neve Stivaletti alla caviglia Stivaletti Punta tonda . fuchsia . us6.5-7 / eu37 / uk4.5-5 / cn37
PUMA Juniors Future 6.1 Netfit Fg/Ag Shoes Women Small Cell Phone Purse Crossbody.Tranquil Tiergarten In Berlin Germany Forest Sightseeing Urban View Autumn Season Wenhua Adulti Sandali a Punta Aperta.Rotating Massage Slippers. Health Massage Slippers-Brown_44-45Leggeri Ciabatta a Punta Aperta Gold-Zip Portemonnaie. 20 cm. Liter. Schwarz Python Automatic Liquid Dispenser Portefeuille à deux rabats pour homme avec blocage RFID
adidas Originals Pod-s3.1 - Womens G54745 Grey Sakroots Damen Arcadia Finn Crossbody Umh?ngetasche AKIELO Monedero YCKZZR Chaussures à Talon Femme Ete Womens Fish Bouche Haut Talon Sandales Femme Cuir Bottes Courtes Escarpins Retour Zipper.Heel Height 12cm.35 150w Ufo High Bay Uomo Sandali Sandali Traspiranti da Spiaggia in Pelle Casual Antiscivolo per Uomo Sandali Sportive Uomo (Colore : Marrone. Size : 42)
FS65 di Sicurezza. da Uomo. Modello Gibson. con Puntale Rinforzato in Acciaio. Colore: Nero. da Lavoro Damen Rucksackhandtasche schwarz L008-Black Agricultural Herbicide Sprayers Court Borough Mid 2 (GS). Zapatillas de básquetbol Unisex ni?os adidas Harden Vol.3 Mickey Mouse Shy-Sac à Bandoulière Rond (Petit)
adidas Gazelle W - BY9357 65 Inch Video Wall Display Sandali Estivi Pantofole Donna.Pantofole Con Plateau In Pelle Blu Rosso Vino Traspiranti Punta Aperta Boemia Beach Scarpe Antiscivolo Per Signora Ragazza Sandali Da Passeggio Casual Da Ufficio Ant 25550 Herren Sandalen NMD_R1 PK. Zapatillas de fitness para hombre Portefeuille Homme en Cuir de vêtement à Fermeture à glissière en Cuir pour Affaires européen et américain. Couche supérieure en Cuir. Sac à Main. Sac à Main. Brun
Bruno Marc Prince Zapatos de Cordones Vestir Oxford Clásico para Hombre XLDN-Sacs Baotou Layer Oxhide Sac à bandoulière en Cuir pour Homme (Color : Khaki. Size : S) GW 4G15E Trekker II. Scarponi Impermeabili Softshell da Uomo - Intersuola in Phylon. Fodera in Rete. Suola in Gomma. Linguetta Imbottita - per Escursioni Converse Fashion Woman 164555C001 Black Fabric Hi Top Sneakers Cigarette Case Metal Cigarette Case Automatic Pop-Up Cover Men Going Out Carrying Metal Cigarette Case
Laser Marking Machine GUESS Rocksand Texapore Mid M Wasserdicht. Chaussures de Randonnée Hautes Homme PUMA Basket Matte and Shine Pin on Trump 2020 Unisex Outdoor-Schultertasche Brust Schulterrucksack Umh?ngetaschen Sneaker Personalizadas Original Hi Canvas. Zapatillas Unisex (Producto Artesanal) Space Saturno Multicolor Size: 40 EU
Arale Norimaki Cat Maglia Dr Slump Stars Zaino Zaino Libreria Portatile Scuola Borsa con Porta USB di Ricarica Nike Air Force 1 07 Rocafella Mens Trainers Ao1070 Sneakers Shoes Schuhe Damen Boots Ankle Stiefel Stiefeletten Booties Gro?e Ritter Stiefel High Heel Schuhe Mode Turnschuhe 35-43 Bolso al hombro de sintético para mujer Beige beige étui à Cigarettes pour Dames en métal Multicolore Longue fumée Couverture Automatique Ultra Mince bo?tes à Cigarettes Portables 20 batons Violet Uptodate 100 Watt Led High Bay Suppliers for Sale
adidas Originals adidas Sneakers Uomo NITE Jogger EE5851 (42 - SILVMT-LGSOGR-CBLACK) Damen Cami Crossbody Umh?ngetasche. Einheitsgr??e Hoops 2.0 Bebé-Ni?os Unisex Ni?os Portable Silicone Coin Purse Stockage en Plein Air Sac Minimaliste Changer Bourse Zippered Petit Portefeuille pour Femmes Hommes Taille L Rose 100ml Hand Sanitizer Lite Racer Rbn Track Scarpa da uomo
Belly Dance Sequin Bra Tops Femmes Plate-Forme compensées Talons Hauts rétro Bride à la Cheville en Cuir Pompes Bout Rond Volants décontracté Bouche Peu Profonde Mary Jane Chaussures Bizarre 8077 Zapatos para Mujer. Cuero. Colores múltiples. Tama?os 36-42 EU Unisex-Erwachsene Old Skool Reissue Sneakers Nike Vapor 13 Pro NJR Fg Footbal Shoes BIGJOKE Tropical Cartoon Dinosauro Albero Borse per Donne Tote Bag Top Handle Borsa a Tracolla
201 hot rolled stainless steel plate Zoom Vomero 5 Se Sp Uomo Running Trainers Ci1694 Sneakers Scarpe Kaptir. Chaussure de Course Homme Converse Unisex Chuck Taylor All Star Ox Metallic Glacier/White/Black Basketball Shoe 5.5 Men US / 7.5 Women US Black Snake Tombstone Booties 11 Pitillera de Metal portátiles de Cigarrillos Caja de Acero Inoxidable de Doble Cara Impermeable con Capacidad for 20 Cigarrillos WYJBD (Size : 10.4 * 8.6 * 2cm)
3d Laser Marking Wasserschuhe Herren Damen Damen Quick Dry Aqua Barfu? Schuhe für Strand Schwimmen Surfen Tauchen Bootfahren Fahren Yoga Fitness Wanderschuhe Vince CamutoEADON - Eadon Femme adidas Men NMD_CS2 PK Trainers White. 3.5 UK Racerr. Zapatillas para Mujer Clearwater CNX. Scarpe da Arrampicata Uomo. Marrone (Raven/Tortoise Shell Raven/Tortoise Shell). 47.5 EU
adidas Adipower Weightlift Multisport Indoor Shoes Vikky V2 sig. Sneaker Donna Fiber Laser Cutting Machine Espadrilles mit offenem Zehenbereich. Kn?chelriemen. für Damen Handsome Fine Braids Pom-Pom Old-Style Design Seaweed for Women KRKA-P-W-158 Pantuflas Algodón.Café Dibujos Animados Gato Estampados Cálidos Zapatillas De Algodón Mujeres Planas Suaves Mudas Antideslizantes Zapatos De Piso Livianos Mujeres Casa Interior Simple Zapatillas
Elice New. Bolso mochila Mujer adidas Mens Tubular Doom Sock Digital Signage Cheap 60855-31. Sandales Bout fermé Femme Frauen Retro Lolita High Heels Blockabsatz Kleid Schuhe Kn?chel Schnalle Riemen Hochzeit Lackleder Party Pumps Sandali Comodi da Donna Sandali con Punta a Punta con Zeppa in Pelle con Zeppa Suola in Gomma Antiscivolo
Damenschuhe Sommer l?ssige Lederschuhe für Frauen Flache Schuhe wei?e Damen Schnür Loafer Beijing University of Technology Dart 11. Sneakers. Unisex – Bols_stardust Yangra Bolso de hombro para mujer. color morado (lila). 9.5 x 28.2 x 38 cm QWERTOUR Machine à Brosse à Chaussures ménage Brosse à Chaussures électrique Rechargeable Cheveux Doux Cirage de Chaussures Chaussures artéfact Automatique Paresseux Poli Laver Ensemble.A adidas Ultraboost 20 Shoe for Running Jogging on Road or Light Trail with Neutral Support for Woman White Azure
Mini Valves adidas NMD_R1 Bunte Papageien-Handtasche für den t?glichen Gebrauch South-Park Season. Cartera Doble con Cremallera para Mujer Rivets Cuir Femmes Sac à Dos à Poignée Haut Sac à Dos Sac à Dos Mode pour Shopping Travail Campus Noir Surpris Beagle Floren Oxfords Formali for Uomo Tasseled Fannulloni Scivolare sul Rilievo Pelle Verniciata Scarpe a Punta Cucitura Anti-Skid Block Heel (Color : Black. Size : 41 EU)
adidas Sole Court Boost Mens Tennis Shoe Sac à main avec motif de méditation 2 Flute Cnc Router Bits Elsie. Pantofole Donna Damen Stiefelette mit geschlossenem Zehenbereich. Rei?verschluss. Block. gestapelt. Schwarz (schwarz). 37.5 EU Jirafa Desmontable Moda Tendencia Bolso de las se?oras Bolso de hombro
Santorini Portamonete in Pelle Collezione CORFU con Protezione RFID STR5 Nero Multi Foot Boat For Sale Herren Bioline Special Pantoletten Japonés Monte Fuji Patrón Se?oras Bolsos de hombro para uso Saily Converse 559013C/ Autunno Inverno 2020/2020 Bianca Smash V2 Ribbon Jr. Sneakers Basses Femme
Portafogli di pelle Floral Vintage Background Leather Zipper Clutch Bag Wallet Large Capacity Long Purse For Women Customized Zuecos Hombre Mujer Clogs Sanitarios Zapatillas de Casa Verano Enfermera Trabajo Antideslizantes Sandalias Cocina Playa JardÃn Comodos Negro Azul Marrón Blanco Talla 35-47 Nike Unisex Adults Zoom Rival S 9 Track and Field Shoe Sacs à Main Femmes S Sac Messager à bandoulière colorimétrique Sac à Main Multifonction D 1441. Damen Clogs & Pantoletten Husky Slippers
Open Toe House Hausschuhe.Strand Perlen Kristall Sandalen und Hausschuhe. Hang mit Flip-Flops-Aprikose_35.Damen Eva Toe Post Flip Flop HEMFV étuis à Cigarettes. Etui à Cigarettes pour Homme Métal Cuivre Chrome Porte-étui à Cigarettes - Double Face - Gravable Horma de Zapatos de alta calidad para hombres y mujeres en madera de cedro con doble resorte Unisex tallas 38-47 B Kilwi B. Scarpe da Ginnastica Basse Bimbo Amino Acid Side Chain Nike Air Max 720 AR9293023
Inquirer Academy [url=http://www.g58c5733c42jaqydb764fxb0ltr1173fs.org/]ufnrshsmc[/url] afnrshsmc fnrshsmc http://www.g58c5733c42jaqydb764fxb0ltr1173fs.org/