Excel Community round-up - January 2020

Here is all of January 2020's new Excel content.  Excel Community and Tech Faculty members can access all posts by logging in to their accounts: Other users can access posts described as "public".

Excel Tip of the Week

323 - Creating a trial balance from accounting data (public)

Given a list of accounting transactions, how can you go on to create a trial balance easily and automatically?

324 - Introduction to formulas and functions

We go back to basics with an introduction to the fundamentals of Excel formulas.

325 - Revisiting quick formatting

Making an appealing-looking spreadsheet doesn't have to be a drain on your time - check out these keyboard shortcuts and more tips for quick and easy cell formatting.

326 - Revisiting loan functions

Excel has a plethora of functions for helping you compute statistics about loans - their length, interest rates, repayments, and more.  Download our comprehensive workbook exploring every one of them!

Modelling 101

Part 56 - Indebted to the Festive Season

Liam Bastick takes his own look at loan calculations, contrasting the in-built Excel functions with the direct mathematical approach.

Part 57 - Multiple bullet charts

Liam tackles a tricky chart customisation problem, showing how a little creativity can make more than just what appears to be possible in Excel!

Other blogs

Use conditional formatting to create bands in an Excel Table

Simon Hurst shows you how to use conditional formatting with Power Query to highlight different groups of values.

Excel tips for accountants - Exporting data from accounting systems (Part 2: Creating tables)

Continuing the theme of Tables, Tom Edmunds explores how they can simplify repeated importing of accounting system data.

Using Power Query for entering 2020 budgets

Simon returns to Power Query and his earlier example to explore further ways to make Power Query work for you.

Office Scripts coming to Excel

Liam Bastick dives into the newly-announced Office Scripts - the successor to recorded VBA for automation in Excel.

Intro to Financial Modelling - Part 1: Model definition and purpose (public)

A new series from the Financial Modelling Committee of the Excel Community which explores the Financial Modelling Code.  In part 1, chair Alistair Hynd goes over the general background of the Code and the types of spreadsheets it applies to.

Recent Excel updates - Death throes or brave new world? (public)

Are big new features like Power Query, dynamic arrays, or Office Scripts the heralds of an Excel renaissance, or too little too late?

New Microsoft features of Q4 2019/Jan 20 (public)

David Benaim starts a new quarterly series exploring the multitude of updates made to Office 365.  Are you getting the most out of your subscription?