Training being taught by Zoom online training system. Many times people waste more hours in Microsoft Excel doing things manually. By using the Formulas and Functions features you can decrease the amount of time spent entering and editing data in your spreadsheets as well as increase accuracy of your data. Example: Using the PROPER function you can change all capital or lower case text to proper case. Using Conditional Formatting you can hide repeating values in a spreadsheet listing so they only appear once. In this session you will learn how to: 1.) Use formulas with multiple operators, 2.) Capitalize First letter, 3.) Remove Titles, 4.) Use the IF,PMT, DSUM, VLOOKUP and HLOOKUP functions, 5.) Use dates as formulas.
For more information:
Register at: http://www.heccma.org/employees/professional-development/technical-trainings/