2020 - 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

Topic :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
Register :https://www.ijonaskills.us/webinarDetails?webinari...
Discount Coupon : Use this Coupon (NEW2COMPLIANCE) and get (10% Off) On New Signup
Overview:
This training session covers THREE 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 are considered the top 10 functions.
Areas Covered in the Session :
Learn many statistical functions including SUM, AVERAGE, MAX, MIN and COUNT
Use IF and its counterparts COUNTIF, SUMIF, and AVERAGEIF
Calculate dates using TODAY, NOW
Learn many functions to manipulate text once imported including LEFT, RIGHT, TRIM and CONCANTENATE
Learn the arguments in the VLOOKUP function
Understand the importance of absolute references within many lookup functions
Use VLOOKUP to perform approximate matches
Simplify multiple-field look-ups with concatenation (combining fields into a single cell)
Use VLOOKUP to look up data from another workbook
Learn how VLOOKUP stops looking after it finds an initial match within a list
Explore why VLOOKUP sometimes returns #N/A instead of a desired result
Learn about the IFNA function available in Excel 2013 and later
See how the HLOOKUP function enables you to perform horizontal matches
Learn why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP
Use the MATCH function to find the position of an item on a list
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
Speaker Profile :
Cathy Horwitz is Keynote Speaker at Ijona Skills. She is believes that when your employees know the capabilities of the software they use, they will demonstrate improved productivity, will be more efficient and will be able to problem solve more easily.
Contact Info :
Ijona Skills
https://www.ijonaskills.us
Email : support-AT-ijonaskills.us
Phone : +1 302-830-3132