Excel 2013

Excel 2013 Tutorials

Excel 2013 Tutorials  Available at Udemy and Teachable :

Enroll in Teachable Enroll in Udemy

Excel Tutorials For Beginners to Experts

Course Description

Learn the secrets of Excel and become an Excel Expert. This course can be used with Excel 2013 and Excel 2016.

This course is created for Excel beginners and has been designed for computer users who are willing to learn Microsoft Excel in simple steps. At the end of this course you will become an Excel Expert for sure. Also, even Excel Experts can improve their Excel Skills by the help of this course.

Tutorials are with English subtitles. Exercise files are included for each lecture. Shorcut Keys indicated for each lecture if available.

You will begin at beginner level and reach to intermediate level. You will use Excel effectively in your daily life, such as job, personal data usage etc.

Course consists of 11 Chapters. New Chapters will be added.

Take this course to make your life easy and organized with Excel.

Enroll in Teachable  Enroll in Udemy

What are the requirements?

  • Excel beginners must install Excel 2013 before beginning the course

What am I going to get from this course?

  • Over 51 lectures and 2.5 hours of content!
  • Learn all the basic information about Excel and become an Excel Expert.

What is the target audience?

  • Excel beginner users must take the course, Excel already users can develop their skills with the new features of Excel 2013.

Curriculum

Chapter 1 – Introduction

1.1 Menu
1.2 Workbook
1.3 Worksheet
1.4 Quick Access Toolbar
1.5 Column Row Cell Status

Chapter 2 – Data Entry

2.1 Entering Data
2.2 Auto Fill and Flash Fill
2.3 Dates and Times
2.4 Undo Redo
2.5 Comments
2.6 New Open Save and Save As

Chapter 3 – Formulas and Functions

3.1 Basic Formulas
3.2 Copy Formulas
3.3 Hierarchy
3.4 Absolute References
3.5 AutoSum

Chapter 4 – Formatting

4.1 Font and Borders
4.2 Column Width and Row Height
4.3 Alignment
4.4 Number
4.5 Date and Time Format
4.6 Conditional Formatting
4.7 Tables
4.8 Illustrations

Chapter 5 – Worksheet Layout

5.1 Insert and Delete Cells
5.2 Hide and Unhide
5.3 Cut Paste Copy Move
5.4 Find and Replace

Chapter 6 – Print

6.1 Page Setup and Scale to Fit
6.2 PageBreakPreview and PageLayout
6.3 Print

Chapter 7 – Charts

7.1 Recommended Charts
7.2 Creating Charts
7.3 Chart Formatting Shortcuts
7.4 Change Chart Type
7.5 Formatting Chart Elements
7.6 Trendline
7.7 Sparklines

Chapter 8 – Worksheet Views

8.1 Freeze Panes and Split
8.2 Auto Outline

Chapter 9 – Multiple Worksheets and Workbooks

9.1 Linking Data
9.2 Edit Links

Chapter 10 – IF, VLOOKUP, and Other Functions

10.1 IF Function
10.2 VLOOKUP Function
10.3 COUNTIF Function

Chapter 11 – Security and Sharing

11.1 Protect Sheet
11.2 Lock Cells
11.3 Protect Workbook
11.4 Workbook Password
11.5 Share Workbook
11.6 Track Changes

Excel 2013 Tutorials  Available at Udemy and Teachable :

Enroll in Teachable Enroll in Udemy

Hi there, do you love what we do? Then please help by donation to us. We thank you in advance!

 

1,057 total views, 1 views today