Category Archives: Excel 2007

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 😉

Add, subtract or average time in Excel

Posted by

If you are like me and you want to do some kind of calculation or duration in hours, audiologist minutes and seconds – I am sure you have been very frustrated with Excel totally ignoring what you want to achieve! Well did you know that it isn’t as hard as Excel makes it out to be! You can very quickly do calculations like adding two times together, medicine subtracting times from each other, more about or seeing what the average time is of a range. They key is to ensure that your cells or formatted correctly first. Here is how you do it!

  1. Select the cells that you want to add your times to
  2. Right click, and then select “format cells” from the menu that appears
  3. In the “format cells” dialog box that appears, make sure you are on the “Number” tab
  4. In the category box, select “custom”
  5. Look for a Type in the list which looks like [h]:mm:ss and select it
  6. Click Ok

Now that your numbers are formatted correctly as times, you can start doing your calculations. Simply add, subtract or average like you normally would in excel using formulas like =SUM(), and =AVERAGE()

’till next time!
TNP 😉

Select difficult to get to objects in Word using the Selection Pane

Posted by

Have you ever worked on a document with a lot of shapes, buy diagrams, pictures or text boxes?  Don’t you hate it when they overlap or are on top of each other and it is near on impossible to select the right object!  You may be like me and move the objects on top to get to the ones below … but did you know that there is an easier, much better way?  There is – using the Selection Pane.

The selection pane enables you to select the object by its name, irrespective of where the object is in your document.   Not only that, you can make an object invisible for a short amount of time so you can see everything else underneath it!

To turn on the selection pane in Word:

  1. On the “Home” tab, look for  the “Editing” group on the right hand side of the screen
  2. Click on the little arrow beside “Select”
  3. Select “Selection Pane”

The selection pane will appear as a task pane on the right hand side of your Word screen.  To select an object in your document, simply click on the name of the one you are after.  You can make an object invisible by simply clicking on the “eye”.  To bring it back, click on the “closed eye”.

’till next time!
TNP 😉

Calculate the number of work days between two dates in Excel

Posted by

Ever wondered how many work days there are between two dates?  Maybe you are counting down the number of days you have left in the office before your big holiday?  Maybe you just need to know how many days you have until that project is due?  Whatever the reason, viagra here using Excel you can calculate the number of business days between two dates.

To do so, there we will use the NETWORKDAYS formula.

  1. Type the two dates you want to calculate the number of days betwen into Excel – in one cell type the date you want to calculate from, and the other cell the date you want to calculate to
  2. In another cell, type =NETWORKDAYS(
  3. Select the first cell – if you typed the first date in A1 the formula will now look like =NETWORKDAYS(A1
  4. type a comma
  5. Select the second cell – if you typed the second date in B1 the formular will now look like =NEWWORKDAYS(A1,B1
  6. Type the closing bracket to complete the formula – it will now look like =NETWORKDAYS(A1,B1)
  7. Hit enter!

There you have it, the number of days you need to wait until you go away, or the number of days to countdown until that deadline!

’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 😉

Change a number to a percentage (%) in Excel

Posted by

Have you ever wanted to change a number into a percentage in Excel? The easiest way is to just type the number in and add the % symbol (by holding the shift key and F5), nurse and then hitting enter.  If you want to change a number afterwards into a percentage, search here is what you do:

  1. Click on the cell that you want to turn into a percentage
  2. On the home tab, look for the number group about half way across the ribbon, and then click on the percentage symbol

That’s it?  Well not quite.  You may notice that your percentage may now have a few extra zeros on the end!  Hmm that isn’t right.  That is because Excel knows percentages to be a fraction of a single whole number.  For example if your number was 34, and you did the above procedure, the cell would now look like 3400%.  Excel thought that 34 meant 34 times, or 3400%.

To fix it up, click on the cell and delete the two extra zeros from the cell.

To avoid it happening in the future, just remember that you need to use the decimal point when you type numbers in.  For example, 0.34 (which equals 34%), instead of 34 (which equals 3400%).

It may seem a little complex at first, but once you start playing around with percentages in your spreadsheet you will pick it up very quickly!

’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 😉

What is the annoying Yellow Bar in Word, Excel or PowerPoint?

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.

Don’t you hate when you are typing an email address into an email you are sending, stuff
and you accidently add the wrong one!  Maybe there are two people you have emailed before.  Both with the same first name, rehabilitation
and similar surnames.  But one is your boss, salve
and the other is your best friend. 

You don’t want to accidently send your boss those pictures from the weekend right!!??!?!?!

That feature, where the names automatically pop us is called “Auto Complete”.  It is a handy feature if you email people regularly, but can cause you problems if you are not careful.

So – if you want to delete a name form your Auto Complete list in Outlook 2010… what do you do?

Simple!

Just start typing their name in.  When it appears in the auto complete list, simply look to the right of their name.  You should see a cross or a check – ie a delete button.  Just click on that, and that name and email address is removed from your auto complete list.

Easy!

‘till next time!
TNP 😉

One of my favourite things about Office 365 is that by using the SharePoint Online functionality that comes with it, remedy you can quickly create a secure extranet to share documents, medications
collaborate, adiposity
and communicate with people outside your organisation.

In fact, depending on the Office 365 plan you are on, you can invite up to 50 people who are not on your Office 365 environment to participate!

Not only that, the best part is that it only takes a couple of minutes to set up, and once you have, it is even faster next time you want to create another extranet (maybe for another customer or supplier)

So how do you do it?

1) Go to the Office 365 Admin Portal (portal.microsoftonline.com, and click on “Admin”)

2) Click on “Manage SharePoint”

3) Click on “Manage Site Collections

4) Click on “Settings”

5) Click “Manage External Users”

6) Click “Allow” and “Save”

7) Go to the site collection (the site that will be your extranet) then click “Site Actions”

8) "Click “Site Settings”

9) Look for “Site Collection Administration” and click on “Site Collection Features”

10) Look for “External User Invitations” and click “Activate” (if it isn’t activated already)

11) Go to the site you want to share, click “Site Settings”

12) Click “Share Site”

13) Type in the email addresses of the folk that you want to invite to participate in your new Office 365 / SharePoint Online extranet!!!!

Now one thing that you should note is that at the time of writing this article, your external parties need to use a Hotmail ID, or a Microsoft Online Services ID to log into your extranet.  In the future you should be able to use any email address which will make it even easier.

So there you have it – a fully functioning, secure extranet in just minutes using Office 365!  How good is that!!!!

‘till next time!
TNP 😉

Are you considering moving your business to Office 365?  Well the www.office365.com website does a good job of explaining at a high level what you get for your dollar – but for some of us that isn’t enough information.

What if you want to get down to the fine detail before making a decision to go to Office 365?

Well luckily Microsoft have published what the call “Service Descriptions”.  These documents outline exactly what you get, implant
explain the differences between all the plans, there and ultimately help you decide what plan is right for you.

The Office 365 for Enterprise Service Descriptions include:

  • Microsoft Exchange Online Archiving Service Description
  • Microsoft Exchange Online for Enterprises Service Description
  • Microsoft Lync Online for Enterprises Service Description
  • Microsoft Office Professional Plus Service Description
  • Microsoft Office Web Apps Service Description
  • Microsoft SharePoint Online for Enterprises Service Description
  • Office 365 for Enterprises Service Description
  • Office 365 Identity Service Description
  • Office 365 Mobility Service Description
  • Office 365 Security and Service Continuity Service Description
  • Office 365 Support for Apple Mac and iOS Devices

You can find all the information here.

‘till next time!
TNP 😉

Are you working on a PowerPoint presentation and want to insert a new slide?  By default, drugs
chances are you will get a slide which has a title at the top, refractionist
and a big box below that in which you can add your bullet points.

The default layout is what we call “Title and Content”, nurse but there are many others you can choose from.  For example:

  • Title Slide (the first slide you see when you create a new presentation)
  • Section Header
  • Two Content
  • Comparison
  • Title Only
  • Blank
  • Content with Caption
  • Picture with Caption

To create a new slide with one of these layouts, simply click on the bottom half of the “New Slide” button on the “Home” tab in PowerPoint.

A small menu will appear with pictures of what each layout looks like.  Simply click on the layout you like and it will be inserted into your document.

Now if you want to change the layout of an existing slide:

1) Click on the slide that you want to change

2) On the “Home” tab, just to the right of the new slide button you will see one called “Layout” – click on that

3) From the menu that appears, select the layout that you want

Now your presentation will have a bit of variety!

‘till next time!
TNP 😉
Are you working on a PowerPoint presentation and want to insert a new slide?  By default, side effects
chances are you will get a slide which has a title at the top, and a big box below that in which you can add your bullet points.

The default layout is what we call “Title and Content”, but there are many others you can choose from.  For example:

  • Title Slide (the first slide you see when you create a new presentation)
  • Section Header
  • Two Content
  • Comparison
  • Title Only
  • Blank
  • Content with Caption
  • Picture with Caption

To create a new slide with one of these layouts, simply click on the bottom half of the “New Slide” button on the “Home” tab in PowerPoint.

A small menu will appear with pictures of what each layout looks like.  Simply click on the layout you like and it will be inserted into your document.

Now if you want to change the layout of an existing slide:

1) Click on the slide that you want to change

2) On the “Home” tab, just to the right of the new slide button you will see one called “Layout” – click on that

3) From the menu that appears, select the layout that you want

Now your presentation will have a bit of variety!

‘till next time!
TNP 😉

Do you need to create some simple business cards?  Well it isn’t all that hard using Microsoft Word, ampoule
and some of the templates available at www.Office.com.

In fact, sick one of the Microsoft team have put together a great video showing you exactly how easy it is.

Watch the video by Doug Thomas over at the Office Casual Blog – and you too can create a simple business card in just 90 seconds!

WOW – that is quick!

‘till next time!
TNP 😉

If you have been using Microsoft Office 2007 or 2010 for a while, click you might have come across what most people call the “Annoying Yellow Bar”

If you don’t know what I am talking about – open up a word document that someone has send you via email – or a spread sheet that you might find on a website.  Chances are when you open that Word, store
Excel or PowerPoint file, you will see the “Annoying Yellow Bar” – and you will not be able to edit, print, or save your document.

Well it may be annoying, but it is actually really important.  The yellow bar shows you that Word, Excel or PowerPoint is running in what we call “Protected Mode”.  Any time you open a file that isn’t on your computer, or from somewhere that you can’t trust (like the internet), the document will be opened in protected mode, to (as the name suggests) protect your computer from harm.

It opens up the document so you can take a look at it, and then if you are sure it is what you are looking for, and you trust that it will not do any harm, you can then click on the “Enable Editing” button, which sits on the yellow protected view bar.

Now there are ways to stop Protected View from happening, but trust me, it is worth putting up with because if you accidently open a document that causes damage to your computer, it is a LOT more annoying!

‘till next time!
TNP 😉