HomeCoursesExcelMicrosoft Excel Intermediate Functions and Formulas 6 Function syntax Absolute cell referencing Common statistical functions The SUMIF function The IF Function The COUNTIF function Working with date and time 4 Date functions – TODAY and NOW EDATE and NETWORKDAYS Work with time values AutoFill date sequences Conditional formatting 4 Format cell value Format using a formula Editing conditional formatting rules Adding sparklines Advanced sorting and filtering 7 Sorting by colour Sorting custom lists Searching for criteria Complex filtering criteria SUBTOTAL function Subtotalling a list Creating a simple PivotTable Advanced charts 8 Creating a chart sheet Switch columns/rows Create a dual axis chart Changing a series chart type Moving a chart 3D charts 3D chart rotation Create a simple, static dashboard Microsoft Excel Intermediate Back to Course SUBTOTAL function Lesson content is empty. Prev Complex filtering criteria Next Subtotalling a list Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment Name * Email * Website Save my name, email, and website in this browser for the next time I comment.