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

Using Vlookup for populating a scientific taxonomy list or channelling my inner Attenborough

by admin | Feb 10, 2014 | Excel Formulas | Essential Functions, Excel | General

I recently got asked to help with setting up a formula that would autofill standard entries for particular species. The idea would be that the user would enter a species name and then the other details would fill in as normal. While the example I’ve given here...

EXCEL IF OR STATEMENTS

by admin | Aug 2, 2012 | Excel Formulas | Essential Functions, Excel | Intermediate Lessons

In a previous blog posting, I showed you how to set up an If statement in Excel. In this blog posting, I am going to show you how to nest an OR function into an IF function (the technique can be used equally well with a NOT, AND, TRUE, FALSE functions). Essentially...

EXCEL MIN FUNCTION – FINDING THE LOWEST VALUE IN A LIST

by admin | May 3, 2012 | Excel Formulas | Essential Functions, Excel | Excel Beginner Lessons

Excel min In this post we are going to look at the min function (which finds the lowest value in a list)   Please enable JavaScript LinkEmbedCopy and paste this HTML code into your webpage to embed.     As always, here is a file you can practise with ...

COUNT TEXT IN EXCEL – USING THE COUNTA FUNCTION

by admin | May 2, 2012 | Excel Formulas | Essential Functions, Excel | Excel Beginner Lessons

Excel count text If we want to count the number of names (or list of entries with mixed text and numbers), the count function will not work – simply because it is designed to count NUMBERS only. In this case we have to use the CountA function. See video below...

EXCEL COUNT FUNCTION – COUNTING THE NUMBER OF NUMBERS IN A LIST

by admin | May 2, 2012 | Excel Formulas | Essential Functions, Excel | Excel Beginner Lessons

Excel count function This post will show you how to use the Count function. The count function counts the number of items in a list. Unlike the Sum function (which adds up the numbers), the count function tells you HOW MANY NUMBERS  in a list. If you want to count the...

AVERAGE FUNCTION IN EXCEL

by admin | May 2, 2012 | Excel Formulas | Essential Functions, Excel | Excel Beginner Lessons

Average function in Excel (2007/2010)   In this post we are going to look at calculating the average in Excel (using the excel average function)   Please enable JavaScript LinkEmbedCopy and paste this HTML code into your webpage to embed.   As always...
« Older Entries

Excel shortcut keys – FREE

Recent Posts

  • Identify non-attendance from a list of Zoom emails
  • 02 – Excel formulas – adding up numbers and dates
  • Simple Vaccination timetable
  • 01 – Starting Excel from the beginning
  • My 21 for 2021

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

Like Excel Expert on Facebook

Recent Posts

  • Identify non-attendance from a list of Zoom emails
  • 02 – Excel formulas – adding up numbers and dates
  • Simple Vaccination timetable
  • 01 – Starting Excel from the beginning
  • My 21 for 2021

Like Excel Expert on Facebook

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