6-Hour Virtual Seminar on Excel Automation Boot Camp - Top Ten Excel Functions, LOOKUP, MATCH and INDEX Functions and Basics of Excel Macros with an Introduction to VBA

Topic :6-Hour Virtual Seminar on Excel Automation Boot Camp - Top Ten Excel Functions, LOOKUP, MATCH and INDEX Functions and Basics of Excel Macros with an Introduction to VBA

Register :https://www.ijonaskills.us/webinarDetails?webinarid=728&speakerid=204&domain=4&source=EG_RD

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.

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, NETWORKDAYS
• Learn many functions to manipulate text once imported including LEFT, RIGHT, LEN, TRIM , UPPER, LOWER, PROPER 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
• 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
• Use the IFERROR function to display something other than an #N/A error value when VLOOKUP can't find a match
• 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
• Create a workbook macro
• Create a personal macro
• Use the macro recorder to create a personal macro
• Find and use the PERSONAL.XLSB file
• Use the macro recorder to create a workbook macro
• Save a file as a macro enabled excel workbook
• Run a macro
• View the recorded macro in VBA
• Edit the macro using VBA
• View the recorded macro in VBA
• Edit the macro

Speaker:

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 :
Ijonskills
https://www.ijonaskills.us
Email : [email protected]
Phone :   +1 302-830-3132