Are you looking for an online Excel course that helps you understand how to use functions and formulas? Formula School recently launched their Formulas 101 online course which will help everyone come to grips with how to use formulas in Excel.
The interactive course which combines video, text, image and screencast content with an Excel based student workbook, covers everything you need to know about formulas and functions like SUM, AVERAGE, MIN, MAX and COUNT. There are units focused on working with text in formulas, and understanding and resolving Excel errors, as well as a key Excel concepts unit for those who need a refresher on the basics.
The thing I like about the course is that it includes quizzes and assessment along the way, and if you pass it all you can get your Certificate of Completion!
For anyone interested in reducing their frustration with Microsoft Excel, Formula School’s Formulas 101 course is for you.
’til next time!
Do you have multiple sheets in your Excel workbook? Want to have something more descriptive than “Sheet 1”, “Sheet 2”, or “Sheet 3” so you can keep track of all the work in your spreadsheet, model, or budget? It is quick and easy to rename your sheets in Excel 2007, Excel 2010 or Excel 2013.
- Right click on the tab for the sheet you want to rename
- Click “Rename”
- Type your new name in… and then hit enter!
Simple as that – now you can keep track of all those sheets in your workbook with ease.
’till next time!
Ever wanted to multiply two different numbers together in Microsoft Excel? The great thing about Excel is that you don’t need to use a calculator to do it – Excel can do it for you! But we need to tell Excel what to do first!
- Type the numbers into Excel that you want to “times by”. Make sure they are in two different cells (a cell is one of those little square boxes you see)
- Click on the cell where you want the answer to appear
- Start typing the following formula. Firstly, hit the equals key, then select the first number, then add a “multiply” symbol – which in this case is the star on the 8 key (shift 8), then select the second number and hit enter
- Your answer will appear!
If you want to take a look at the formula we just created together, click on the cell where the answer appears. Look up in the formula bar (just below the ribbon) you will see something like =A1*A2. Don’t worry if it doesn’t make sense at the moment, the best way to look at it is to read it out loud. In this case “this cell equals whatever is in cell A1 times whatever is in cell A2”. Simple!
’till next time!
Have you ever wanted to figure out what the total would be if you added two cells together in Excel? There is a really simple way to do it – without your calculator. Let me explain how….
- Make sure you have typed your numbers into Excel in different cells
- Select the cell you want to have the total appear in (it may make sense to be below the numbers you just typed in)
- Once you have clicked on the cell, type an equals sign, select the first cell, type a plus sign, then select the second cell, then hit enter
- You should now see the total of the two cells!!!
If you click on the cell with the total in it, you will notice something we call a formula. In this case it might look like “=A1+A2 “. The best way to figure out what the formula in the cell is calculating is if you read it out loud. In this case it says “this cell equals whatever is in A1 plus whatever is in A2”.
So there you have it – the simple way to add two cells together in Excel (and your introduction to formulas!)
’till next time!
So your masterpiece is complete and you want to print it to share with the world? It is easy to print your document, poster or other Word 2013 creation.
- Click on the “File” menu
- Click on “Print”
- Take a look at the print preview and make sure it looks ok, and if it does…
- Click on the big “Print” button
’till next time!
So… you have been working on that spreadsheet for hours and all of a sudden you deleted the wrong thing. Now you need to undo what you did in Excel 2013? Here is how to do it:
- Look in the top left hand corner of the Excel screen – above the File menu. You will probably see a few small icons there. Look for the arrow pointing backwards – that is the undo button.
- Click on it to undo what you just did
- If you want to undo a few steps, you can click on the little drop down arrow on the button, and you can undo the last 20 or so actions you have done
There you go – your formulas are still safe!
’till next time!
Are you one of the thousands of businesses around the word looking to use Microsoft’s Office 365 “cloud” service, but don’t know where to start?
Well Microsoft Press have made available a free e-book which helps you get started. Called “Microsoft Office 365: Connect and Collaborate Virtually Anywhere, Anytime.”
I like this book for a few reasons. Firstly – FREE! Secondly, it covers a lot of the questions you probably have about Office 365 and gives you some pretty good answers. It covers topics like:
- Getting Started with Office 365
- Administering an Office 365 Account
- What your team can do with Office 365
- Creating your Team Site with SharePoint Online
- Posting, Sharing and Managing Files
- Adding and Managing Workflows
- Working with Office 2010 Web Apps
- Going Mobile with Office 365
It is a good blend of technical content for the folk that need to set up and run Office 365 for others, plus a little bit of user content to help you understand exactly how Office 365 works under the covers, and how you can use it to work better, faster, and stronger!
You can download the free Office 365 ebook from Microsoft here.
Are you just starting out with Project 2010? Maybe you are a “real-world hardened” project manager looking to create a better Work Breakdown Structure?
Microsoft have put together a great site to help you get more out of Project. You can learn about:
- Easier Planning with User-Controlled Scheduling
- Enhanced Copy & Paste
- Intuitive Access with the Ribbon
- Add Key Milestones to the Timeline View
- Add a New Column and Save as a Custom Table
- Manage Resources with the Team Planner
- Add Project Summary Tasks & Outline Numbers
- Make Smart Scheduling Decisions with Task Inspector
- Sync with SharePoint
- Focus on Data with Auto Filter
You can find all those tips and tricks articles over at the Microsoft Project 2010 site, on Microsoft.com
Are you deploying Office 2010 in your organisation and looking for a great (ie FREE!) way to increase the adoption of Office 2010? Or maybe you are a home user just interested in learning more about Word, Outlook or Excel?
Either way – Microsoft have a great training tool available which can help you or your people get more out of Office 2010. It is the Office 2010 Getting Started Screensaver.
Now you need to be running Windows 7 to use it, but if you are, it is one of the better ways I have seen to learn more about Office.
Click here to download the screensaver today. Thanks to Ian Palangio from Microsoft Australia for pointing it out!
‘till next time!
If you are like me and follow Rugby Union (Go the ALL BLACKS!!!), you will love something that the team at the Excel Blog posted the other day.
It is a spread sheet that you can use to track your team’s progress during the world cup.
Read more about the Rugby World Cup score tracker and get your hands on the free Excel spread sheet on the Excel Blog