Master Microsoft Excel -- Full Tutorial (with Downloadable Workbooks)
Microsoft Excel - Full HD Tutorial with Downloadable Workbooks
Download the corresponding Excel Files Here: https://goo.gl/KqkWjf
In this three-hour Excel tutorial, we are going to cover the 10 core topics of Microsoft Excel. We'll be using Microsoft 2013, but these lessons will apply to almost any version.
In watching this tutorial, you should be able to learn how to create charts, use tables, short and filter data, apply formulas and functions, work with columns, rows, and worksheets, as well as apply many of Excel’s most common formatting features.
More specifically, we’ll cover the sections of:
#01: Getting Started with Excel 2013 (2:31)
#02: Entering Data (40:29)
#03: Formulas and Functions (01:01:16)
#04: Formatting & Presenting Data (01:26:51)
#05: Database Features (01:40:27)
#06: Using Tables (02:04:58)
#07: Charts & Graphs (02:15:01)
#08: Modifying & Adjusting Data (02:28:06)
#09: Using Special View Features within Workbooks (02:44:18)
#10: Managing Worksheets within a Workbook (02:56:48)
Right, ask questions and leave comments! We’d love to hear form you.
Lastly, feel free to subscribe to our channel and/or leave a thumbs up or thumbs down.
Our YouTube Channel: / @productivityme4153
Right, for the specific topics covered in each section you can find descriptions blow:
01.01 - What is Excel?
01.02 - Using Excels Menu System
01.03 - Using the Quick Access Toolbar
01.04 - The Structure of A Worksheet Or Workbook
01.05 - Using the Formula Bar
01.06 - Using the Status Bar
01.07 - Navigating Worksheets & Workbooks
01.08 - Shortcut Menus and the Mini Toolbar
01.09 - Using Excel's Built-in Help Function
01.10 - Creating New File; Saving That File
01.11 - Opening Existing File; Using Save As
02.01 - Entering Data
02.02 - Editing Data
02.03 - Undo & Redo
02.04 - Navigating within a Worksheet
02.05 - Making Desired Selection
02.06 - Using the Fill Handle
02.07 - Autocomplete & AutoFill
02.08 - Entering Times & Dates in Excel
03.01 - Entering Basic Math Formulas, Totals, and Averages in Excel
03.02 - Replicating Formula from a Near-by Cell
03.03 - Applying Varying Formulas Based on Cell's Context
03.04 - Quickly Remembering Order of Operations in with a Function
03.05 - Using Relative, Absolute, and Mixed References
03.06 - Exploring Basic Excel Functions - SUM
03.07 - Exploring Basic Excel Functions - PRODUCT
03.08 - Exploring Basic Excel Functions - AVERAGE
03.09 - Exploring Basic Excel Functions - MIN & MAX
03.10 - Exploring Basic Excel Functions - COUNT, COUNTA, COUNTBLANK
04.01 - Inserting and Deleting Columns & Rows
04.02 - Hiding and Unhiding Columns & Rows
04.03 - Adding, Modifying, and Removing Cell Borders
04.04 - Applying Different Number Formats
04.05 - Adjusting the Number of Decimals Displayed
04.06 - Changing a Cell's Format from a Number to Text
04.07 - Changing the Widths and Heights of Columns & Rows
04.08 - Wrapping Text
04.09 - Merging Contents from Multiple Cells
04.10 - Modifying Cell Font - Typeface, Color, Size, Color, Etc.
…
05.01 - Sorting Data
05.02 - Inserting Subtotals within Active Worksheet
05.03 - Filtering Data
05.04 - Data Tool: Text to Columns (Delimited)
05.05 - Data Tool: Text to Columns (Fixed Width)
05.06 - New to Excel 2013: Using Flash Fill
05.07 - Removing Duplicates from Selected Range
06.01 - Getting Started with Tables
06.02 - Inserting Tables & Understanding Contextual Tabs
06.03 - Modifying Table Formatting & Design
06.04 - Filtering a Table & Using the Search Functionality
06.05 - Adding Rows & Columns to a Table
06.06 - Converting a Table to a Range
07.01 - Getting Started with Charts
07.02 - Inserting Charts in Excel
07.03 - New to Excel 2013: Recommended Charts
07.04 - Understanding Chart Data & Chart Elements
07.05 - Modifying Chart Type
07.06 - Formatting the Data, Type, Location, and Elements of a Chart
07.07 - Modifying Chart Axis, Labels, Gridlines, Etc.
07.08 - Copying & Pasting Charts in Excel
07.09 - New to Excel 2013: Sparklines (In-Cell "Mini"Graphs)
08.01 - Modifying Cells - Dragging, Dropping, and Using Fill Handel (in Same Worksheet)
08.02 - Cutting, Copying, and Pasting (in Same Worksheet)
08.03 - Dragging & Dropping Contents (between Multiple Worksheets)
08.04 - Cutting, Copying, and Pasting (between Multiple Worksheets)
08.05 - Using Paste Special for More than Formatting
08.06 - Finding & Replacing Cell Contents
08.07 - Using Spellcheck in Excel
09.01 - Adding Comments to a Worksheet
09.02 - Freezing & Unfreezing Panes in Active Sheet
09.03 - Splitting Screens in Excel (Horizontally & Vertically)
09.04 - Displaying Multiple Worksheets or Workbooks
10.01 - Renaming a Worksheet ; Coloring a Worksheet
10.02 - Inserting & Deleting Worksheets
10.03 - Moving, Copying, and Grouping Sheets
10.04 - Modifying Multiple Worksheets Simultaneously