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

Outlook Shortcuts

July 5, 2015 Lins Heydon

Outlook Copy and Paste Shortcut

These shortcuts tips are for desktop Outlook client, which often comes as part of the Microsoft Office suite. I was inspired to write this post when I came across a useful shortcut I wasn’t aware of.  You can save time and clicks when wanting to copy text straight into an Outlook item.  To do this […]

Email, Microsoft Office, Outlook, Tips & Tricks

Go Back

May 20, 2015 Lins Heydon

Go Back

There is a great and pretty handy little ‘Go Back’ shortcut in Word. To illustrate its potential use: if you’re working away on page 4, then move to page 23 to copy some text ‘Go Back’ can return you to the previous editing location (page 4) quickly. Simply press… Shift+F5 This keystroke will cycle through your […]

Microsoft Office, Tips & Tricks, Word

Readability Statistics

March 20, 2015 Lins Heydon

Readability Statistics

Enabling Readability Statistics in Word 2010, to evaluate the writing’s complexity. This can be useful if you are writing a document aimed toward a particular level of audience, for example either the comprehension level of undergraduates or an average 11 year old.  For reading ease in most documents you’ll want to aim between a score […]

Microsoft Office, Tips & Tricks, Word

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

Page Numbering

March 21, 2013 Lins Heydon

To insert Page Number click the Insert tab.  In the Header & Footer group click Page Number.  Select position of page number (Top of Page = Header, Bottom of Page = Footer, Page Margins = left or right and Current Position = at your current cursor point).  Once position has been selected you will see various options […]

Microsoft Office, Tips & Tricks, Word

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

  • 1
  • 2
  • 3
  • …
  • 6
  • 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