Learn Excel Online – how we teach and some Excel tips

Excel is a very useful Microsoft Office package in more ways than one! It is one of the most used packages in lots of businesses but also for people at home in personal use too. With it being so versatile, it is important to learn more about it to have a greater understanding for applying it in work and a home.

Nowadays a lot of people want to learn Excel online, but you can also still learn it in a classroom based environment. This is the main way in which we carry out all of our courses. However, we do also offer a self teach method of learning which combines together our way of teaching with a ‘more online’ medium.

Some Excel Tips:

  1. Quickest way to create a chart sheet is to select the range of cells you want to make a chart from and press F11
  2. To select a whole worksheet worth of data, you select cell A1 and then Control+Shift+End
  3. Sparklines are really simple ‘charts in a cell’. Select a cell and then insert Sparklines and select your range
  4. Use Pivot Table slicer for easy filtering on your PT data

Our selected tip in more detail is – Custom List Sorting in Excel

Most people are used to sorting in Excel alphabetically or numerically but did you know you can sort by your own Custom List Sort Sequence too? Create a Custom Sort List of data either in the Excel Options screen or when you go into the Data Sort command and change the order to Custom List. Typing a comma separates your list of data and then you can add it to the existing lists. An example would be counties in the UK sorted geographically from north to south.

For more info about what we do and other tips see our web site www.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