These advanced Excel functions can be combined to create some very advanced and complex formulas to use. 9 learn how to find a minimum value using the MIN function. 9 learn how to find a maximum value using the.
Throughout the class we will progress from learning how to open Microsoft Excel to actually creating a spreadsheet.
Functions and formulas of ms excel 1. The MS Excel 2010 window First introduced in MS Office 2007 the ribbon makes it easy for you to find commands and features that were previously buried in complex menus and toolbars. VLOOKUP INDEX MATCH RANK AVERAGE SMALL LARGE LOOKUP ROUND COUNTIFS SUMIFS FIND DATE and many more. Get my free 3 hour Introduction to Excel 2013 course.