Excel 2007 Basics: Learn the basics of Excel in less than a day. Start now!
Master the basics of Excel and get ready for the next Advanced level. Free training files and bonus shortcuts included!Watch Promo
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:
- 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.
- 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.
- FREE 7 videos (worth $15) 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!
What are the requirements?
- 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?
- 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.
- Not for users who have not used a computer before and just starting out.
Youtube channel: https://www.youtube.com/channel/UC7NB3cC3XTFTZ6ww1...
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!
PreviewThe office button (2:48)
StartThe ribbon (3:46)
StartExcel options (5:02)
StartExploring the quick access toolbar (4:04)
StartThe minimize maximize restore and close buttons (1:45)
StartThe zoom area (4:26)
StartThe status bar (2:05)
StartPage preview icon area (1:12)
StartThe header area (0:58)
StartHome tab clipboard group (4:14)
StartHome tab font group (4:25)
StartHome tab alignment group (3:56)
StartHome tab number group (2:28)
StartHome tab styles group (1:25)
StartInsert tab tables group (2:34)
StartInsert tab illustrations group (5:40)
StartPage layout tab themes group (1:16)
StartPage layout tab page setup group part one (3:14)
StartPage layout tab page setup group part two (4:40)
StartPage layout tab sheet options group (1:00)
StartFormulas tab function library group (1:49)
StartFormulas tab defined names group (2:14)
StartData tab sort and filter group part one (5:44)
StartData tab sort and filter group part two (2:38)
PreviewReview tab proofing group (3:09)
StartReview tab comments group (2:59)
StartView tab workbook views group (1:02)
StartView tab show hide group (0:40)
StartView tab zoom group (1:39)
StartView tab window group part one (2:45)
StartView tab window group part two (4:08)