ijonaskills
May 29, 2020 - DE USijona skills
support@ijonaskills.us
Phone:3028303132
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=MDO_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