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.
Reviews for Tutorials for MS Excel VIP
Click Here to Read Reviews for Tutorials for MS Excel VIP >> Click Here to Submit Reviews for Tutorials for MS Excel VIP >>