Learn macros and magic of Data Validation and advance functions using Excel. This extensive, full-color, and comprehensive manual and course teaches you how to create and edit Macros for shortcuts and repeated actions. You'll create functions based on criteria with SUMIFS, AVERAGEIFS, and COUNTIFS and compare and populate worksheets using VLOOKUP/HLOOKUP. You'll learn how have worksheets protected so users may only change certain areas or cells and to encrypt your workbook with a password. Get ready to go to the next level of learning and earn your geek hat.
After this course, you'll be able to:
- Create and edit macros,
- Use VLOOKUP/HLOOKUP, SUMIFS, AVERAGEIFS, and COUNTIFS,
- Protect your worksheets and workbooks in many ways,
- Use rules to restrict the type of information in cells and give error and information message based on the contents of a cell,
- And Much More!