Sale has ended but you can still get this app.
Download Tutorials for MS Excel VIP Now

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.

List of Tutorials (New tutorials will be added for free.)

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 BasicFormulas
3.2 CopyFormulas
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

You are allowed to use this product only within the laws of your country/region. SharewareOnSale and its staff are not responsible for any illegal activity. We did not develop this product; if you have an issue with this product, contact the developer. This product is offered "as is" without express or implied or any other type of warranty. The description of this product on this page is not a recommendation, endorsement, or review; it is a marketing description, written by the developer. The quality and performance of this product is without guarantee. Download or use at your own risk. If you don't feel comfortable with this product, then don't download it.

You May Like