Embedded Files
Contact Us!
Microsoft Excel is a versatile and indispensable tool which plays a pivotal role in streamlining operations, managing finances, making data-driven decisions, and achieving overall business success.
APPLICATIONS OF MS EXCEL
Collection and Verification of Business Data
Business Analysis
Performance Reporting
Strategic Analysis
Accounting and Budgeting
Program Deliverables
Live interactive Training
Practice Files
Recording of the session
E-Certificate
Key Advantage
- Data Management - Data Visualization -Efficiency and Productivity - Financial Management -Project Management - Versatility
What will you Learn?
Pivot tables
What is it?
Why use it?
Various layouts: compact, tabular & outline
Field List What you will learn
Various Options
GETPIVOTDATA function
Value Field Settings Filters/Rows/Columns/Values
Various calculations and ways to show them
Slicers
Timelines
Deferring layout
Styles
Subtotals
Calculated fields
Calculated items
Dynamic Arrays
Referencing (Implicit vs Dynamic)
SEQUENCE
FILTER
SORT Dynamic Arrays
SORTBY
UNIQUE
RANDARRAY
#SPILL errors
VSTACK, HSTACK
TAKE, DROP
CHOOSEROWS, CHOOSECOLS
TOCOL, TOROW
Charting Technique
-Bar, Column, Line, Area, XY-scatter, Pie -Bar of Pie; Pie of pie -Combo Charts -Chart Styles
-Chart elements (Labels, Gridlines, Axes, Data labels, Data table, Legends, Trendlines -Various Formatting
International Trainer
International Trainer
BOB UMLAS
BOB UMLAS
(25 Years Microsoft Excel MVP)
Bob Umlas worked for a major tax and accounting firm, using Microsoft Excel® 8 hours a day, wring custom applications for staff and clients from 1998 to 2018.
He has been using Excel since 1986 - 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 technique from him on using Excel.
He has had more than 300 article 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 1994-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 has led 5 sessions at an Excel User Conference in Atlantic City on Tips & Tricks, Array formulas, VBA, Formulas, and Userforms. He has led at about 7-8 of these user conferences since 2005. He is also the author of “This isn’t Excel, it’s Magic!” Another book, “Excel Outside the Box” is for the very advanced Excel user. Another book, “More Excel Outside the Box”. One more, “Cool Excel Sh*t” is more tips & tricks. Lastly, published 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 books for Excel 2019, as well as about 12 books for prior versions of Excel and 4 books for Office 365’s Excel.
Books Written by Bob Umlas
Course Fee
Mode of Payment - Online Fund Transfer
Mode of Payment - Online Fund Transfer
Account Title: EdSkills International
Bank: Alfalah Limited
Account#: 00661006645281
IBAN: PK37ALFH00661006645281
Swift code: ALFHPKKA
City & Country: Lahore, Pakistan
Whatsapp Us For More Details
Page updated
Google Sites
Report abuse