The Excel Expert
  • Welcome to the Excel Expert
  • Blog
  • Books for sale
    • Your Excel Survival Kit
      • Get the e-book plus bonuses here!
      • Buy on Amazon.co.uk
      • Buy on Amazon.com
      • Create Great Reports in Excel
      • Create Great Reports in Word
    • Get and Transform your data
  • Products for Sale
  • Free Webinars
  • Testimonials
  • About
    • Resources
    • About
    • Privacy Policy
    • Terms of Use
  • Contact
Select Page

07 – Get your list to answer a question – cool filtering..

by admin | Jan 11, 2017 | Excel - From The Beginning, Excel Lists | List basics, Excel Lists | Sorting and Filtering

This is my first blog post of 2017. I have to say I do love the energy of a new year. My favourite time of the year are those days between the “two Christmases” i.e. 25th December and 6th January. There is no pressure. Just movies to be watched, sweets to...

Quickly format, filter and formulate your list | Using Tables in Excel

by admin | Jul 3, 2013 | Excel Lists | List basics, Excel Lists | Sorting and Filtering, Excel | General

 Tables in Excel One of my new favourite features in the “new” Excel is Tables. When you convert your list to a table you quickly do the following: Apply slick formatting  Apply filters Enter a formula once and see it whiz down the rest of the column...

REMOVE BLANK ROWS IN EXCEL

by admin | Jun 14, 2012 | Excel Lists | List basics, Excel Lists | Sorting and Filtering

In this tutorial we are going to look at how to quickly delete blank rows in Excel. This technique is useful if you have a large list with many blank rows to remove. It works equally well if you need to delete blank columns. The tutorial given below shows you how to...

SORTING IN EXCEL | EXCEL SORT

by admin | May 14, 2012 | Excel Lists | List basics, Excel Lists | Sorting and Filtering

  Welcome to this post about sorting in Excel. This tutorial refers to Excel 2007/2010 and later. A couple of things about sorting before you start. The whole experience will be pretty painless if you tidy up your list to make sure you have the following:...

HOW TO FILTER IN EXCEL | FIND DATA IN YOUR LIST

by admin | May 14, 2012 | Excel Lists | List basics, Excel Lists | Sorting and Filtering

Excel Filter If you are using a list in Excel, a key skill to have is the ability to filter. Filtering allows you to extract records that meets certain criteria out of your list, so for example if you wanted to find all the transactions you had with a particular...

Excel shortcut keys – FREE

Recent Posts

  • Cleaning up emails
  • Calculating a Location Allowance – with conditions
  • Creating a Dashboard in Excel
  • 11 – How to freeze top row of large data set – View | Freeze Panes
  • Remove unwanted spaces using Trim() and combine multiple entries – 3 ways

Categories

  • Excel – From The Beginning
  • Excel Formulas | Essential formulas
  • Excel Formulas | Essential Functions
  • Excel Functions | Useful
  • Excel Lists | List basics
  • Excel Lists | Sorting and Filtering
  • Excel Pivot tables | Introduction
  • Excel | Advanced Lessons
  • Excel | Case Studies
  • Excel | Conditional Formatting
  • Excel | Excel Beginner Lessons
  • Excel | Excel for Small business
  • Excel | General
  • Excel | Intermediate Lessons
  • Excel | Useful tricks
  • Personal
  • Powerpivot 2010
  • Training Records Management
  • Using Excel for tracking training

Like Excel Expert on Facebook

Recent Posts

  • Cleaning up emails
  • Calculating a Location Allowance – with conditions
  • Creating a Dashboard in Excel
  • 11 – How to freeze top row of large data set – View | Freeze Panes
  • Remove unwanted spaces using Trim() and combine multiple entries – 3 ways

Like Excel Expert on Facebook

  • Resources
  • Welcome to the Excel Expert
  • About
  • Blog
  • Contact
® 2019. All Rights Reserved