You have no items in your shopping cart.

Excel Tutorials for Beginners

Picture of Excel Tutorials for Beginners

1) Excel Tutorial - Beginners Level 1

Chapters: 0:00 Start 1:07 Starting up 1:27 Recent documents and pinning documents 1:54 Templates 2:34 Layout - Tabs, ribbons, and groups in Microsoft Excel 3:48 Rows, Columns, Cells and Ranges 5:49 Worksheets in Microsoft Excel 6:52 View and zooming 7:30 Inputting Data 10:56 Formatting Data 13:38 Wrapping Text 14:22 Insert Row/ Merge & Center cells 15:41 Currency formatting 16:20 Print view 17:02 Add cell borders and colors 18:18 Basic formulas in Microsoft Excel 21:17 Copy formula 23:45 Freeze Pane 24:52 Basic Microsoft Excel functions 28:59 “Tell Me” in Microsoft Excel 29:43 Inserting charts in Microsoft Excel

 

2) Excel Tutorial - Beginners Level 2

Chapters: 0:00 Start 0:52 AutoFilling cells in Excel 4:18 Add your own autofill 5:49 Sorting data in Excel 8:56 Using filters in Microsoft Excel 12:45 Round functions in Excel 15:40 Relative Relative cell references 17:14 Absolute Relative cell references 18:55 Absolute Absolute cell references 20:17 Relative Absolute cell references

 

3) Excel Tutorial - Beginners Level 3

Chapters: 0:00 Introduction 1:12 Simple copy/paste 3:23 Transpose paste in Excel 5:21 Copy and paste formulas in Excel 6:53 Paste a link 8:47 Special paste in Microsoft Excel 10:18 How to use Flash Fill in Excel 12:53 Different ways to use Flash Fill 15:28 Hyperlinks in Excel (link to websites) 19:16 Create a directory or table of contents with internal links

 

4) How to Build Formulas and Functions in Excel

Chapters: 0:00 Intro 0:49 Basic math formulas 3:20 Starting with the SUM Function in Excel (with shortcuts) 5:47 The COUNT function 6:29 Take a look at the status bar in Excel 8:10 AVERAGE, MEDIAN and MODE functions 10:05 MIN and MAX functions in Microsoft Excel 10:54 Functions and formulas with Date and time in Excel 14:11 Using formulas to combine columns 16:05 If statements in Excel 19:26 How VLOOKUP works 21:34 Conditional functions (SUMIF, SUMIFS, COUNTIF, etc.) 24:33 How to use the function wizard

 

5) Excel Tutorial - Beginners Level 4

Chapters: 0:00 Introduction 1:04 What is Conditional Formatting in Excel? 1:44 How to use Conditional Formatting 12:18 What is Data Validation in Microsoft Excel? 12:53 How to create a drop-down menu in Excel 15:31 Create a drop-down list from a list 20:07 How does a slicer work in Microsoft Excel? 20:54 Add slicers to your worksheet

 

6) Excel Pivot Table Tutorial for Beginners

 

7) Vlookup Function in Excel for Beginners

 

8) 10 Best Excel Tips for Beginners

Chapters: 0:00 Start 0:42 Quick Analysis 2:16 Filter 3:57 Control keys 4:25 Adjust column widths in Excel 5:13 Flash Fill and Auto Fill in Excel 7:04 Absolute cell reference 9:24 Transpose tables in Microsoft Excel 10:14 Text columns 11:47 Inserting a screenshot 12:53 Show formulas

 

 9) How to Make a Line Graph in Excel - From Simple to Scientific

 

10) How to Create Drop-Down List in Excel

 

11) How to QUICKLY Use 3D Formulas in Excel

 

12) Quickly Create an Excel Data Entry Form Without VBA