Tutorials for MS Excel VIP
$4.69
Advertisements
About Tutorials for MS Excel VIP
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
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
All Application Badges
Paid
app
app
Android
4.0+
4.0+
Android app
App History & Updates
What's Changed
first version
first version
Oh snap! No comments are available for Tutorials for MS Excel VIP at the moment. Be the first to leave one!