Excel – An Introduction (FULL COURSE)
containing: Differences between a Workbook and a Worksheet, Identifying cells and the Active Cell, How large is a worksheet?, Entering data, Selecting…
Category: Excel
How to Cleanse Raw Data (FULL COURSE)
containing: Data cleansing functions, Text substitution functions, Using Flash Fill, Extracting the correct text, De-duplication techniques, Using Tex…
Introduction to XLOOKUP (FULL COURSE)
containing: Using XLOOKUP instead of VLOOKUP or HLOOKUP, Using a nested XLOOKUP, Limitations of VLOOKUP and HLOOKUP, Using XLOOKUP instead of INDEX an…
Conditional Formatting (FULL COURSE)
containing: What is Conditional Formatting?, Demonstrating preset highlighting rules, Creating a Conditional Formatting rule using a formula, Clearing…
Introduction to Creating Charts (FULL COURSE)
containing: Using a recommended chart, Modifying your chart design, Formatting chart elements, Selecting a specific chart type, Using keyboard shortcu…
Introduction to Data Validation techniques (FULL COURSE)
containing: Demonstrating Data Validation controls, Understanding the Data Validation dialog box, Modifying existing Data Validation controls, Creatin…
Introduction to Logical Functions (FULL COURSE)
containing: How to construct a basic IF function, Understanding relational operators, Using SUMIF and COUNTIF functions, Boolean logic with AND and OR…
Introduction to Formulae & Functions (FULL COURSE)
containing: How to construct a basic formula, Using Autofill, Understanding BODMAS, Absolute cell references, Creating a formula with a function, Math…