Learn how to master the Microsoft Excel basics 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:
- Tour of the Excel interface.
- Exploring the ribbon tabs.
- Working with worksheets.
- Dealing with data.
- Basic formulas.
Free Training Files are included which you should use to follow along. You may download the training files for free to your computer.
- FREE 7 videos (worth R200) showing the Workbook and Worksheet shortcuts that will help you speed up your work.
Get ready for the next Advanced level of Excel by mastering the basics today!
- By taking this course, you will learn how to prepare a spreadsheet for printing by doing a print preview first.
- Learn how to add up numbers quickly by using the AutoSum function, instead of using a calculator and wasting time.
- Remove duplicate data easily with a few clicks, instead of manually looking for the duplicate data and missing some of it.
- Do not replace all the text one by one in your long spreadsheet and taking a couple of minutes (or hours): instead, learn how to use the powerful find and replace tool to do the same job in a few seconds. Even for big spreadsheets.
- Learn how to use the TRIM function to remove extra spaces from the data that you received from another person who didn’t bother to clean the data before sending it to you.
What are the requirements for Excel basics?
- You should have the basic computer skills.
- Download the course training files to follow along.
- You need to have the Microsoft Excel 2007 program installed on your computer.
What am I going to get from this course?
- Over 95 lectures and over 5 hours of video!
- Create a print preview icon in the Quickaccess toolbar to quickly preview pages before printing them.
- Use the Office button to change the Excel options such as changing the look and feel of the spreadsheets.
- Minimize, restore and maximize spreadsheets for a better work environment.
- Use formulas to add up amounts in a spreadsheet instead of using a calculator.
- Zoom in and out of a spreadsheet to see the data better which can increase productivity.
- Use Excel to count rows of data in a matter of seconds.
What is the target audience?
- People who need to master the basics of Excel.
- Guys and girls who have not used Excel in a while and need to refresh their knowledge in Excel basics.
- Users who want to get ready for the next Intermediate and Advance levels of Excel.
- Administrators, clerks, accountants, managers, supervisors and so on.
- Not for users who have not used a computer before and just starting out.
Youtube channel: https://www.youtube.com/channel/UC7NB3cC3XTFTZ6ww19aBx1Q
Google Plus: https://plus.google.com/104589243313339477909
Take the course now!
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!
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
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 group
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
- 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
- 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 group
- 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