The Art of Excel

Excel Expert - Freelance Consultancy

[The Art of Excel @dianeonexcel]

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 https://t.co/NnD4ROZiZX #learnexcel

[The Art of Excel @dianeonexcel]

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 https://t.co/nOOH9RD3zP #learnexcel #Excel

[The Art of Excel @dianeonexcel]

Use the combination of Excel functions INDEX and MATCH to create a flexible VLOOKUP alternative. https://t.co/5dRghVRQwM #learnexcel #Excelfunctions #Excel

[The Art of Excel @dianeonexcel]

It's a quickie and a simple one - the AVERAGE function - find out how to use it here https://t.co/ig4KYHqO4L #excel #learnexcel #excelfunctions

[The Art of Excel @dianeonexcel]

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. https://t.co/bhmPGyoryH #learnexcel #Excel

[The Art of Excel @dianeonexcel]

What are the basics of an Excel Chart? Find out here! https://t.co/6APGbkXIYV #learnexcel #excelchart #excelvisualization

[The Art of Excel @dianeonexcel]

It's an Excel must! #absolutereferences brush up on your best practice #learnexcel #excelformula https://t.co/Uav3jKN9Uj

[The Art of Excel @dianeonexcel]

Take a look at the Excel function SUM - step by step #learnexcel #excelbasics #excel https://t.co/AOe6H8bGC4

[The Art of Excel @dianeonexcel]

Excel Profit and Loss Report https://t.co/pGWLvFDQnU

[The Art of Excel @dianeonexcel]

The Art of Excel case study: Excel Estimate and Invoice Tool #excelconsultancy #excelfreelance https://t.co/D5bcAEybFp

[The Art of Excel @dianeonexcel]

FREE Excel Template Simple Gantt Chart #ganttchart #exceltemplate https://t.co/G8bvGE8Ks4

[The Art of Excel @dianeonexcel]

Excel Fill in the Blanks – Excel Expert Tip https://t.co/goT5S9NKiU

[The Art of Excel @dianeonexcel]

Excel Drop Down Validation - create simple validation within your spreadsheets #learnexcel #excelvalidation #exceltip https://t.co/niz82rYVOw

[The Art of Excel @dianeonexcel]

Case Study: Excel Survey Reporting - Group and Individual Reports #Excelreporting https://t.co/9rXp3zrKaT

[The Art of Excel @dianeonexcel]

Excel VBA Refresh all Pivots - Excel Expert Tip #excelvba #excelmacros #learnexcel https://t.co/8ufwmIcsAI

[The Art of Excel @dianeonexcel]

Excel Recruitment Tool - Simple Message and Dashboard Template https://t.co/pJTpAS57Ff

[The Art of Excel @dianeonexcel]

Excel Survey Dashboard - Simple Excel Survey Feedback Dashboard Template #exceltemplate #learnexcel https://t.co/Ep0AGPE9Yu

[The Art of Excel @dianeonexcel]

Case Study - Excel Talent Management Dashboard & Automated Messaging Tracker https://t.co/keDHhXtqu5

[The Art of Excel @dianeonexcel]

Simple Excel Project Planner Template #exceltemplates #projectmanagement #projectplanner https://t.co/l2TlCSt6PV

[The Art of Excel @dianeonexcel]

Create a professional looking rate card for £50 via @PeoplePerHour https://t.co/IJS9YqTNRl