Introduction
Master the latest Excel functions, dynamic array formulas, VBA macros, and advanced data analysis tools to transform the way you work with data. Gain hands-on expertise in automating tasks, building powerful reports, and creating insights for faster decision-making.
Who Should Attend
- Accounting & Finance Professionals
- Financials and Costing Auditors
- Business & Accounting Students
- MIS Reporting Executives.
- Supply chain professionals
- Human Resource Professionals
- Sales & Marketing Professionals.
- Any manager that has responsibility for working with data and numbers
- Business managers and team lead responsible for reporting and analysis.
- Project managers and planners.
Learning Outcomes
- New Excel Functions
- Dynamic Array Functions
- Macros VBA
- Recording Macros
- Editing Macros
- VBE (Visual Basic Environment)
- Advanced Pivot Tables
- Pivot Charts
- X-Match, Index Double Match
- Advance Tips & Tricks
Program Schedule
- May 18 to 20, 2026
- From 8:00pm to 10:00pm (Pakistan Time)
- Live Interactive training on Zoom
Investment:
- PKR 25,000/- Net of all taxes
Registration:
Send your full name, email ID, organization and city at info@lexicon.edu.pk | +92 328 8875000| +92 320 88750
About the Trainer Mr. Bob Umals from USA
Bob Umlas worked for a major tax and accounting firm KPMG, using Microsoft Excel® 8 hours a day, writing custom applications for staff and clients for 20 years
He has been using Excel since version 0.99 (on the Macintosh)! He was a contributing editor to Inside Microsoft Excel for many years, a magazine devoted exclusively to Microsoft Excel and published by The Cobb Group and later Ziff-Davis. At the time, most issues contain either an article by Mr. Umlas on using VBA (Visual Basic for Applications) or some tip or technique from him on using Excel. He has had more than 300 articles published on subjects ranging from beginner to advanced macros, and on tips, shortcuts, and general techniques using virtually all aspects of Excel.
Mr. Umlas was voted an “MVP” (Most Valuable Professional) by Microsoft each year from 1993-2018 (25 years!) for his contributions to the various online Forums about Excel and is known world-wide for his contributions in Excel. As an MVP, he met yearly with his fellow-MVPs at Microsoft’s headquarters in Redmond, where he had access to the product developers. He has been a beta tester for new versions of Excel since version 1.5, and was asked by Microsoft for his input for newer versions of Excel. In 1995 he led a session called “Maximizing Excel Development Using Array Formulas” at Microsoft’s Tech Ed Conference in New Orleans, and he led a session called Tips and Tricks at a Microsoft convention in New York City. He has also led two Excel sessions (Array Formulas, Tips & Tricks) at the Advisor’s Developer Conference in San Francisco in February 1998.
He is also the author of “This isn’t Excel, it’s Magic!” which is available from Amazon.com. Another book, “Excel Outside the Box” and is for the very advanced Excel user. Lastly, published October 17 for Kindle, is “Excel Preschool: Finally Understanding what Excel is all About” – a book for the very beginner!
He has co-authored several chapters in many books on Excel and has done the technical editing for 4 new books for Excel 2019, as well as about 12 books for prior versions of Excel.
#AdvancedExcelCourse #AdvancedExcelTraining #ExcelCertification #MicrosoftExcelAdvanced #ExcelForProfessionals #ExcelExpertTraining #AdvancedExcelOnlineCourse #ExcelDataAnalysis #ExcelAutomation #ExcelSkills #LearnExcelOnline #ExcelCoursePakistan #ExcelTrainingPakistan #ExcelIslamabad #ExcelLahore #ExcelKarachi #BestExcelCourse #ExcelForFinance #ExcelForAccountants #ExcelDashboards #ExcelFormulas #ExcelVBA #ExcelMacros #PowerQuery #PowerPivot #FinancialModeling #DataAnalysisSkills #CorporateTraining #ProfessionalDevelopment #LEXICON #BobUmlas #ExcelExpert #CareerGrowth #JobReadySkills #DataAnalytics #BusinessIntelligence #ExcelReporting #ExcelTips #OfficeSkills