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
    07Feb
    Analyzing Large Datasets with Power Pivot in Microsoft Excel
    Excel Free Training How To

    The context for Power Pivot… If you are a frequent Excel user, then you are probably familiar with pivot tables. They are used for figuring out quick insights from small amounts of data and can also be turned into easy to understand graphs. But even... ...

    2019
  • 10 Excel Formulas Every Beginner Should Know-min
    18Jan
    10 Excel Formulas Every Beginner Should Know
    Excel Free Training How To

    ...

  • The top 10 most useful things to know in excel-min
    14Jan
    Protected: The Top 10 Most Useful Things to Know in Excel – Mini Course
    Uncategorized

    There is no excerpt because this is a protected post. ...

  • The Definitive 100 Most Useful Excel Tips
    07Jan
    The Definitive 100 Most Useful Excel Tips
    Business Skills Excel How To

    ...

  • 15 Excel Data Analysis Functions You Need to Know-min
    04Jan
    15 Excel Data Analysis Functions You Need to Know
    Excel Free Training

    ...

  • 02Jan
    What’s New in Microsoft Office 2019?
    Excel

    Microsoft has been making a not so subtle attempt to push its 1.2 billion Office users towards Office 365 for some time. This has been mostly successful. Over 120 million people have active Office 365 accounts and adoption is up 34% since 2016 and now... ...

  • Using VLOOKUP, HLOOKUP and INDEX MATCH-min
    20Dec
    How to use VLOOKUP, HLOOKUP and INDEX MATCH in Excel
    Excel Free Training How To

    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... ...

    2018
  • How to Use 'IF' and Nested 'IF' Functions-min
    20Dec
    How to do IF and nested IF functions in Excel
    Excel Free Training How To

    The IF function is one of the most useful you will ever learn in Microsoft Excel. It’s also incredibly simple and can unlock some seriously juicy functionality when you start nesting IF statements.   In this post, we’ll show you how to do an IF... ...

  • PivotTables in Excel The Basics-min
    20Dec
    PivotTables in Excel – The Basics
    Excel Free Training How To

      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... ...

  • Restricting Cell Contents with Data Validation-min
    20Dec
    Restricting Cell Contents in Excel Using Data Validation
    Excel Free Training How To

      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... ...

  • 13Dec
    Top 5 Under-Appreciated Excel Functions
    Excel Free Training How To

    They say you never forget your first time. It’s true. My first experience of Microsoft Excel is burned forever into my mind. I was in my first graduate job, fresh from a humanities degree. I’d written plenty of essays, but few of these required any... ...

  • 01Jan
    Workout Tracker, Calorie Counter…All in Excel
    Excel

    ‘New year, new me’… how many times have you heard that? Or even said it yourself? After eating too much over the festive season, we were feeling guilty and began looking for redemption online. We found some useful Excel spreadsheets which could help you (and... ...

  • 11Dec
    Presentation Skills: 3 Huge Mistakes and How to Avoid Them
    Business Skills Excel

    You’ve been working for weeks, brushing up on your presentation skills and creating the perfect slideshow for a big meeting with some high profile clients. The day is here. The information is memorised. The slides are in order. You got to the room early to... ...

    2017
  • 01Dec
    How Learning Excel Can Increase Your Salary 4X Over Your Career
    Business Skills Excel

    Excel punches above its weight in value-add, to both your salary and the performance of your organisation   In the crowded job market, you need to stand out to secure a decent role. Once in a role you equally need to stand out if you... ...

  • THE TOP 10 EXCEL FEATURES
    20Nov
    The Top 10 Excel Features
    Excel Free Training

    ...

  • 17Nov
    3 Steps to Create Powerful Presentations with Excel
    Excel How To

    There are simple things you can do in Microsoft Excel that can hugely impact your presentation style and help you create powerful presentations. These 3 Excel tips are easy to implement regardless of whether you are a beginner, intermediate or advanced Microsoft Excel user. 3. Be relevant Make important... ...

  • 20Oct
    The Definitive 100 Most Useful Excel Tips
    Business Skills Excel How To

    ...

  • Pivot tables in Excel
    12Oct
    Pivot Tables in Excel: How to Use the PivotTable Function
    Excel How To

    The PivotTable function is one of the most widely used features of Microsoft Excel. It allows you to analyse and visualise data in various ways that can provide deep insights. If you have never used pivot tables in Excel or would like to build on... ...

  • 14Aug
    20 principles all Excel users should follow. Do you?
    Excel Free Training How To

    It’s time to sharpen those spreadsheets with this nifty guide – and the best part? It’s totally FREE! Ensure your spreadsheets are up to scratch with these twenty principles. Put together by the Institute of Chartered Accountants in England and Wales (the ICAEW) and written by 17... ...

  • 07Aug
    Excel Fundamentals Live Course
    Free Training Learning Webinars

    On 21 June, we launched our first Excel Fundamentals Live Course, held over 4 weeks. Each week we held an hour-long interactive lesson with course expert, Deborah Ashby. Aimed at beginner to intermediate level Excel users, the course covers a range of topics, starting with... ...

  • How to use VLOOKUP in Microsoft Excel
    06Aug
    How to use VLOOKUP in Microsoft Excel
    Excel How To

    One of the handiest but most daunting spreadsheet skills for business must be VLOOKUP in Microsoft Excel. By simplifying the search data in Excel, it has become a mainstay for many spreadsheet users.   For anyone new to the VLOOKUP feature, it may seem overly technical and... ...

  • 01Aug
    80% of people answered these questions on Excel incorrectly
    Excel

    Glorious Microsoft Excel. Guardian of business knowledge, unlocker of data secrets. Frustratingly inaccessible to many people. Excel can be painful, but learning to make sense of it can also be the best investment in your business skills that you ever make. We see people of... ...

  • 10Jun
    Style Your Spreadsheets to Present Data More Clearly
    Excel How To

    Applying styles to your spreadsheets is not simply a matter of style over substance. Formatting allows you to emphasise and delineate your data, enhancing both its clarity and your presentations. Styles is a tool that allows you to more quickly and easily apply consistent formatting to your spreadsheet using... ...

  • 06Jun
    How to Represent Trends with Sparklines
    Excel How To

    Sparklines are very small charts that fit within a line of text or a single cell of a spreadsheet. They’re a great way to give your data some context without taking up half the page with various bulky charts. As they are so small, they are typically... ...

  • 02Jun
    How to Format Numbers in Excel
    Excel How To

    Excel is, at its heart, a programme that manipulates numbers: so getting your numbers to appear as you want is an important skill. The appearance of a number entered in an Excel cell can be changed in many different ways. This blog post shows you... ...

  • 30May
    How to Forecast using Average Percentage Growth
    Excel How To

    Average percentage growth tells us how fast something has grown, and eventually forecasts the future through extrapolation.   There are different ways of calculating average growth in Excel (e.g. LOGEST, LINEST, lines of best fit, etc.) and some of these will give different results. Let’s... ...

  • 25May
    Spotting Inconsistencies with “=…=…”
    Excel How To Technology

    Inconsistencies can creep into spreadsheets for a range of causes: data-entry errors; accidental changes made to the data after entry; inconsistently applied rounding or changes to units; or differences in the way numbers are formatted in different systems.   The following is a simple technique... ...

  • 25May
    Done In 60 Seconds – Cumulative Sums
    Excel Free Training How To Technology

    Have an ordered list of items, each with an assigned value such as revenue or cost, which you need to analyse and understand? Perhaps you need to know how these numbers are adding up in order to be alerted to business limits (budgets, deadlines etc,) being approached... ...

  • 25May
    How To Excel – Use Filters to Get the Data You Want
    How To

    Excel gives you many options when it comes to filtering your data. If you have a database with numerous entries, you can filter the data so that only the relevant information appears. Then, when you remove the filter, you can see all of your data... ...

  • 25May
    How to Add your Excel IQ Certificate to your LinkedIn profile
    Excel How To Technology

      Congratulations on receiving your Excel with Business Microsoft Excel IQ certificate. You can now add this to your LinkedIn profile!       The Excel IQ™ is modelled on traditional and well-established means of IQ scoring (e.g. a score of 100 is ‘average’) and... ...

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.