Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Learn how to master the basics of Microsoft Excel in a few hours, increase your speed of working by creating button shortcuts in the quick access toolbar and how to save paper by previewing your spreadsheet before you actually print. And many more!
Although this basics course is for Excel 2007, you can still use the skills you learn here for the later versions of Excel, including Excel 2010, 2013 and 2016.
Maybe you have just have the basic skills of using a computer. You know, like how to use a mouse and a keyboard. How to use the windows explorer to move from Excel to PowerPoint to the Internet explorer, for an example. Well, the next logical step is to start today to learn the basics of Excel. And in this course, you will learn exactly that.
Topics in this course include:
Free Training Files are included which you should use to follow along. You may download the training files for free to your computer.
Get ready for the next Advanced level of Excel by mastering the basics today!
Take the course now!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Welcome Excel 2007 basicsPreview
What you need to know for this coursePreview
What is excelPreview
|Section 2: Tour of the interface|
The office buttonPreview
Exploring the quick access toolbar
The minimize maximize restore and close buttons
The zoom area
The status bar
Page preview icon area
The header area
|Section 3: Exploring the ribbon tabs|
Home tab clipboard group
Home tab font group
Home tab alignment group
Home tab number group
Home tab styles group
Insert tab tables group
Insert tab illustrations group
Page layout tab themes group
Page layout tab page setup group part one
Page layout tab page setup group part two.mp4
Page layout tab sheet options group
Formulas tab function library group
Formulas tab defined names group
Data tab sort and filter group part one
Data tab sort and filter group part two
Review tab proofing groupPreview
Review tab comments group
View tab workbook views group
View tab show hide group
View tab zoom group
View tab window group part one
View tab window group part two
|Section 4: Working with workbooks|
What is a workbook
Creating a new workbook
Saving a workbook
Opening and closing a workbook
Deleting a workbook
Renaming a workbookPreview
|Section 5: Working with worksheets|
What is a worksheet
Opening a worksheet
Saving a worksheet
Deleting a worksheet
Moving and copying worksheets
Changing sheet colours
Exploring the autofills
Hiding and unhiding sheets
Selecting several worksheets
|Section 6: Columns rows and cells|
What are columns
What are rows
What are cells
Resizing column widths
Resizing row heights
Hiding and unhiding columns and rows
|Section 7: Dealing with data|
Text to columns
|Section 8: Printing|
Printing basics part 1
Printing basics part 2
Working with print preview
Page setup options part 1
Page setup options part 2
Printing your spreadsheet
|Section 9: Formulas|
What is a formulaPreview
The formula bar
The formula auditing group part 1
The formula auditing group part 2
The calculation group
|Section 10: Functions|
What is a function
Types of functions
The autosum function
Minimum and maximum functions
Finding the average of numbers
The trim function
The left and right functions
Lower proper and upper functions
Merging two cells
|Section 11: Bonus: workbook and worksheet shortcuts|
Opening and closing workbooks
Switching between workbooks
Walter Mogane - Trainer and author
As an Excel trainer, I love teaching Excel to students, business men and women or just the guys working for an employer. I emphasize how important it is to apply the Excel knowledge you will have gained in your every day job. That way you truly become more productive.
I have been teaching Excel and other Microsoft suite programs for over 15 years and have received diplomas in Basic, Intermediary and Advanced Microsoft courses. I also received an outstanding achievement award for the Advanced Excel course I completed.
I believe that it is vital that you do the quizzes for each lesson as you progress to test your understanding. If you get some questions incorrect in a quiz, don't worry, just try again until you come right.
You can do the sections in any order you like. I don't believe that you have to do the sections in a forced order. This also is very helpful if you just want to dive into a particular section, without having to do the other sections first. Having said that, I do recommend that you do the sections in the order they are available in the course.
In my spare time I enjoy going to the gym, playing tennis, table tennis, swimming, listening to Rap, Soul and R & B music. Sometimes I just generally enjoy coming up with solutions to some of the world problems. I believe that's my entrepreneurial spirit talking. Oh well... there I said it!
I also enjoy spending time with my family watching family movies although my kids and my loved one always sleep halfway through the movies. So, well, I ended up watching the movies alone. Sniff, sniff!