Survey

Visit the official COVID-19 government website to stay informed: sacoronavirus.co.za
Call Us: Johannesburg: +27 (0)10 007 4460 / Cape Town: +27 (0)21 007 2630

Blog

You are here:

Microsoft Excel - Tips & Tricks Part 1

Import PDF

Data -> Get Data -> From File -> From PDF -> Select Data -> Import
A dialogue appears which lets you select the data you would like to import into Excel.

Analyze Data

On the right side there is a section called Analyze Data with all the tables and charts automatically. It uses AI and intelligence to analyze data. You can show all the results. It shows you insights automatically on how to get more value from your data.

Flash Fill

It automatically fills all the cells with data related to what you have previously.

Geography and Map Data

It immediately makes a map chart so that you can see populations, numbers and percentages according to areas.

Version History

File > Info > Version History
This is like an excel time machine in case you lose your spreadsheets.

One-Click Email as Attachment

More commands > All commands > Email > Add
Email an excel file as a PDF in a single click. Instantly opens a new email with the excel spreadsheet attached as a PDF.

XLOOKUP

Next-generation of V LOOK UP. The look up array doesn't always have to be on the left-hand side and the return array can show multiple sets of data.

Diagonal Cell Formatting

By clicking this button, you are able to make a diagonal border line that splits a cell in two.

Sparklines

Column > Create Sparklines
Sparklines are the same as charts in excel cells. You can change it to a line instead.

Categories

Have any Questions? Get in Touch

Contact Us
  • Phone: Johannesburg: +27 (0)10 007 4460
    Cape Town: +27 (0)21 007 2630
  • Email: info@acnode.co.za
  • Monday - Thursday: 8:00 am - 5:00 pm
  • Friday: 8:00 am - 4:00 pm
  • Emergency: 24 Hours, 365 Days
Newsletter

We promise not to send you spam. And you can unsubscribe at any time.

© 2021. Acnode Group All right reserved.