~Get Your Files Here !/1. Introduction/1. Introduction.mp444.63MB
~Get Your Files Here !/2. Microsoft Excel Basics/1. How to make the most of this course (subtitles, speed up videos).mp424.21MB
~Get Your Files Here !/2. Microsoft Excel Basics/2. Navigating around Microsoft Excel.mp449.74MB
~Get Your Files Here !/2. Microsoft Excel Basics/3. Entering text and numbers into Excel.mp443.86MB
~Get Your Files Here !/2. Microsoft Excel Basics/4. Adding numbers using the SUM function.mp456.57MB
~Get Your Files Here !/2. Microsoft Excel Basics/5. Subtract, multiply, and divide in Excel.mp454.32MB
~Get Your Files Here !/2. Microsoft Excel Basics/6. Correcting cells and moving around cells.mp432.83MB
~Get Your Files Here !/2. Microsoft Excel Basics/7. Inserting columns and rows in Excel.mp415.64MB
~Get Your Files Here !/2. Microsoft Excel Basics/8. Conditional Formatting to add colors to data.mp467.1MB
~Get Your Files Here !/2. Microsoft Excel Basics/9. Clear Formats and Clear Content in cells.mp434.88MB
~Get Your Files Here !/3. Formatting cells, Format Painter, Wrap Text/1. Formatting cells in Microsoft Excel (Bold, borders, highlight, merge & center).mp456.08MB
~Get Your Files Here !/3. Formatting cells, Format Painter, Wrap Text/2. Using Copy, Cut, Paste, and Format Painter to copy cell format.mp439.57MB
~Get Your Files Here !/3. Formatting cells, Format Painter, Wrap Text/3. Paste Values using Paste Special.mp463.62MB
~Get Your Files Here !/3. Formatting cells, Format Painter, Wrap Text/4. Using Wrap Text to wrap spill over text in a cell.mp426.26MB
~Get Your Files Here !/3. Formatting cells, Format Painter, Wrap Text/5. Formatting numbers using dollar sign, percentage, decimal points.mp454.14MB
~Get Your Files Here !/4. Excel Shortcuts, MeanMedianMode, Split Screen, Grouping Data/2. Excel shortcuts - Home tab, delete column, insert row, zoom.mp459.35MB
~Get Your Files Here !/4. Excel Shortcuts, MeanMedianMode, Split Screen, Grouping Data/3. Excel shortcuts - Tab, move to last cell, move to next worksheet, move down.mp435.04MB
~Get Your Files Here !/4. Excel Shortcuts, MeanMedianMode, Split Screen, Grouping Data/4. Mean, median, mode, count cells.mp423.42MB
~Get Your Files Here !/4. Excel Shortcuts, MeanMedianMode, Split Screen, Grouping Data/5. Split screen to work on different parts of the same Excel sheet simultaneously.mp439.91MB
~Get Your Files Here !/4. Excel Shortcuts, MeanMedianMode, Split Screen, Grouping Data/6. Grouping data (expand and collapse data).mp463.05MB
~Get Your Files Here !/5. Charts, Sort & Filter, Freeze Panes View, Print Preview Options/1. Using Charts (pie charts, column charts).mp440.87MB
~Get Your Files Here !/5. Charts, Sort & Filter, Freeze Panes View, Print Preview Options/2. Sort and Filters in Excel.mp462.99MB
~Get Your Files Here !/5. Charts, Sort & Filter, Freeze Panes View, Print Preview Options/3. Using Freeze Panes in Excel to see column headings and row headings.mp445.06MB
~Get Your Files Here !/5. Charts, Sort & Filter, Freeze Panes View, Print Preview Options/4. Absolute Reference to prevent cell reference from moving.mp456.68MB
~Get Your Files Here !/5. Charts, Sort & Filter, Freeze Panes View, Print Preview Options/5. Print Preview options.mp481.16MB
~Get Your Files Here !/6. Useful functions Sumif, VLookup, HLookup, If, Remove Duplicates/1. Using Sumif function to add cells based on criteria you set.mp482.62MB
~Get Your Files Here !/6. Useful functions Sumif, VLookup, HLookup, If, Remove Duplicates/2. Using VLookup function to find data quickly.mp483.8MB
~Get Your Files Here !/6. Useful functions Sumif, VLookup, HLookup, If, Remove Duplicates/3. Using HLookup function to find data quickly.mp453.54MB
~Get Your Files Here !/6. Useful functions Sumif, VLookup, HLookup, If, Remove Duplicates/4. Using If function to test criteria and give results.mp439.01MB
~Get Your Files Here !/6. Useful functions Sumif, VLookup, HLookup, If, Remove Duplicates/5. Using Left and Right functions to extract data in a cell.mp446.22MB
~Get Your Files Here !/6. Useful functions Sumif, VLookup, HLookup, If, Remove Duplicates/6. Remove duplicates in a range of data.mp451.04MB
~Get Your Files Here !/6. Useful functions Sumif, VLookup, HLookup, If, Remove Duplicates/7. Shortcut keys to quickly select a range of cells.mp474.31MB
~Get Your Files Here !/6. Useful functions Sumif, VLookup, HLookup, If, Remove Duplicates/8. Absolute value of numbers.mp426.66MB
~Get Your Files Here !/7. Pivot Tables Summarizing Data and Finding Data quickly/1. Pivot Tables overview How to summarize data.mp493.56MB
~Get Your Files Here !/7. Pivot Tables Summarizing Data and Finding Data quickly/2. Pivot Tables report filters and column labels.mp460.84MB
~Get Your Files Here !/8. More Useful Functions & Options/1. Find & Replace options.mp466.62MB
~Get Your Files Here !/8. More Useful Functions & Options/2. Sum, count, average, time, date functions.mp466.74MB
~Get Your Files Here !/8. More Useful Functions & Options/3. Displaying cell formula (auditing cell formula).mp436.25MB
~Get Your Files Here !/8. More Useful Functions & Options/4. Sparklines to display trends inside a cell.mp474.9MB
~Get Your Files Here !/8. More Useful Functions & Options/5. Text to columns (split first and last name into 2 cells).mp450.04MB
~Get Your Files Here !/8. More Useful Functions & Options/6. Concatenate function (merging 2 columns into 1 column).mp429.97MB
~Get Your Files Here !/8. More Useful Functions & Options/7. Flash fill (getting Excel to fill in information automatically for you).mp448.69MB
~Get Your Files Here !/8. More Useful Functions & Options/8. Countif function.mp445.45MB
~Get Your Files Here !/8. More Useful Functions & Options/9. Protect sheet (prevent unauthorized or unwanted changes to an Excel sheet).mp461.56MB
~Get Your Files Here !/9. More Resources/1. Bonus lecture additional resources to learn bookkeeping.mp440.06MB