LogoLogoLogoLogoLogo

LOG IN

0
  • No products in the cart.
  • COURSES
    • MEMBERSHIP
    • MICROSOFT
    • BUSINESS
    • FINANCE
    • TECHNOLOGY
    • LEISURE
    • BUNDLES
    • TEAMS
  • ABOUT
    • ABOUT US
    • APPROACH
    • THE FILTER
    • CPD EXPLAINED
  • BLOG
    • WEBINARS
    • EXCEL
    • HOW TO
    • TECHNOLOGY
    • FREE TRAINING
  • REDEEM
  • SUPPORT
  • LOG IN
  • COURSES
    • MEMBERSHIP
    • MICROSOFT
    • BUSINESS
    • FINANCE
    • TECHNOLOGY
    • LEISURE
    • BUNDLES
    • TEAMS
  • ABOUT
    • ABOUT US
    • APPROACH
    • THE FILTER
    • CPD EXPLAINED
  • BLOG
    • WEBINARS
    • EXCEL
    • HOW TO
    • TECHNOLOGY
    • FREE TRAINING
  • REDEEM
  • SUPPORT
  • LOG IN
Analysing large data-sets with power pivot

Analyzing Large Datasets with Power Pivot in Microsoft Excel

Posted on February 7, 2019
in Excel, Free Training, How To
by Adam Lacey

The context for Power Pivot...

Read More
Using VLOOKUP, HLOOKUP and INDEX MATCH-min

How to use VLOOKUP, HLOOKUP and INDEX MATCH in Excel

Posted on December 20, 2018
in Excel, Free Training, How To
by Adam Lacey

Say you have a table of data and you want Excel to look up a certain value and return a corresponding value in a different row. For that, you need a lookup function. Excel has a range of functions that you can use to achieve...

Read More
PivotTables in Excel The Basics-min

PivotTables in Excel – The Basics

Posted on December 20, 2018
in Excel, Free Training, How To
by Adam Lacey

  PivotTable or pivot table. You may have heard of them…   In our opinion, they are one of the MOST powerful things you can learn in Excel. The great news is, they are pretty easy to get the hang of.   Before PivotTables were introduced into Excel, you had...

Read More
Restricting Cell Contents with Data Validation-min

Restricting Cell Contents in Excel Using Data Validation

Posted on December 20, 2018
in Excel, Free Training, How To
by Adam Lacey

  Did you know that you can restrict, give guidance on and create drop-down lists for what you can enter in a certain cell in Excel? It’s a pretty cool feature and it’s called Data Validation.   However carefully you design your spreadsheets, even if you lock cells...

Read More

PivotTables – A ‘Must Have’ Excel Skill

Posted on May 1, 2017
in Excel, How To
by Amanda Fielding

One way of judging the importance of different Excel features is to look through the ‘Must Have’ section of relevant job descriptions. You’d probably be surprised at how often PivotTables appear.   One of the great benefits of PivotTables is that they are not just the best,...

Read More

Popular Courses

Microsoft Excel
Business Analysis
Mini MBA
Basic Accounts
Accounting and Bookkeeping
Introduction to Web Development
See all...

About

About us
Affiliate Program
The Filter

Blog

  • Analyzing Large Datasets with Power Pivot in Microsoft Excel
  • 10 Excel Formulas Every Beginner Should Know
  • Protected: The Top 10 Most Useful Things to Know in Excel – Mini Course
  • The Definitive 100 Most Useful Excel Tips

Contact

Support

UK: +44 (0) 20 3322 5962 |

US: +1 (888) 491-6123

support@excelwithbusiness.com

sales@excelwithbusiness.com

© 2020 Excel with Business

Cookie Policy | Privacy Policy | Terms & Conditions
This site uses cookies: Find out more.