~Get Your Files Here !/1. Week 1 Excel basics for beginners/1. Day 1 INTRODUCTION to Microsoft Excel.mp432.12MB
~Get Your Files Here !/1. Week 1 Excel basics for beginners/2. Day 2 the RIBBON - Exploring what it is and what is on it.mp450.63MB
~Get Your Files Here !/1. Week 1 Excel basics for beginners/3. Day 3 UNDO and REDO - learn the basics.mp411.34MB
~Get Your Files Here !/1. Week 1 Excel basics for beginners/4. Day 4 COPY and PASTE - the basics of using the clipboard in Mircosoft excel.mp445.79MB
~Get Your Files Here !/1. Week 1 Excel basics for beginners/5. Day 5 FIND and REPLACE.mp422.19MB
~Get Your Files Here !/1. Week 1 Excel basics for beginners/6. Day 6 KEYBOARD NAVIGATION - work in excel using just your keyboard.mp451.39MB
~Get Your Files Here !/1. Week 1 Excel basics for beginners/7. Day 7 KEYBOARD SHORTCUTS - some of my most used shortcuts.mp484.64MB
~Get Your Files Here !/2. Week 2 - Basic formatting options in excel/1. Day 1 RESIZING rows and columns - viewing your data in excel.mp444.72MB
~Get Your Files Here !/2. Week 2 - Basic formatting options in excel/2. Day 2 FONT FORMATTING - learn the basics with our FREE tutorial.mp426.87MB
~Get Your Files Here !/2. Week 2 - Basic formatting options in excel/3. Day 3 NUMBER FORMATTING - learn the basics with our FREE tutorial.mp445.04MB
~Get Your Files Here !/2. Week 2 - Basic formatting options in excel/4. Day 4 CELL ALIGNMENT - learn the basics with our FREE excel tutorial.mp446.89MB
~Get Your Files Here !/2. Week 2 - Basic formatting options in excel/5. Day 5 FORMATTING from the home tab - preset options.mp421.91MB
~Get Your Files Here !/2. Week 2 - Basic formatting options in excel/6. Day 6 Cell FORMATTING Learn how to add borders, colours and patterns.mp426.67MB
~Get Your Files Here !/2. Week 2 - Basic formatting options in excel/7. Day 7 SORTING and FORMATTING - the basics.mp442.09MB
~Get Your Files Here !/3. Week 3 - Inputting, viewing and managing data/1. DAY 1 PRINTING EXCEL - using WORKBOOK VIEWS to setup your print!.mp437.7MB
~Get Your Files Here !/3. Week 3 - Inputting, viewing and managing data/2. DAY 2 WORKSHEETS options and working with several Excel Tabs.mp460.67MB
~Get Your Files Here !/3. Week 3 - Inputting, viewing and managing data/3. DAY 3 EXCEL BASICS - AUTOFILL and inputting data.mp417.03MB
~Get Your Files Here !/3. Week 3 - Inputting, viewing and managing data/4. DAY 4 FLASH FILL - learn how to use it!.mp441.75MB
~Get Your Files Here !/3. Week 3 - Inputting, viewing and managing data/5. DAY 5 EXCEL DROP DOWN LIST - tutorial for beginners.mp431.73MB
~Get Your Files Here !/3. Week 3 - Inputting, viewing and managing data/6. DAY 6 TRANSPOSE - find out how with this free excel tutorial.mp426.69MB
~Get Your Files Here !/3. Week 3 - Inputting, viewing and managing data/7. DAY 7 IMPORT data from the web - learn how with this excel tutorial.mp430.78MB
~Get Your Files Here !/3. Week 3 - Inputting, viewing and managing data/8. DAY 8 Naming data in excel and how to use in formulas and lists (named ranges).mp4174.16MB
~Get Your Files Here !/4. Week 4 - Introduction to functions and formulas/1. Day 1 FORMULAS and OPERATORS Learn the basics of Excel formulas and functions.mp449.31MB
~Get Your Files Here !/4. Week 4 - Introduction to functions and formulas/2. Day 2 SUM and SUMIF formulas - the basics of adding in Microsoft Excel.mp434.81MB
~Get Your Files Here !/4. Week 4 - Introduction to functions and formulas/3. Day 3 FORMULAS - Understanding basic division in Excel.mp413.86MB
~Get Your Files Here !/4. Week 4 - Introduction to functions and formulas/4. Day 4 ABSOLUTE and RELATIVE cell references.mp436.36MB
~Get Your Files Here !/4. Week 4 - Introduction to functions and formulas/5. Day 5 ABSOLUTE CELL REFERENCE learn the shortcut!.mp424.9MB
~Get Your Files Here !/4. Week 4 - Introduction to functions and formulas/6. Day 6 FUNCTIONS - SUM, AVERAGE, COUNT and COUNTA.mp452.37MB
~Get Your Files Here !/4. Week 4 - Introduction to functions and formulas/7. Day 7 ERROR checking and calculating FORMULAS.mp457.28MB
~Get Your Files Here !/5. Week 5 - Commonly used FUNCTIONS in Excel (IF, IFERROR, VLOOKUP, AND, OR & NOT)/1. Day 1 IF function - learn how to use it with our introduction tutorial.mp424.4MB
~Get Your Files Here !/5. Week 5 - Commonly used FUNCTIONS in Excel (IF, IFERROR, VLOOKUP, AND, OR & NOT)/2. Day 2 IFERROR function - learn the basics with our excel tutorial.mp416.02MB
~Get Your Files Here !/5. Week 5 - Commonly used FUNCTIONS in Excel (IF, IFERROR, VLOOKUP, AND, OR & NOT)/3. Day 3 VLOOKUP tutorial everything you need to know about VLOOKUP in Ms Excel.mp420.7MB
~Get Your Files Here !/5. Week 5 - Commonly used FUNCTIONS in Excel (IF, IFERROR, VLOOKUP, AND, OR & NOT)/4. Day 3 VLOOKUP tutorial learn to VLOOKUP with approximate values.mp422.09MB
~Get Your Files Here !/5. Week 5 - Commonly used FUNCTIONS in Excel (IF, IFERROR, VLOOKUP, AND, OR & NOT)/5. Day 4 AND function - learn how to use it with our beginners tutorial!.mp410.47MB
~Get Your Files Here !/5. Week 5 - Commonly used FUNCTIONS in Excel (IF, IFERROR, VLOOKUP, AND, OR & NOT)/6. Day 5 OR function - learn how to use it with our beginners tutorial!.mp411.3MB
~Get Your Files Here !/5. Week 5 - Commonly used FUNCTIONS in Excel (IF, IFERROR, VLOOKUP, AND, OR & NOT)/7. Day 6 NOT function - learn how to use it with our beginners tutorial.mp47.09MB
~Get Your Files Here !/5. Week 5 - Commonly used FUNCTIONS in Excel (IF, IFERROR, VLOOKUP, AND, OR & NOT)/8. Day 7 What is XLOOKUP and why is it a good alternative to VLOOKUP.mp4116.69MB
~Get Your Files Here !/5. Week 5 - Commonly used FUNCTIONS in Excel (IF, IFERROR, VLOOKUP, AND, OR & NOT)/9. Day 7 XLOOKUP & Named Ranges use them together to read functions easily.mp450.01MB
~Get Your Files Here !/6. Week 6 - More FUNCTIONS in Excel/1. Day 1 TRIM function - Introduction.mp419.66MB
~Get Your Files Here !/6. Week 6 - More FUNCTIONS in Excel/2. Day 2 SUBTOTAL function - ExpliningExplination !.mp464.27MB
~Get Your Files Here !/6. Week 6 - More FUNCTIONS in Excel/3. Day 3 ROUND, ROUNDDOWN and ROUNDUP functions - how to use them.mp429.99MB
~Get Your Files Here !/6. Week 6 - More FUNCTIONS in Excel/4. Day 4 MAX and MIN functions - learn how to find largest and smallest values.mp411.8MB
~Get Your Files Here !/6. Week 6 - More FUNCTIONS in Excel/5. Day 5 TEXT function - Explanations !.mp425.49MB
~Get Your Files Here !/6. Week 6 - More FUNCTIONS in Excel/6. Day 6 LARGE and SMALL functions - how to find find and sort values by position.mp430.64MB
~Get Your Files Here !/6. Week 6 - More FUNCTIONS in Excel/7. Day 7 TODAY and NOW functions - how to use them with conditional formatting.mp426.92MB
~Get Your Files Here !/7. Week 7 - Managing data with functions and sorting data 9/1. Day 1 UPPER, LOWER and PROPER functions (Changing sentence case in Excel ).mp421.98MB
~Get Your Files Here !/7. Week 7 - Managing data with functions and sorting data 9/2. Day 2 Extracting text using LEFT, RIGHT and MID in Excel.mp427.96MB
~Get Your Files Here !/7. Week 7 - Managing data with functions and sorting data 9/3. Day 3 Basics of the FIND and SEARCH functions in Excel.mp414.6MB
~Get Your Files Here !/7. Week 7 - Managing data with functions and sorting data 9/4. Day 4 Combining the FIND and MID functions in Excel.mp415.63MB
~Get Your Files Here !/7. Week 7 - Managing data with functions and sorting data 9/5. Day 5 How to create a CUSTOM SORT LIST in Excel.mp423.75MB
~Get Your Files Here !/7. Week 7 - Managing data with functions and sorting data 9/6. Day 6 SUMIF and How to fix issue with DATA SORTING..mp437.35MB
~Get Your Files Here !/7. Week 7 - Managing data with functions and sorting data 9/7. Day 7 using the RANK function in Excel.mp421.37MB
~Get Your Files Here !/7. Week 7 - Managing data with functions and sorting data 9/8. Day 8 Advanced drop down lists with dynamic array formulas UNIQUE & FILTER.mp434.18MB
~Get Your Files Here !/7. Week 7 - Managing data with functions and sorting data 9/9. Day 9 Dynamic array functions - FILTER function, the basics (Advanced filter).mp443.44MB