What are the basics of an Excel Chart? Find out here! theartofexcel.com/chart/ #learnexcel #excelchart #excelvisualization

Calculate Running Total. This is a great twist on the SUM function. You can use absolute references in order to change how the SUM function works in order to calculate a running or cumulative total. theartofexcel.com/excel-running-… #learnexcel #Excel

It's a quickie and a simple one - the AVERAGE function - find out how to use it here theartofexcel.com/excel-average-… #excel #learnexcel #excelfunctions

Use the combination of Excel functions INDEX and MATCH to create a flexible VLOOKUP alternative. theartofexcel.com/index-match #learnexcel #Excelfunctions #Excel

INDEX and MATCH. This has often been used as a VLOOKUP replacement but it's actually a lot more powerful. Find out how to look up using a mix of rows and columns with these functions theartofexcel.com/two-way-lookup/ #learnexcel #Excel

Another way to get clever with the SUM function is to use it across multiple worksheets. The use of a function across worksheets is often called a 3D formula. Find out more theartofexcel.com/sum-3d-formula/ #learnexcel

Create a professional looking rate card for £50 via PeoplePerHour peopleperhour.com/hourlie/create…

Simple Excel Project Planner Template #exceltemplates #projectmanagement #projectplanner theartofexcel.com/product/simple…

Case Study - Excel Talent Management Dashboard & Automated Messaging Tracker theartofexcel.com/2018/02/excel-…

Excel Survey Dashboard - Simple Excel Survey Feedback Dashboard Template #exceltemplate #learnexcel theartofexcel.com/product/excel-…

Excel Recruitment Tool - Simple Message and Dashboard Template theartofexcel.com/product/excel-…

Excel VBA Refresh all Pivots - Excel Expert Tip #excelvba #excelmacros #learnexcel theartofexcel.com/excel-vba-refr…

Case Study: Excel Survey Reporting - Group and Individual Reports #Excelreporting theartofexcel.com/excel-survey-r…

Excel Drop Down Validation - create simple validation within your spreadsheets #learnexcel #excelvalidation #exceltip theartofexcel.com/excel-drop-dow…

Excel Fill in the Blanks – Excel Expert Tip theartofexcel.com/excel-fill-in-…

FREE Excel Template Simple Gantt Chart #ganttchart #exceltemplate theartofexcel.com/product/excel-…

The Art of Excel case study: Excel Estimate and Invoice Tool #excelconsultancy #excelfreelance theartofexcel.com/excel-estimate…

Excel Profit and Loss Report theartofexcel.com/excel-profit-a…

Take a look at the Excel function SUM - step by step #learnexcel #excelbasics #excel theartofexcel.com/sum/

It's an Excel must! #absolutereferences brush up on your best practice #learnexcel #excelformula theartofexcel.com/absolute-refer…