Free Full course on Formulas and Functions for Excel interview test prep This free course comprises of selected lessons and sections of lessons from our top selling Excel Beginner to Advanced Certificate Course and Excel for Accounting & Finance Certificate Course. Our Excel Beginner to Advanced Certificate Course and Excel for Accounting & Finance Certificate Course are both CPD certified courses and are available to purchase on our site. You will get the following benefits by buying the original course. • A globally recognized CPD accredited certificate • Free access to our innovative Excel learning app that allows you to take the course inside your Excel application itself. • Lecture files and practice files. • Quizzes to reinforce learning. • Access to support from our instructors. • Lifetime access and lesson updates for latest functions and features as they are rolled out by Microsoft. Check out our top selling CPD certified Excel Courses and get discounts up to 88-90% by using the links below: Course link for Excel Beginner to Advanced Certificate Course: Course link for Excel for Accounting & Finance Certificate Course: Timestamps: 00:00:00 Introduction to Excel Formulas and Functions Training Course 00:00:14 About our CPD Certified Excel Certificate Courses 00:00:52 About our Excel Training App 00:03:22 Start of Course 00:03:28 Excel Basics (Section 1) 00:03:30 Introduction to formulas 00:08:13 Understanding the order of operations 00:13:33 Introduction to Excel Functions 00:21:51 Excel’s Key Functions (Section 2) 00:21:53 SUM Function and AutoSum 00:28:26 AVERAGE Function 00:33:29 COUNT Function and related functions 00:37:37 MIN and MAX Functions 00:39:28 LARGE and SMALL Functions 00:42:32 RANK Function and New RANK Functions 00:50:43 AGGREGATE Function 00:58:27 ROUND Function 01:03:11 INDEX Function 01:12:11 MATCH Function 01:18:21 XMATCH Function 01:33:09 INDEX & MATCH combination 01:39:19 PRODUCT & SUMPRODUCT Functions 01:46:11 IF Function 02:04:18 IFS Function 02:10:17 CHOOSE Function 02:14:44 SUMIF, AVERAGEIF and COUNTIF Functions 02:45:27 SUMIFS, AVERAGEIFS, COUNTIFS, MINIFS and MAXIFS Functions 03:14:59 Database Functions 03:39:11 Text Functions 04:22:00 Date Functions 05:09:12 VLOOKUP and HLOOKUP Functions 05:38:43 XLOOKUP Function 05:59:55 Error types and Error Functions 06:19:13 GETPIVOTDATA Function 06:34:32 Financial Functions (Section 2) 06:34:35 PV, FV, PMT, PPMT, IPMT, CUMPRINC, CUMIPMT, RATE, and NPER functions 07:10:29 NPV Function 07:17:42 XNPV Function 07:23:05 IRR Function 07:31:59 XIRR Function 07:34:40 MIRR Function 07:38:39 Payback period 07:55:30 Depreciation Functions 08:03:27 Dynamic Array Functions (Section 3) 08:03:29 Introduction to Dynamic Array Functions 08:19:38 SORT Function 08:32:35 SORTBY Function 08:45:33 FILTER Function 09:04:34 UNIQUE Function 09:30:09 SEQUENCE Function 09:54:54 RANDARRAY Function Social Media/Site: Facebook: Instagram: Website: #Excel,#Microsoft,#Microsoft Excel,#Data analysis,#Excel Courses,#Dynamic Array Functions,#ExcelTutorial,#ExcelTips,#Excel365,#CPD Certified