Excel – Pure and Simple features and so easy to use…

In this week’s, blog we look at some features which have been around a while and some quite new ones.

  1. In you have a formula you want to copy down using the good old fill copy button, simply double left click rather than drag and it will copy down to the bottom of your range
  2. If you want to search for a character in a text string then =search is really useful. E.g. if in cell A1 you have Bill Smith and wish to search the position of the space, then using =search(“ “,a1) will return the value 5 (its position in the string)
  3. A new feature is the QA button which is shown at the bottom right of a selected range of cells. This allows for the quick generation of totals, charts and conditional formatting amongst other features.

See example below

Excel

  1. The Evaluate Formula button on the Formulas Tab allows you to see the way Excel steps through a formula in the correct sequence.
  2. 3 ways to widen are column are
    • Click and drag the column divider
    • Double click the column divider (for auto fit)
    • Right click and choose column width (best used across multiple columns)
  3. Customise your own ribbon (right click on a tab) and drag your favourite buttons on a group in that tab.
  4. Data Validate a text length of a string. Good if codes should always be of a certain length.
  5. Identify Duplicate fields and then Remove the rows. (Conditional Formatting and then Remove Duplicates)

All of these features can be found in our Excel courses that we provide. Click here to take a look at our Agendas for our Excel courses, or if you want to get in touch with a query, email us at johnlegge@jplcomputer.co.uk.

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy