Category Archives: * Level 100 – Beginner

Learn Excel Formulas Online at Formula School

Posted by

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, ophthalmologist text, stuff image and screencast content with an Excel based student workbook, this 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!
TNP 😉

Rename your sheet in Excel

Posted by

Do you have multiple sheets in your Excel workbook? Want to have something more descriptive than “Sheet 1”, health “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.

  1. Right click on the tab for the sheet you want to rename
  2. Click “Rename”
  3. 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!
TNP 😉

How to multiply two cells together in Excel

Posted by

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!

  1. 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)
  2. Click on the cell where you want the answer to appear
  3. Start typing the following formula.  Firstly, side effects 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
  4. 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!
TNP 😉

Add two cells together in Excel

Posted by

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….

  1. Make sure you have typed your numbers into Excel in different cells
  2. Select the cell you want to have the total appear in (it may make sense to be below the numbers you just typed in)
  3. Once you have clicked on the cell, information pills type an equals sign, hospital select the first cell, sildenafil type a plus sign,  then select the second cell, then hit enter
  4. 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!
TNP 😉

How to Undo in Excel

Posted by

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:

  1. 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.
  2. Click on it to undo what you just did
  3. If you want to undo a few steps, hair you can click on the little drop down arrow on the button, this web and you can undo the last 20 or so actions you have done

There you go – your formulas are still safe!

’till next time!
TNP 😉

Getting Started with Office 365? Get the E-Book

Posted by

Don’t you hate that annoying email pop up whenever you get an email in Outlook 2013?  Well there is an easy way to turn it off.  All you have to do is:

  1. Click on “File”
  2. Click on “Options”
  3. From the Outlook Options dialog box that appears, page click on “Mail” in the left hand column
  4. Look for the section called “Message Arrival”.  If you want to turn all notifications off, purchase including sound, the mouse pointer turning into an envelope, the envelope icon in the task bar and the pesky desktop alert, simply untick the options you don’t want.
  5. Click “OK”

Simple as that!  If you want to turn them back on simply repeat the process, but tick the notifications you want!  If you are using Outlook 2010 the process is very similar

’till next time
TNP 😉

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, clinic 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, glands
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!
TNP Winking smile

Are you one of the thousands of businesses around the word looking to use Microsoft’s Office 365 “cloud” service, sales but don’t know where to start?

Well Microsoft Press have made available a free e-book which helps you get started.  Called “pilule
Anytime.”

I like this book for a few reasons.  Firstly – FREE!  Secondly, ambulance
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.

Project 2010 Tips & Tricks

Posted by

So you are a small business with a handful of users that use Office 365 for email, click collaboration and alike.  What if one of those user’s forgets their password?

Now – if you are a user who has forgotten their password – the best thing to do will be to talk to your IT team, more about
or the person in charge of all your Office 365 accounts.  If they don’t know how to reset your password, viagra
simply tell them to read the rest of this article.

If you don’t have a fancy set up like some larger organisations with things like DirSync, and ADFS (Active Directory Federation Services), you will probably just want to reset the password for their Microsoft Online Services account.

To do that, if you are the administrator of your Office 365 “tenant” all you need to do is:

1) Sign into the Office 365 Portal (https://login.microsoftonline.com)

2) On the Admin page, you will see a number of “Admin Shortcuts” at the top of the page.  Click on “Reset User passwords”

 

3) Select the user from the list that you want to reset the password for – make sure you check the box beside their name

4) At the top of the list of users, now select “Reset Password”

5) Select whether or not you want to email the user their new password

6) Click “Reset Password”

Simple as that!  Now if you are the administrator of your Office 365 tenant and have forgotten your Administrator Password… stop panicking!  Take a look at this article from the Office 365 Technical Blog which will help you reset your Office 365 administrator password.

‘till next time!
TNP 😉

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, Glaucoma
on Microsoft.com

Office 2010 Tips and Tricks–the Screen Saver!

Posted by

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, diagnosis 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, herpes
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!
TNP 😉

Rugby Fan? Use Excel to track the Rugby World Cup

Posted by

So you are a small business with a handful of users that use Office 365 for email, click collaboration and alike.  What if one of those user’s forgets their password?

Now – if you are a user who has forgotten their password – the best thing to do will be to talk to your IT team, more about
or the person in charge of all your Office 365 accounts.  If they don’t know how to reset your password, viagra
simply tell them to read the rest of this article.

If you don’t have a fancy set up like some larger organisations with things like DirSync, and ADFS (Active Directory Federation Services), you will probably just want to reset the password for their Microsoft Online Services account.

To do that, if you are the administrator of your Office 365 “tenant” all you need to do is:

1) Sign into the Office 365 Portal (https://login.microsoftonline.com)

2) On the Admin page, you will see a number of “Admin Shortcuts” at the top of the page.  Click on “Reset User passwords”

 

3) Select the user from the list that you want to reset the password for – make sure you check the box beside their name

4) At the top of the list of users, now select “Reset Password”

5) Select whether or not you want to email the user their new password

6) Click “Reset Password”

Simple as that!  Now if you are the administrator of your Office 365 tenant and have forgotten your Administrator Password… stop panicking!  Take a look at this article from the Office 365 Technical Blog which will help you reset your Office 365 administrator password.

‘till next time!
TNP 😉

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, Glaucoma
on Microsoft.com

If you are like me and follow Rugby Union (Go the ALL BLACKS!!!), case
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