Topics discussed in the course include: Brief revision of basic spreadsheet skills; Conditional formatting; Data validation; What-if analysis; Printing; Grouped worksheets; Functions and complex formulas; Data consolidation; Pivot tables; Form controls in worksheets; Charts; Macros and Visual Basic; Range names in formulas; Import data; and more. Familiarity with topics covered in the introductory course is essential. Enrol in Introduction and Intermediate Excel at the same time and pay the discount fee for both courses. The course uses Excel 2021.
Topics discussed in the course include: Brief revision of basic spreadsheet skills; Conditional formatting; Data validation; What-if analysis; Printing; Grouped worksheets; Functions and complex formulas; Data consolidation; Pivot tables; Form controls in worksheets; Charts; Macros and Visual Basic; Range names in formulas; Import data; and more. Familiarity with topics covered in the introductory course is essential. Enrol in Introduction and Intermediate Excel at the same time and pay the discount fee for both courses. The course uses Excel 2021.