Microsoft Excel Training - Level 3 Advanced Course, Aberystwyth

Course Content:- Review of Intermediate Topics Recap on topics covered in Intermediate level. Subtotals Create single and multiple Subtotals. Conditional Formatting Use conditional formatting to compare data ranges Use functions within conditional formatting Format entire rows of data rather than single cells. IF revisited Using AND and OR functions The IFS function Database Functions DSUM, DAVERAGE, DMAX, DMIN, DCOUNT Using Criteria Range with AND/OR conditions. Text Functions Joining Strings (CONCAT, TEXTJOIN, &) String Manipulation (LEFT, RIGHT, MID, PROPER, UPPER, LOWER, CLEAN, TRIM) Extr…