Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Excel 2007 Tutorial - A Comprehensive Guide to Excel for Anyone - Excel Made Easy. and this video is uploaded by Kaceli TechTraining at 2015-04-01T19:33:21-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [IbAfTCN2qwg]
| Name | Excel 2007 Tutorial - A Comprehensive Guide to Excel for Anyone - Excel Made Easy |
| Video Uploader | Video From Kaceli TechTraining |
| Upload Date | This Video Uploaded At 02-04-2015 02:33:21 |
| Video Discription | An easy to follow step-by-step tutorial outlining everything you need to know for the corporate environment on Excel. Learn Excel in just a about one hour: Concepts based. Easy to understand. Try it now. You will not be disappointed and also spread the word. Become a pro in just one hour. See also http://kaceli.com. The video is based on Excel 2007. The same concepts apply to later versions too. The data file to follow hands-on is available from here: http://kaceli.com/a/excel2007-datafile/ TABLE OF CONTENTS WITH MARKERS is below. This tutorial covers various aspects of commonly used features in today's business environment and is intended to be completed in one hour. It is concise and useful for beginners and those who want to sharpen their skills. Take one hour and become proficient as a student or professional. It is concepts based and simple to follow and understand. It covers: 00:13 - Getting started with Excel 2007 03:40 - Entering Data and Data Types 09:10 - Calculating the SUM and Using the Autofill Feature 13:10 - Max, Minimum, Average, Count Functions 15:20 - Division, Multiplication, Subtraction 17:15 - Understanding Absolute vs. Relative References 21:40 - Formatting and Styles 23:20 - Headers and Footers 25:20 - Calculating Percentages 27:50 - Conditional Formatting 30:20 - Undestanding Additional Excel Functions 32:50 - Sorting Data 34:30 - Data Filtering 36:30 - Creating Charts 39:20 - Cross-Sheet Calculations 44:40 - Using Comments 46:05 - Integrating Excel with Word 52:00 - Performing a mailmerge 59:00 - Excel Pivot Tables. Excel 2013 tutorial is available from here: https://www.youtube.com/watch?v=1mNwJkUYS9A Excel 2010 tutorial is available from here: https://www.youtube.com/watch?v=hBy7BZs-zx0 Excel 2007 tutorial is available from here: https://www.youtube.com/watch?v=IbAfTCN2qwg 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. [IbAfTCN2qwg] |
| Category | Education |
| Tags | Excel tutorial free | excel 2017 tutorial | excel tutorial for beginners | learn excel free | skaceli | complete excel tutorial | excel basics | excel formulas | excel filtering and sorting | excel conditional formatting | excel logical functions | pmt | ppmt | if statement | excel advanced features tutorial | excel for the workplace | excel reports | excel pivot tables | excel budget | using excel tutorial | learn excel | best excel tutorial |
