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

HOW TO SUBTRACT IN EXCEL

by admin | May 31, 2012 | Excel Formulas | Essential formulas, Excel | Excel Beginner Lessons

Subtraction in Excel In this post we are going to learn how to subtract numbers from each other in Excel. Again, the key steps to remember are: Click where you want the answer to go Type in = (that tells Excel you are entering a formula) Click on the cell you want to...

04 – HOW TO MULTIPLY IN EXCEL

by admin | May 29, 2012 | Excel Formulas | Essential formulas, Excel | Excel Beginner Lessons

Multiply in Excel In this tutorial we are going to look at how to multiply in Excel. There are a couple of basic guidelines you should follow when you are using formulas in Excel. As always there is a practice file at the end that you can try out. One number per cell...

05 – FIXING A CELL AKA ABSOLUTE CELL REFERENCE

by admin | May 17, 2012 | Excel Formulas | Essential formulas, Excel | Excel Beginner Lessons

Fixing a cell in Excel – Absolute Cell Reference Sometimes we want to use the same cell over and over in Excel. The way we do that is by creating an absolute cell reference. You may have come across it already when you have seen dollar signs ($) in formulas. In...

EXCEL FOR BEGINNERS | HOW TO FIX A COLUMN IN EXCEL

by admin | May 17, 2012 | Excel Formulas | Essential formulas, Excel | Excel Beginner Lessons

Fixing a column in Excel Sometimes we need to be able to use the contents of a column over and over again in our formulas. In order to do this easily we need to fix the column. In other posts, I have shown you how to fix a cell and also how to fix a row Excel Products...

FIX ROW IN EXCEL

by admin | May 17, 2012 | Excel Formulas | Essential formulas, Excel | Excel Beginner Lessons

How to fix/lock a reference to a row in Excel In another post I have shown you how to create a reference to a locked/fixed cell. However at times we need to be able to fix a reference  to a row. For example if you need to calculate a set of daily numbers against a...

Excel shortcut keys – FREE

Recent Posts

  • Remove unwanted spaces using Trim() and combine multiple entries – 3 ways
  • 06 – How to create a chart with a max/min/target line
  • Exclude text from your conditional formatting for numbers
  • How to create a training roster in Excel .
  • IF NOT – Use IFS/Nested If to show correct VAT rate based on country and product type

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

  • Remove unwanted spaces using Trim() and combine multiple entries – 3 ways
  • 06 – How to create a chart with a max/min/target line
  • Exclude text from your conditional formatting for numbers
  • How to create a training roster in Excel .
  • IF NOT – Use IFS/Nested If to show correct VAT rate based on country and product type

Like Excel Expert on Facebook

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