Excel TAKE vs DROP: Extract Only the Rows You Need
Working with a large list but only need the first few rows, the last few results, or everything except a header? Excel…
Read articleWorking with a large list but only need the first few rows, the last few results, or everything except a header? Excel…
Read articleHave you opened a Word, Excel, or PowerPoint file and noticed Compatibility Mode next to the file name? It doesn't mean the…
Read articleIf you've ever seen a security warning when opening a Word document or Excel workbook, the Office Trust Center may be responsible.…
Read articleHighlighting duplicates in Excel is one of the fastest ways to spot repeated values in a list. Microsoft says you can use…
Read articleFlash Fill in Excel helps you clean up or reshape data automatically when Excel recognizes a pattern. Microsoft says Flash Fill automatically…
Read articleSorting and filtering are two of the most useful tools in Excel when you want to organize a list, clean up a…
Read articleA Gantt chart is a simple way to show project tasks across a timeline. Microsoft says a Gantt chart helps you schedule…
Read articleMerging cells in Excel is useful when you want one label or heading to span across multiple columns. Microsoft says merging combines…
Read articleCOUNTIF is one of the most useful Excel functions when you want to count how many cells match one condition. Microsoft says…
Read articleSUMIF is one of the most useful Excel functions when you want to add numbers that meet one condition. Microsoft says you…
Read articleThe IF formula in Excel is one of the most useful functions because it lets you test a condition and return one…
Read articleCharts in Excel help turn raw numbers into something easier to understand. Microsoft says charts help you visualize data for stronger impact,…
Read articleCookies on OfficeDigital
We use necessary cookies to run the shop. With your OK we also use analytics cookies to see which pages work, and marketing cookies for our newsletter, Trustpilot and affiliate programme. Privacy Policy