Microsoft Excel Microsoft Excel was developed by Microsoft in 1982 and made part of the Microsoft Office Suite. Under the Microsoft banner it has become the best selling software for building professional spreadsheets.
A bit of history… Microsoft originally marketed a spreadsheet program called Multiplan in 1982. Multiplan became very popular on CP/M systems, but on MS-DOS systems it lost popularity to Lotus 1-2-3. Microsoft released the first version of Excel for the Macintosh on September 30, 1985, and the first Windows version was 2.05 (to synchronise with the Macintosh version 2.2) in November 1987. Lotus was slow to bring 1-2-3 to Windows and by the early 1990s Excel had started to outsell 1-2-3 and helped Microsoft achieve its position as a leading PC software developer for spreadsheet software. This accomplishment solidified Microsoft as a valid competitor and showed its future of developing GUI software. Microsoft has maintained its advantage with regular new releases, every two years or so. (The link below is a Wikipedia page which opens up in either a new window or tab, depending how you have your browser set up. This link gives much more information on Excel and its history.)
IMPORTANT NOTE: It doesn't matter what type of computer you use. The YouTube video links work in the same way across ALL operating systems.
Source of the videos: We have used video links from the Goodwill Community Foundation Learn Free website. To see the Excel videos, and other software training in their portfolio, you can access it via the link below.
The videos in this series will give you excellent training on using Microsoft Excel. With practice it's easy enough to master, though it's a comprehensive program that requires time to learn it properly. This is especially so if you are to master the way to use functions and more complex features like the advanced formulas and Pivot Tables. In all there are 26 training videos; each one varies in length from a short three or four minutes to ones that are around seventeen minutes. You can replay them, or come back to them, as often as you like.
YouTube & Advertising
This is a Google owned business. They make their money through advertising. When some videos start to play there may be an advert appearing. Usually there is an option to click the advert ribbon off by clicking on the X in the top right hand corner and it should disappear.
At the end of each video there will be a reminder of who produced the video (in this case it's simonsezit.com but you can stop the video at anytime and go to the next one. Lots of businesses use YouTube to promote their services so it's not unreasonable if they promote their stuff!
Practice makes perfect…
If you have Microsoft Excel on your computer it may be useful to have the program open so you can practice what you learn.
By using the square symbol in the bottom right hand corner of the video you can make it play in full screen mode.
A suggestion… Work through the video training as your time allows. The running time for all of the training is around one hour and forty five minutes approx. By scheduling to watch them over several days you will soon be competent with this software.
Getting Started With Microsoft Excel 2016
Part 1
Getting Started with Excel
Running Time: 4.21
Part 2
Create & Open Workbooks
Running Time: 2.34
About One Drive:
This 'cloud' based platform is owned by Microsoft Corp.
There are alternatives;
iCloud
(owned byApple)
Google Drive
(Yes, owned by Google!)
Part 3
Saving & Sharing
Running Time: 3.50
Cell Basics - Excel 2016
Part 4
Cell Basics
Running Time: 4.28
Part 5
Columns, Rows & Cells
Running Time: 4.48
Part 6
Formatting Cells
Running Time: 3.54
Part 7
Number Formats
Running Time: 5.43
Part 8
Using Multiple Worksheets
Running Time: 3.54
Part 9
Using Find & Replace
Running Time: 1.55
Within Excel, like the other components of the Microsoft Office Suite, Word and Powerpoint, it's possible to spell check the document. There isn't a video to show you how to do this but the link on the right will take you through the process.
Part 10
Page Layout & Printing
Running Time: 5.37
Formulas & Functions - Excel 2016
Part 11
Intro To Formulas
Running Time: 3.38
Part 12
Creating More Complex Formulas
Running Time: 5.11
Part 13
Relative & Absolute Cell References
Running Time: 5.25
Part 14
Functions
Running Time: 5.16
Working With Data - Excel 2016
Excel workbooks are designed to store a lot of information. Whether you're working with 20 cells or 20,000, Excel has several features to help you organise your data and find what you need. You can see some of the most useful features below. And be sure to check out the other lessons in this tutorial to get step-by-step instructions for each of these features.
Part 15
Freeze Panes & View Options
Running Time: 4.22
Part 16
How To Sort Your Data
Running Time: 4.30
Part 17
Filtering
Running Time: 4.46
Part 18
Groups & Subtotals
Running Time: 4.23
Part 19
Tables
Running Time: 3.20
Part 20
Using Charts
Running Time: 4.31
Part 21
Conditional Formatting
Running Time: 3.45
Doing More With Excel 2016
Part 22
Track Changes & Comments
Running Time: 5.32
Part 23
Inspecting & Protecting Workbooks
Running Time: 3.13
Part 24
Introduction To PivotTables
Running Time: 4.34
Part 25
What-If Analysis
Running Time: 3.29