LJC Webhosting

Website Design in Pembrokeshire

  • Facebook
  • LinkedIn
  • Pinterest
  • RSS
  • Twitter
  • Websites
  • FAQs
  • Tips & Tricks
    • Apple
      • iPad & Apps
      • iPhone
    • CMS
      • WordPress.org
    • Microsoft Office
      • Excel
      • Outlook
      • Word
    • Miscellaneous
      • Browser
      • Email
      • Kindle
      • Skype
    • Social Media
      • Facebook
      • Google+
      • Twitter
    • Windows

Excel chart – fast!

February 24, 2015 Lins Heydon

Column Chart

Select your data. Press F11 on the keyboard and voila! An instant column chart is created on a new worksheet…

Excel, Microsoft Office, Tips & Tricks charts

Transpose Data

February 2, 2015 Lins Heydon

Transpose Data in Excel

This would be useful if you wanted to change the orientation of the display of your data, but really didn’t want to retype it all. Copy all the original data first, find an empty area and click on a cell where you want to begin the copy. Go to Home > Paste > Transpose (you […]

Excel, Microsoft Office, Tips & Tricks

Keep Preceding Noughts

November 3, 2014 Lins Heydon

Excel Preceding Noughts Tip

When an input value starts with zero Excel will delete the zero(s) by default – try adding a single quote mark ahead of the first zero.

Excel, Microsoft Office, Tips & Tricks

Navigating Sheets

May 17, 2013 Lins Heydon

It’s common knowledge and instinctive to click on a different sheet tab in a workbook to activate it.  You can also use the keyboard; press Ctrl-Page Up and Ctrl-Page Down to go up and down the sheets. If your workbook contains a large number of sheets they may not all fit on the screen and it […]

Excel, Microsoft Office, Tips & Tricks

Split full names in single column

April 26, 2013 Lins Heydon

How to split full names (in a single column) out into separate columns. Use functions: =LEFT(B4,FIND(” “,B4,1)-1) =RIGHT(B4,LEN(B4)-FIND(” “,B4,1))

Excel, Microsoft Office, Tips & Tricks

Formula Syntax

February 6, 2013 Lins

Formula Syntax in Excel

Sometimes you might find a quick reminder of the formula syntax useful when working in Excel. If this is the case then type an equal sign followed by the function name and then Ctrl+Shift+A. For Example typing =Sumif and then using the keyboard stroke Ctrl+Shift+A will give you: =Sumif(range,criteria,sum_range). In 2010 you will find Excel […]

Excel, Microsoft Office, Tips & Tricks

Annotations in your formulas

January 30, 2013 Lins

Say six months ago you wrote a formula similar to this: =10000+787-12*299.64. Now you find you just can’t remember what exactly each figure represents. Try writing yourself a reminder about the calculation and add a hidden note to your formula by using the N() function i.e. =10000+787-12*299.64+N(“Loan+Interest-12 months of loan repayments”). The N() function converts […]

Excel, Microsoft Office, Tips & Tricks

Quick Drop-down List in Excel

January 7, 2013 Lins

Do you want to repeat data that’s already been used in the column? To enter Yellow in a new cell in the column Excel will bring it up anyway when simply typing Y – this is because there is only one data entry starting with the letter Y. Conversely if you need to enter Blueish, […]

Excel, Microsoft Office, Tips & Tricks

Quickest way to review a Sum or Average

December 18, 2012 Lins

A quick way to find the sum and average of cells in Excel 2010 is to select adjacent or non-adjacent cells and look in the status bar. Excel displays the average of the numbers, a count of the cells, and the sum.  

Excel, Microsoft Office, Tips & Tricks

Keyboard strokes for AutoSum

December 7, 2012 Lins

The AutoSum tool is already fast, but even quicker just try selecting a cell at the bottom of a column of figures and press Alt+=, which inserts the =Sum() function (just like AutoSum does).

Excel, Microsoft Office, Tips & Tricks

  • 1
  • 2
  • 3
  • Next Page »

Chat

Click the Chat button to get in touch with us now. Chat Icon

Our Details

Registered Office:
Booth House
Llysyfran
Pembrokeshire, SA63 4RS

01437 532 813
Email LJC

Policies & Info

  • FAQs
  • Privacy Policy
  • Terms & Conditions
  • Website Terms & Conditions
  • Contact Us
  • Cookie Policy
  • Hosting Comparisons

Latest WordPress Tip

Automatic background updates were introduced in WordPress 3.7. An email notification is sent (subject line below) following the success or failure of the update. Subject: [Your … [Read More...]

More Posts from this Category

Copyright © 2021 · LJC on Genesis Framework · WordPress · Log in

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.