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

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

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 © 2022 · LJC on Genesis Framework · WordPress · Log in

We use cookies to ensure that we give you the best experience on our website. By clicking “Accept All”, you consent to the use of ALL the cookies. However you may visit Cookie Settings to provide a controlled consent. Read More
COOKIE SETTINGS ACCEPT ALL
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.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
CookieDurationDescription
bcookie2 yearsThis cookie is set by linkedIn. The purpose of the cookie is to enable LinkedIn functionalities on the page.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
CookieDurationDescription
_gat1 minuteThis cookies is installed by Google Universal Analytics to throttle the request rate to limit the colllection of data on high traffic sites.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
CookieDurationDescription
_ga2 yearsThis cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, campaign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assign a randomly generated number to identify unique visitors.
_gid1 dayThis cookie is installed by Google Analytics. The cookie is used to store information of how visitors use a website and helps in creating an analytics report of how the wbsite is doing. The data collected including the number visitors, the source where they have come from, and the pages viisted in an anonymous form.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
CookieDurationDescription
bscookie2 yearsThis cookie is a browser ID cookie set by Linked share Buttons and ad tags.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
CookieDurationDescription
cookielawinfo-checkbox-functional1 yearThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-others1 yearNo description
li_gc2 yearsNo description
SAVE & ACCEPT
Powered by CookieYes Logo