Blogs from Wise Owl on General in Excel

Showing blogs 1-17 (out of 17)

Importing data from pictures in Excel

Posted by Andy Brown on 26 July 2022

A new Excel feature allows you to get data from pictures (you can even review the suggestions before finally inserting the data into your spreadsheet).

Tags:   Excel | General

A couple of software quirks

Posted by Andy Brown on 26 April 2022

What happens when you try to defy gravity in Python, and why Excel sometimes creates worksheets with foreign names

Tags:   Excel | General    |    Python | General

The new Excel Navigation pane and Sheet View

Posted by Andy Brown on 26 April 2022

Changes are coming to your version of Excel! The navigation pane is excellent, while sheet view will help you work on files being reviewed in isolation.

Tags:   Excel | General

The Financial Modelling World Cup

Posted by Andy Brown on 29 September 2021

Want a chance to prove your financial modelling skills? Participate in the Financial Modelling World Cup, or maybe just watch some Excel Esports …

Tags:   Excel | General

Find out how dynamic arrays in Excel will change your (working) life!

Posted by Andy Brown on 14 February 2020

Dynamic arrays are a new feature being rolled out in Excel 365. This blog explains how they work, and why they will make so many things in Excel easier.

Tags:   Excel | General

Introducting the new XLOOKUP and XMATCH functions

Posted by Andy Brown on 13 September 2019

Microsoft have finally recognised the limitations of the VLOOKUP function, and are rolling out the XLOOKUP function to supersede it, as well as the useful (if less significant) XMATCH function.

Tags:   Excel | General

A different owl's take on the five biggest ooh! moment tips in Excel

Posted by Andy Brown on 17 June 2019

This month it's Shaun's turn to nominate the five best short-cut tips in Excel.

Tags:   Excel | General

Andy B's five biggest OOH! moments on an Excel training course.

Posted by Andy Brown on 09 May 2019

All trainers live for that moment when someone's face lights up, as they learn something new which will change their working life for the better. This blog lists my 5 biggest such OOH moments from our Excel training courses. How many of these tips do you know?

Tags:   Excel | General

Use the Excel camera tool, or create a linked picture in Word or PowerPoint

Posted by Andy Brown on 25 April 2018

This blog shows options for creating a webcam focused on one particular area of an Excel workbook! You can do this either by pasting the Excel range into PowerPoint or Word as a linked picture, or by using the Excel camera tool.

Tags:   Excel | General

Changes to Wise Owl Excel courses (including a new intermediate course)

Posted by Andy Brown on 15 January 2018

We've revamped our Excel course offerings, to include a new one-day Intermediate Excel course to sit between our introduction and advanced courses.

Tags:   Excel | General

Want to be get at the file path for an Excel workbook easily? Here's how!

Posted by Andy Brown on 26 January 2017

This short blog explains how you can customise your quick access toolbar to display the path of the file that you are currently working on.

Tags:   Excel | General

What's new in Microsoft Office 2016 (including Excel 2016 changes)

Posted by Andy Brown on 07 September 2015

The latest incarnation of Microsoft Office (2016) should be released on 22nd September 2015 (Microsoft are always a bit ahead of themselves with versions). This blog gives a detailed guide to what's new, the biggest changes being in Excel and Outlook.

Tags:   Outlook | General topics    |    Excel | General    |    Hardware/software | Microsoft Office

Revealing how Excel workbooks are actually stored as zipped XML files

Posted by Andy Brown on 16 May 2014

Did you know that Excel workbooks are really just a collection of XML files, all zipped together? We didn’t either, so we thought we'd tell the world.

Tags:   Miscellaneous | Random musings    |    Excel | General

How to get Excel to speak to you in a female voice, or slower/faster!

Posted by Andy Brown on 13 August 2013

A previous blog showed how to get Excel to speak to you; this one shows how to change the voice in which it does it!

Tags:   Excel | General

How to get Excel to speak to you - reading out the contents of cells

Posted by Andy Brown on 12 August 2013

Deep within its bowels Excel contains a feature allowing it to read out the contents of cells (you can also get your VBA macros to talk to users). This blog goes to those deep places hidden within Excel!

Tags:   Excel | General

What's new in Excel 2013

Posted by Andy Brown on 30 January 2013

Excel 2013 contains radical changes to charts, pivot tables and the user interface. This review explains all the new features of Excel 2013

Tags:   Excel | General

Some ideas for new features for Microsoft Excel 20xx

Posted by Andy Brown on 24 September 2012

Excel is a great product, but there is always room for improvement. Here Andy Brown considers 12 possible new features for Excel 2020.

Tags:   Miscellaneous | The future    |    Excel | General
This page has 0 threads Add post