Excel @ Excel: Advanced Manual


Excel @ Excel: Advanced Manual 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!


  Part Number   Name
List Price
  Price
  Quantity
    Cart
  ExAdvance   Excel @ Excel: Advanced Manual 
  $ 22.00
  $ 22.00