Hellow guys, Welcome to my website, and you are watching Excel 2013 Tutorial: A Comprehensive Guide to Excel for Anyone. and this vIdeo is uploaded by Kaceli TechTraining at 2014-12-29T18:14:55-08:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Excel 2013 Tutorial: A Comprehensive Guide to Excel for Anyone |
| Video Uploader | Video From Kaceli TechTraining |
| Upload Date | This Video Uploaded At 29-12-2014 21:14:55 |
| Video Discription | 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. For more info. visit http://learn.kaceli.com. Data File if you would like to follow the video hands-on is available from: https://kaceli.com/a/excel-2016-data-file/ 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 If you want to take get a deeper understanding of Microsoft Office applications, take a look at http://learn.kaceli.com Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need. |
| Category | Education |
| Tags | Office 365 | SUM | AVERAGE | MIN | MAX | PMT | IPMT | PPMT | basic excel calculations | excel 2013 tutorial | how to use Excel | relative | relative cell references | absolute cell references | IF statement | set print area | pivot tables in excel | importing .csv files | Microsoft Excel (Software) | excel full tutorial | learn excel | easy excel tutorial | beginner excel tutorial | excel basics | skaceli | excel formulas | formulas | functions | references | excel references | excel tutorial |
