~Get Your Files Here !

  1. Introduction

   1. Introduction.srt

  2. Microsoft Excel Basics

   1. How to make the most of this course (subtitles, speed up videos).srt

   2. Navigating around Microsoft Excel.srt

   3. Entering text and numbers into Excel.srt

   4. Adding numbers using the SUM function.srt

   5. Subtract, multiply, and divide in Excel.srt

   6. Correcting cells and moving around cells.srt

   7. Inserting columns and rows in Excel.srt

   8. Conditional Formatting to add colors to data.srt

   9. Clear Formats and Clear Content in cells.srt

  3. Formatting cells, Format Painter, Wrap Text

   1. Formatting cells in Microsoft Excel (Bold, borders, highlight, merge & center).srt

   2. Using Copy, Cut, Paste, and Format Painter to copy cell format.srt

   3. Paste Values using Paste Special.srt

   4. Using Wrap Text to wrap spill over text in a cell.srt

   5. Formatting numbers using dollar sign, percentage, decimal points.srt

  4. Excel Shortcuts, MeanMedianMode, Split Screen, Grouping Data

   1. Excel shortcuts - openclosesave spreadsheet, bolditalics, copy, paste, undo.srt

   2. Excel shortcuts - Home tab, delete column, insert row, zoom.srt

   3. Excel shortcuts - Tab, move to last cell, move to next worksheet, move down.srt

   4. Mean, median, mode, count cells.srt

   5. Split screen to work on different parts of the same Excel sheet simultaneously.srt

   6. Grouping data (expand and collapse data).srt

  5. Charts, Sort & Filter, Freeze Panes View, Print Preview Options

   1. Using Charts (pie charts, column charts).srt

   2. Sort and Filters in Excel.srt

   3. Using Freeze Panes in Excel to see column headings and row headings.srt

   4. Absolute Reference to prevent cell reference from moving.srt

   5. Print Preview options.srt

  6. Useful functions Sumif, VLookup, HLookup, If, Remove Duplicates

   1. Using Sumif function to add cells based on criteria you set.srt

   2. Using VLookup function to find data quickly.srt

   3. Using HLookup function to find data quickly.srt

   4. Using If function to test criteria and give results.srt

   5. Using Left and Right functions to extract data in a cell.srt

   6. Remove duplicates in a range of data.srt

   7. Shortcut keys to quickly select a range of cells.srt

   8. Absolute value of numbers.srt

  7. Pivot Tables Summarizing Data and Finding Data quickly

   1. Pivot Tables overview How to summarize data.srt

   2. Pivot Tables report filters and column labels.srt

  8. More Useful Functions & Options

   1. Find & Replace options.srt

   2. Sum, count, average, time, date functions.srt

   3. Displaying cell formula (auditing cell formula).srt

   4. Sparklines to display trends inside a cell.srt

   5. Text to columns (split first and last name into 2 cells).srt

   6. Concatenate function (merging 2 columns into 1 column).srt

   7. Flash fill (getting Excel to fill in information automatically for you).srt

   8. Countif function.srt

   9. Protect sheet (prevent unauthorized or unwanted changes to an Excel sheet).srt

  9. More Resources

   1. Bonus lecture additional resources to learn bookkeeping.srt

  Bonus Resources.txt