2019 - 3-Hour Excel Automation Boot Camp: Top Ten Excel Functions Lookup Functions (VLOOKUP HLOOKUP MATCH INDEX) Basics of Excel Macros with an Introduction to VBA

OVERVIEW
This training session covers 3 intermediate to advanced features of Excel that provide automation within the application. Formulas are equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and more. Explore what is considered the top 10 functions. Lookup functions are far superior to manually searching for specific data elements in a spreadsheet.
WHY SHOULD YOU ATTEND
Excel functions can greatly enhance your ability to perform tasks in day to day activities in Excel. While there are hundreds of functions available, there are 10 functions that all Excel users should know. Whether you are an office worker, or a small business owner using Excel to keep track of your finances or just the casual user, these Excel functions can be very important time savers, and enhance your ability to create better-performing spreadsheets.
AREAS COVERED
arguments in the VLOOKUP function
Learn the difference between workbook macros and personal macros
Making your macros available to all your workbooks
Use the macro recorder to create a macro
Save a file as a macro-enabled Excel workbook
Run a macro
View the recorded macro in VBA
Edit the macro
WHO WILL BENEFIT?
Business owners
CEO's/CFO's/CTO's
Managers
Accountants
CPA's
Financial consultants
IT professionals
Auditors
Human Resource personnel
Bookkeepers
Marketers
SPEAKER
Cathy Horwitz is an independent consultant specializing in Microsoft Office instruction. Cathy has over 30 years of experience as a Microsoft Office instructor. She is proficient in all levels of Excel, Word, PowerPoint, Outlook, and Access. She holds a degree in Psychology and a Master in Business Administration degree with an emphasis in Human Resources.
For more detail please click on this below link:
http://bit.ly/2YvGgYV
Email: support-AT-247compliance.com
Tel: +1-(510)-868-1040