This course is designed for those that are completely new to Excel or would like to brush up on their skills. We\'ll be using v2019 and v365 and will cover some of the exciting new and upcoming Excel features and functions, including Dynamic Arrays and XLOOKUP (some of which requires v365). The course has been designed with efficiency as a prime driver so we\'ll be talking a fair bit about keyboard shortcuts, what to do and what not to do as well as some theory on data storage, data types, etc so that you get an understanding of why certain things are the way they are rather than \"just do\". There are about 65 lectures and 3 of those are technical, the other 62 are not techy at all so no need to worry. The 3 techy lectures will help you understand the bigger picture.In terms of style/delivery: UK English, bit of added sarcasm (very minimal), generally cool and avoiding buzz. Also I tend to use \"you\" (\"if you have a look at this/do that\") rather us (\"let us do this/that\") in most cases. It\'s just to say some people prefer one or the other so you know what to expect. Furthermore I don\'t use \"I\'m going to go ahead and...\". Just saying. :)Course structure:1. Using the Application1.1: Spreadsheet BasicsOpening & Closing Excel & SpreadsheetsIntroducing Excels InterfaceCreating New SpreadsheetsSaving Locally / OnlineSaving As (Different File Format) & Discussing File FormatsDissecting an XLSX File (Techy but Useful)1.2: Productivity BasicsOverview of Basic OptionsProtected ViewUsing HelpMagnification/Zoom ToolsWorking with the RibbonNavigation Best Practices: Using Shortcuts & Go to Tool2. Working with Cells, Formulae, Functions2.1: Inserting & Selecting DataBest Practices: One Cell, One Data Type OnlyWorking with Text/Numbers/Date Data Entry MethodsBest Practices: Understanding Regions, Avoiding BlanksSelecting Cells, Adjacent and Non-Adjacent Ranges, Worksheet2.2: Understanding FormulaeBest Practices: Cell References vs. Hard-CodingRelative & Absolute Cell ReferencingBasic Arithmetic Operations (+-*/^)Dissecting Formulae (Techy but Useful)Dynamic Arrays [365 or Newer, not in 2019]Understanding Basic Errors2.3: Basic FunctionsWorking with the SUM, AVERAGE, MIN, MAX FunctionsWorking with the COUNT, COUNTA, COUNTBLANK FunctionsIntroduction to the IF Function ++ Understanding Logical OperatorsIF-enabled Functions (SUMIF/S, AVERAGEIF/S, MINIFS, MAXIFS, COUNTIF/S)2.4: Finding & Changing DataSearch -- BasicsReplace -- BasicsSorting Cells (1 Criterion, Asc/Desc Order, Text, Numbers, Dates)Undo & Redo ++ Caveats2.5: Filling, Copying, Moving (Cutting), Deleting(Auto) Incrementing Value AutoFill ToolAutomate Data Fill in Other Columns Flash FillCopying Contents Within and Between Worksheet(s)Moving (Cutting) Within and Between Worksheet(s)Clearing Cell ContentsDeleting, Inserting Cells3. Worksheets Basics3.1: Rows & ColumnsSelecting Rows/Cols, Adjacent & Non-Adjacent RangesDelete, Insert Rows and Columns.Modifying Width, Height, Manual & AutoFreezing 1st Row, 1st Column, Unfreezing3.2: Worksheets In-DepthToggling, Inserting, Deleting WorksheetsBest Practices: (Re)naming Worksheets ++ CaveatsDuplicating, Moving Sheets Within & Across Workbooks4. Cell Formatting4.1: Formatting Dates & NumbersUnderstanding the Basic Locale Concept (Techy-ish)Specifying # of Decimals, Using the 000 Separator, %sROUND, ROUNDUP, ROUNDDOWN FunctionsFurther Numbers and Currency Format StylesBasic and Advanced Date Format Styles4.2: Formatting ContentsChanging Font Type & SizeChanging Appearances: Bold, Italic, Underline, Double Underline.Colouring Text & Cell Fill (Background)Introducing Paste Special (Formats only)Cell Borders4.3: Alignment, MergingChanging Horizontal/Vertical AlignmentText Wrapping How and Why?Merging & Unmerging ++ Caveats5. Charts (Basics)5.1: Creating ChartsUnderstanding (& Creating) Certain Chart Types: Column, Bar, Line, Pie, Treemap ChartSelecting, Moving, Resizing, Deleting ChartsChanging the Chart Type.Brief Introduction to Other Chart Types5.2: Working with Chart ElementsIntroducing & Explaining Chart ElementsAdding/Removing Chart Elements (Title, Legend, Axis)Changing the Formatting of Chart Elements6. Finding Data6.1: Lookup FunctionsTheory of KeysLookup Functions: HLOOKUP/VLOOKUPLookup Functions: INDEX & MATCHLookup Functions: XLOOKUP/XMATCH+1: Excel Capabilities DemoDemoing Advanced Excel functionality