Skip to the content
STL - Blog
Best in-class training – Be delighted, not just satisfied
  • STL Home
  • Blog home
  • Professional & Management
    • Leadership Development
    • Management Training
    • Professional Development
    • Project Management
    • Sales & Customer Service
    • Soft Skills
  • Application
    • Artificial Intelligence
    • Hints & Tips
    • Microsoft Office
      • Access
      • Copilot
      • Excel
      • Excel Data Visualisation
      • MS Project
      • Office 365
      • Outlook
      • PowerPoint
      • VBA
      • Visio
      • Word
    • Microsoft Office Resources
    • Power BI
  • Misc
    • Infographic
    • Technology
    • Fun
    • Company News
  • About us
  • Contact us
  • STL Home
  • Blog home
  • Professional & Management
    • Leadership Development
    • Management Training
    • Professional Development
    • Project Management
    • Sales & Customer Service
    • Soft Skills
  • Application
    • Artificial Intelligence
    • Hints & Tips
    • Microsoft Office
      • Access
      • Copilot
      • Excel
      • Excel Data Visualisation
      • MS Project
      • Office 365
      • Outlook
      • PowerPoint
      • VBA
      • Visio
      • Word
    • Microsoft Office Resources
    • Power BI
  • Misc
    • Infographic
    • Technology
    • Fun
    • Company News
  • About us
  • Contact us

Excel Training Resources

Explore in-depth tutorials and strategies for data management, analysis, and visualisation using Microsoft Excel.

  • Show Formulas in Excel

    Tue 21 Apr 2015

    Make sense of someone else’s workbook When you are given a workbook that has already been created it can be hard to work out which cells contain manually entered values and which cells are the result of formulas. So how do you show formulas in Excel? Below is an example workbook, at first glance it’s not easy […]

  • BODMAS Using Brackets

    Tue 14 Apr 2015

    Save yourself from errors with the BODMAS rule A question we often hear is “Why do we need to put Brackets in Excel Formulas?” Some formulas that you use won’t need brackets. If you write the formula =5+2+10, It will calculate the result as 17. There were no brackets in that formula, and it still […]

  • Remove Duplicates in Excel

    Tue 31 Mar 2015

    How to remove duplicates from a column of data in Excel It’s not uncommon when adding or importing records that you may need to remove duplicates in Excel. Whilst filtering and deleting records to make a list of unique items is an effective solution, there is an even easier way. Simply follow these steps to remove duplicates […]

  • SpecialCells in VBA

    How to use SpecialCells method in Excel VBA SpecialCells in VBA is a really useful method to deploy in Excel. It returns a Range Object that only covers the type of cells you specify. You can use the SpecialCells in VBA Method to return a Range Object that only holds numbers, text, blank cells, formulae, cells with […]

  • Count and CountA in Excel

    What’s the difference between Count and CountA in Excel? The Count function is one of the 400 functions in Excel. Count as the name suggests, counts the number of cells selected that contain numbers. You can use the Count function to obtain the number of values within a range, rather than the total of those values. If we wanted to count the […]

  • How to Delete Blank Rows in Excel

    Mon 23 Mar 2015

    Quickly and easily delete blank rows and columns in Excel It’s not uncommon to end up with blank cells or rows in an Excel worksheet. If you need to delete these to maintain accuracy, especially when calculating the average value, the quick way is to filter out all blank cells / rows and delete them […]

  • Using the Advanced Filter in Excel

    Tue 17 Mar 2015

    Refine your filter options with the Advanced Filter in Excel For most filtering of data Excel AutoFilter is perfectly adequate. Here we’ll look at some benefits for moving beyond the AutoFilter by using the advanced filter in Excel. A Recap of AutoFilter Benefits For ease of use, it’s hard to beat the Excel AutoFilter feature. Just click […]

  • How to change case text in Excel

    Mon 9 Mar 2015

    Quick and easy ways to change case text in Excel. You may have a list which you wish to change the case test in Excel. Rather than manually re-entering the data in Excel, there are some useful functions you can call on to save you this work. Let’s look at a few of them. In […]

  • Excel VLOOKUP and HLOOKUP Functions

    Tue 3 Mar 2015

    A comprehensive guide to these powerful functions in Excel The LOOKUP functions can be used to look up data in an Excel list or Excel database, saving a lot of time and potential error when comparing two lists of data. You have two LOOKUP functions, Excel VLOOKUP and the HLOOKUP. The only difference between the two functions is that the VLOOKUP  is used for […]

  • The Excel Status Bar

    Mon 23 Feb 2015

    Discover some useful options available in the Excel status bar The Excel status bar, which is located at the bottom right side of the Excel screen, is an often overlooked but informative feature in Excel. For example say you wanted to find the total, or average of a selection of cells, the status bar is quickest place to […]

  • Using Subtotal in Excel

    Tue 17 Feb 2015

    Summarise data quickly by using Subtotal Excel’s subtotal feature provides a quick and easy way of summarising tabular data.  A common use of the feature is to display only the totals for different categories. For example suppose you want to calculate and display only the total units for each product from data (partly shown below) Step 1 Sort the data by the Product field. Click inside the […]

  • Using the Concatenate Function in Excel

    Tue 10 Feb 2015

    The concatenate function quickly links the content of two or more cells The concatenate function in Excel allows you to join text strings from different cells (like first name and last name) which can be very useful. It can be used with a number of other Excel functions. You can concatenate in Excel by using the Concatenate function […]

  • Pie Chart Segment

    Tue 3 Feb 2015

    Pull out a segment in an Excel pie chart Pie charts are great for visually showing categories. Occasionally we might want to emphasise a segment. To do this, we can pull out a pie chart segment! 1 – Create a Pie Chart Start by selecting your data, going to the Insert tab along the Ribbon […]

  • 15 Excel Keyboard Shortcuts worth knowing

    Mon 26 Jan 2015

    Save hours in Excel: spend a few minutes learning these shortcuts Keyboard shortcuts are great time-savers; allowing you to shave seconds off a task, but ultimately saving hours in the long run. This is especially true when you are working with Excel.  There are over 200 Excel keyboard shortcuts that you can use, here we have selected 15 […]

  • Definitive Guide to Excel Shortcuts

    The Definitive Guide to Excel Keyboard Shortcuts Keyboard shortcuts can be a real productivity booster, here’s a comprehensive list to serve almost any situation that arises in Excel. CTRL combination Excel shortcut keys Key Description CTRL+SHIFT+( Unhides any hidden rows within the selection. CTRL+SHIFT+) Unhides any hidden columns within the selection. CTRL+SHIFT+& Applies the outline border to […]

  • How to view two Excel worksheets side-by-side

    Mon 19 Jan 2015

    Save time and reduce errors by viewing two or more worksheets at the same time It’s not uncommon to end up jumping between different Excel worksheets/workbooks because you are comparing data, copying & pasting or even creating links. This back and forth process takes up time and can increase the risk of error. Well there is a […]

  • How to freeze panes in Excel

    Tue 6 Jan 2015

    Save hours and eyesore by using freeze panes in Excel Reviewing data in spreadsheets can be very demanding on the eyes and time consuming when you are trying to remember what a particular column or row of data actually is! If you’re not already familiar with how to freeze panes in Excel, read on and […]

  • Create a drop-down list in Excel

    Wed 10 Dec 2014

    Save time by avoiding repetition and errors Excel is great for lists; sales figures, staff rota’s, stock control, to name a few. But an easy trap to fall into is repetitive error prone data-entry that leads to inaccurate business reporting and lost time in troubleshooting. If you create a drop-down list in Excel, you can avoid […]

  • How to share files in Excel

    Fri 28 Nov 2014

    Improve collaboration and save time It is not uncommon with Excel to have multiple people requiring access to the same file. Whether the file in question is a sales report, marketing budget, or time-sheet for example. This is where the Share Workbook feature in Excel comes in handy, here we’ll look at how to share files […]

  • How To Split A Stacked Chart In Excel

    Mon 24 Nov 2014

    How to create AND split a stacked chart in Excel Amongst the many charts available in Excel, some of the most popular are column charts, and the main variants being clustered and stacked. We’ll look at how to split a stacked chart in Excel, and to do this let’s start by creating a basic column […]

  • Using the Total cell style in Excel

    Tue 18 Nov 2014

    Trying to review a spreadsheet with unformatted data can be a real eye sore, but by using the Total cell style in Excel you can quickly give your data more context. An example of using the Total cell style in Excel Below we have a list of sales figures for several sales reps in a travel […]

  • How to calculate age from date of birth using Excel

    An easy way on how to calculate the age from date of birth using Excel formula Here we’ll look at how using the Today() function along with a less well known function, Datedif(), calculates the age from a date of birth. Even if this isn’t a pressing need of yours the example below is a handy […]

  • Excel VBA Uppercase, Lowercase and more

    Thu 15 May 2014

    Ever received a spreadsheet and all the data on it is in the wrong case? You might received a dodgy dump of data from your website or database, or maybe the user-inputted data is poorly or inconsistently formatted. Here I’ll guide you through how to do Excel VBA Uppercase, lowercase and capitalising the first letter […]

  • How do I sort in Excel VBA?

    Tue 13 May 2014

    Excel VBA is used for all sorts (!) of data manipulation tasks. One of the most common is sorting your data. Performing an Excel VBA sort seems trivial but some parts of it may misbehave if you’re not diligent. I’ve seen some people try to write their own sort routine in Excel VBA, but frankly […]

  • How to use a VLOOKUP function in Excel VBA

    Fri 9 May 2014

    VLOOKUP is one of the most useful and versatile functions in Excel. As you work further with macros it’s not uncommon to make your create an Excel VBA VLOOKUP macro. With this you get the ability to reference your tables of data, but automated. Wait, what’s a VLOOKUP function? The Vertical Lookup is one of […]

  • Could a single spreadsheet bankrupt your business?

    Tue 6 May 2014

    That’s not a headline designed just to capture your attention. It’s a very real possibility. Spreadsheets can be powerful. They’re full of functionality yet easy to use. Everyone can create and use a spreadsheet without much in the way of training. But all those benefits are also the dangers. Spreadsheets weren’t designed to carry the […]

  • Pull Data, Not Teeth – The PivotTable Edition

    Wed 17 Jul 2013

    In life as in business, we always strive to find the easiest ways of getting things done. Sometimes, however, the simplest methods involve cutting corners, obtaining short-term results but long-term headaches. One of a long line of Excel features, the PivotTable is the best way to break your information down into more manageable chunks. In […]

  • Excel 2013: Use Timelines With PivotTable Data – MS Excel Training

    Fri 24 May 2013

    See the timing of trends in your Excel 2013 PivotTable data with the new timeline feature. By default the data is split into months, though manipulation allows you to break this down into weeks, quarters, years or even days if you prefer. If you make user of Slicers in your PivotTables and PivotCharts, you will […]

  • Excel 2013: 3 New Ways To Customise Your Charts

    Tue 21 May 2013

    Whether you’ve decided to use a suggested chart to represent your data or already knew which one works best from the outset, a new toolbar in Excel 2013 allow you to customise your visualisation quicker. Selecting the chart will automatically reveal two tool ribbons: Design & Format, both specifically designed to help you manipulate your […]

  • Excel Training 2013: Sparklines through Quick Analysis

    Thu 2 May 2013

    Introduced in Excel 2010, Sparklines create charts within a cell. It can help to show one figure in context with others and illustrate trends. In this example a blank column is created for the sparklines before selecting the adjacent data. In Excel 2013 the Quick Analysis feature has now brought Sparklines to the fore. Perfect […]

  • Excel : Audit your Spreadsheet with the Inquire Add-In

    Thu 25 Apr 2013

    For users with the Office Professional Plus package, the Inquire add-in comes pre-installed on Excel 2013. Helping you to analyse, audit and review workbooks, this great new feature also has the potential to highlight errors and security concerns. We recently discussed, how to take back control of your spreadsheets by reducing “fat finger mistakes” and […]

  • Excel 2013: Complete data entry quickly with Flash Fill

    Fri 19 Apr 2013

    Save time and effort with Flash Fill for Excel 2013. Just one in a long line of nifty improvements to help you work more efficiently. Flash Fill for Excel 2013 notices patterns in your data entry and then auto completes the remaining, so there’s no need to use formulas or macros to do this. Data […]

  • Microsoft Excel Course 2013: Suggested Charts through Quick Analysis –

    Thu 18 Apr 2013

    So many times people pick the wrong chart type for their data. There’s a time and a place for pies, and lines aren’t for everyone. Picking the right one takes a bit of thought. The Charts option in the Quick Analysis gallery, a new feature for Excel 2013, allows the user to quickly view and […]

  • Excel 2013: Conditional Formatting through Quick Analysis

    If you’ve got a lot of data, it’s not always easy to spot trends and to easily analyse your figures. Conditional Formatting can instantly show you patterns in your data by highlighting cells that meet certain conditions. So for example you might want to flag up sales below a certain threshold in red, or bold occurrences of […]

  • Get back control of your Excel spreadsheets

    Mon 15 Apr 2013

    Poor Excel skills are costing UK businesses millions in lost revenue. According to an article in the Financial Times more than half of financial service groups have “poorly applied or no controls for managing business critical spreadsheets”. The article blamed losses in part due to “avoidable errors in MS spreadsheets”. So, what could thousands of UK […]

  • How Excel can help you build a successful SEO campaign

    Thu 14 Feb 2013

    It’s important to stay ahead of the game and decent spreadsheet software such as Microsoft Excel is still regarded as one of the most empowering and flexible ways to track your SEO campaigns. In conjunction with important tools such as Google Analytics & Keyword Tools, Excel is able to help provide unrivalled analysis to aid […]

  • Learn Excel London: How To Display Unique Entries in an Excel List

    Tue 12 Feb 2013

    I used to work with a colleague who maintained a postal mailing list for a brochure we would send out. He used to spend some of his time cleaning up that list by removing repeat entries of customer email addresses who had signed up more than once. “De-duping” he called it. He would block out […]

  • Page Break Preview in Excel 2010

    Thu 24 Jan 2013

    Printing out Excel spreadsheets can be frustrating. Often you end up with one piece of paper with only one column of data on! If you are printing a spreadsheet that will take up more than one page, you have the ability to control were the page breaks. To do this you need to be in […]

  • Zooming in on your Excel document – using views (and save squinting)

    Wed 5 Dec 2012

    I even like the sound of it “zoom control”…I was so used to working in whatever view is set up, and then scrolling across endlessly to find the data I wanted to view…and if that didn’t work…I squinted. But I don’t have to.  I discovered Zoooom control.  I can access it using the Zoom control […]

  • How to recover unsaved work in Excel

    Minor panic yesterday…I’d worked on an Excel file and quite possibly (you can take that as a yes) I hadn’t saved the changes.  I was a bit distracted at the time and seemed to have forgotten the basic Save. Excel is very forgiving like this.  It has a way that you can recover unsaved work. […]

  • Use the Error checker tool in Excel

    Error checking is part of Excel’s auditing tools.  It is set up to check your formulas for errors. Like spellcheck, the Error checker tool won’t necessarily find all errors, but it is a useful auditing tool as it works through your document to flag up the errors it spots. In the Formula tab, you have […]

  • Add an email hyperlink to an Excel Worksheet

    Hyperlinks can add links to an Outlook email address to your Excel worksheet.  Here is how to do it. In the cell you wish to add the email address, go to the Insert tab, and select the hyperlink button Type your preferred text into the cell (this saves space as email address are long).  This […]

  • How to separate names in Excel contact lists for mailmerges

    Tue 4 Dec 2012

    If you use mailmerge in Word, often the source of contact details comes from Excel.  And there are times when you inherit contact details from another project or colleague, and the names may not be separated. This can be a heart-sink moment as you need to separate each name individually.  Argh…this is going to take […]

  • Protecting Excel 2010 documents – options available.

    Mon 3 Dec 2012

    When you have worked hard to set up and create an Excel workbook, which may include 3D formulas, pivot tables and links to other key worksheets, you will want to protect your work from unwanted changes. Excel allows you to protect your worksheets work and allow editing It isn’t just about stopping people from making changes to […]

  • How to save an Excel worksheet as a pdf file

    PDF makes a document read only.  This can be useful when you want to share information with colleagues, but don’t want them to have access to formulas or make changes to your document.  It is one of several ways you can use to protect your Excel documents. To save your current Excel worksheet as a […]

  • What is a pivot table?

    It is possible to use Excel for data entry and miss out some of the tools that can make analysing and summarising data easy-peasy. For me, this was Pivot tables.  I avoided Pivot tables because a) I didn’t know what they were and  b) I thought it would be too difficult to use as they […]

  • Spellcheck in Excel and other proofing tools in the Reviews tab

    Mon 26 Nov 2012

    For that professional edge it is really worth using Excel’s proofing tools to make sure that your worksheets are accurate. With more teams sharing Excel documents, adding comments and making changes, you need effective ways to track changes, check for duplicates and ensure that your business works with the most up to date and accurate […]

  • Using SumIF to add up specified values in Excel

    Part of the process of learning about Excel is overcoming the fear of new terminology, especially when it is linked to functions. Today’s term is SumIF.  I use Autosum all the time, so why would I need to use SumIF? Well, Autosum adds up every cell that I select in a row or column. Great […]

  • How to add a percentage increase to a monthly target in Excel

    Sun 25 Nov 2012

    In this example, I am looking at how to add a percentage increase to calculate a monthly projected fundraising target. Imagine my team is fundraising for a new community centre. In the last month they raised £76,000. I’d like to increase the total per month, but not put them off, so I want to add […]

  • How to calculate percentage reduction using Excel formulas

    One of the many things I like about Excel is that I can set up the formula in one cell and copy it to other cells. If I want to apply a percentage reduction to a figure, I can set it up for the first line of data and then autofill the relevant cells.  With […]


Posts pagination

← Newer Posts 1 2 3 … 5 Older Posts →
216 posts in this category.

Excel category RSS

 

Training courses

Blog Categories

Consent preferences

TrustPilot Score

TrustScore 4.9   |   2367 reviews

TrustPilot Testimonials

Trustpilot

© 2025 STL – Blog

Powered by WordPress

To the top ↑ Up ↑