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=RFM_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 : support@ijonaskills.us
Phone : +1 302-830-3132