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…
Tag: Excel
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…
Using the IF function
IF functions allow you to make logical comparisons between a value and what you expect
Flash Fill in Excel 365
Flash Fill adds a level of intelligence in recognising a pattern and completing it based upon nearby data
