Excel 2013 Tutorial: A Complete Guide to Excel for Anyone
An easy to follow tutorial outlining everything you need to know on
Excel to gain the skills to enhance your resume. Designed for the absolute beginner. Learn Excel in just a couple hours:
Concepts based.
Easy to understand. See also
http://kaceli.com for more info.
Thanks for watching.
Data File if you would like to follow the video hands-on is available from: https://drive.google.com/file/d/0B3-9HUBAvpxnVm9GVDBjSVVPcGc/view?usp=sharing. Make sure you choose to download it first and not use it within
Google Drive.
If you are interested in taking the full Excel course on Udemy or want to support this work, you can save up to 50% with the code: salikaceli or from here: https://www.udemy.com/excel2013in2hours/?couponCode=salikaceli
This video covers the following topics along with the timeline:
0:5 Learn how to get started with Excel
2013 and get the big picture first.
7:06 Learn about
Basic Calculations:
SUM, AVERAGE,
MAX,
MIN in Excel 2013
24:50 Learn how to use
Arithmetic Calculations:
Subtraction, Multiplication,
Division Excel 2013
31:30 Learn about the
Relative,
Absolute and
Mixed Cell References and how to practically apply them in Excel 2013.
41:32 Learn how to use Conditional Formatting and
Data Analysis in Excel 2013
.
45:00 Learn how to sort and filter data in Excel 2013
.
50:45 Learn how to create and modify charts
59:00 Learn how to post values using formulas in Cross-Sheet Calculations in Excel 2013.
1:05:15 Learn how to calculate percentages in Excel 2013
1:09:44 Learn how to use the IF statement in a
Formula
1:15:55 Learn about financial formulas such as
PMT, IPMT,
PPMT functions in Financial Calculations
1:26:20 Learn how to use
Named References
1:31:15 Learn how to do Data
Validation Using Drop-Down Lists
1:34:30 Learn how to use
Pivot Tables
1:40:12 Learn how to set and clear the print are in Excel 2013.
1:44:20 Linking Excel Data with
Word
1:49:00 Learn how to import and export data in Excel Importing and
Exporting Data in
.csv files
1:53:00 Learn how to save a spreadsheet in
PDF Format
Learn Excel Full Tutorial: https://www.youtube.com/watch?v=hBy7BZs-zx0
Word 2013 Tutorial is available from here: https://www.youtube.com/watch?v=SCEfzjTRObA
Excel 2007 Full tutorial here: https://www.youtube.com/watch?v=IbAfTCN2qwg
Excel 2013 tutorial: https://www.youtube.com/watch?v=1mNwJkUYS9A
For other functionality, please check the other videos on this channel.
Feel free to subscribe to the channel for the latest updates and refer other friends to it.
Note that there are also playlists available and full videos that include all aspects of the applications.