Excel 2013 Video Tutorials

Microsoft Excel 2013 Essential Training, Video Tutorials, Learn Microsoft Excel 2013 Now

Exercise Files 

Excel 2013 Video Tutorials

00 Introduction

00_01 Welcome
00_02 Exfiles

01 Getting Started with Excel 2013

01_01 Excel users
01_02 Menu
01_03 Quick Access
01_04 Worksheet
01_05 Formula
01_06 Status
01_07 Navigation
01_08 Shortcut Menu
01_09 Help
01_10 Files

02 Entering Data

02_01 Data Entry
02_02 Auto Fill
02_03 Dates Times
02_04 Undo Redo
02_05 Comments
02_06 File Save

03 Creating Formulas and Functions

03_01 Simple Formulas
03_02 Copy Formulas
03_03 YTD
03_04 Pct Incr
03_05 Absolute
03_06 Sum Average
03_07 Other Formulas

04 Formatting

04_01 Fonts
04_02 Column Width
04_03 Alignment
04_04 Borders
04_05 Numeric
04_06 Date Time 
04_07 Conditional
04_08 Tables
04_09 Insert Visuals

05 Adjusting Worksheet Layout and Data

05_01 Insert Delete
05_02  Hide
05_03  Move Copy
05_04 Find Replace

06 Printing

06_01 Page Layout
06_02 Page Break
06_03 Page Setup

07 Introduction to Charting

07_01 Creating Charts
07_02 Chart Types
07_03 Formatting 
07_04 Chart Elements
07_05 Spark Lines

08 Adjusting Worksheet Views

08_01 Freezing
08_02 Split
08_03 Outlining

09 Multiple worksheets workbooks

09_02 Rename
09_03 Move Copy
09_04 Linking Formulas
09_05 Managing Links

10 If,VLOOKUP & Power Functions

10_01 If Function
10_02 Vlookup Approx
10_03 Vlookup Exact
10_04 Count IF

11 Security & Sharing

11_01 Protect Worksheet
11_02 Protect Workbook
11_03 Workbook Password
11_04 Sharing Workbook
11_05 Tracking Changes

12 The Database Features of Excel

12_01 Sorting
12_02 Sub Total
12_03 Filter
12_04 Splitting
12_05 Duplicates

13 Pivot Tables

13_01 Create Pivot Table
13_02 Manipulating
13_03 Grouping
13_04 Grouping Other
13_05 Slicers
13_06 Pivot Chart

14 Data Analysis Tools

14_01 Goal Seek
14_02 Solver
14_03 Scenario
14_04 Data Table

15 Introduction To Macros

15_01 Micro Definition
15_02 Create Macro
15_03 Run Macro

16 Conclusion

16_01 Next Steps

2 Replies to “Excel 2013 Video Tutorials”

  1. while accesing for tutorials on excel it is saying request access denied for mail please give access

Leave a Reply

Your email address will not be published.

*