Data becomes powerful when it is simple and actionable. That is why these new updates from the Microsoft Ignite festival are something that you don’t want to miss. It brings Excel back to its core, displaying data in rows and columns with a set of tools for working with the data. From here Microsoft has created an app that is so incredibly flexible that almost billions of people use it on a daily basis. From a student to a fortune 500 company, Excel has you covered.

Integrate with AI and Excel

From the Ignite festival there are 4 important artificial intelligence (AI) features that make Excel even more powerful:

 

  • Ideas
  • New data types
  • Insert Data from Picture
  • Dynamic arrays

 

Workbook suggestions with Ideas

Microsoft has created a new integrator called Ideas which presents suggestions for how you can group and display your data. This is apparently powered by AI technology and Microsoft is calling this software addition Ideas. Ideas becomes incredibly useful when users are looking to cut down the amount of time it takes for them to create a well-polished professional document. Ideas proactively suggests data groupings and displays that are tailored for the task at hand. It does this by identifying trends, patterns, and outliers that become evident in a given data-set. Ideas will be available soon and quite frankly we are very excited. Simply click the lightning bolt icon in Excel or PowerPoint Online and Ideas will start making recommendations.

 

Manual data entry is now in the past

If you own an Android device, you’re in luck. Another new addition Microsoft added in it’s Ignite festival is the ability to turn a picture into a data table. You will now be able to take a picture of a graph or table and with a single click be able to convert that into a working Excel document. Therefore, this completely eliminates the need to manually enter data. Pretty nifty huh?

 

Speed enhancements to Excel

Microsoft isn’t just adding new features they are also continually improving their current features. VLOOKUP, HLOOKUP and MATCH functions on large data sets will now execute in seconds instead of minutes. They have also significantly improved the processing times of a number of other Excel features, learn how to use Excel here.

Why choose Nexacu?

Valued by Individuals

4.8/5
Over 15837 Reviews
Training is really good. Topics selected were good and all questions were answered patiently. Will prefer this facilitator for the next sessions. -Power BI Intermediate Canberra
suz - Power BI Intermediate, .
Great course, great trainer learned alot -Analysis & Dashboards Brisbane
Karen - Analysis & Dashboards, .
Found it to be very informative. Now I need to go and put it into action. Jagg was an excellent trainer, just the right level of understanding of the differing skills in the room. -Power BI Intermediate Adelaide
John - Power BI Intermediate, .
Thank you -Power BI Intermediate Canberra
Anon - Power BI Intermediate, .
Great -Power BI Intermediate Adelaide
David - Power BI Intermediate, .
Good trainer who made sure I understood everything and took the time to cover any queries I had. Very interactive which really helped my understanding. -Analysis & Dashboards Brisbane
Amy - Analysis & Dashboards, .
Thank you -Analysis & Dashboards Brisbane
LGC - Analysis & Dashboards, .
Excellent Trainer -Power BI Intermediate Canberra
Prakash - Power BI Intermediate, .
Thanks! -Power BI Intermediate Canberra
GP - Power BI Intermediate, .
Thanks. Good efficient course and engaging instructor! -Power BI Intermediate Canberra
Elise - Power BI Intermediate, .
Great knowledge of the trainer, who provided data insight and visualisation advice for various audience -Power BI Beginner Melbourne
Zoe - Power BI Beginner, .
Comprehensive and great for beginners -Power BI Beginner Melbourne
mlim - Power BI Beginner, .
clear teaching -Power BI Beginner Melbourne
Lay - Power BI Beginner, .
thanks John -Power BI Beginner Melbourne
dh - Power BI Beginner, .
John was great to work with. Really enjoyed his style and patience with us. Thanks John! -Power BI Beginner Melbourne
David - Power BI Beginner, .
Good pace and engagement. Answered questions well. Friendly and pleasant. -Power BI Beginner Melbourne
John - Power BI Beginner, .
A thorough overview of analysis and dashboards and the intrinsic possibilities -Analysis & Dashboards Melbourne
LUMART - Analysis & Dashboards, .
Tim was very clear and easy to understand and took the time to understand what we did for our jobs and tried to then give useful examples as to how we could use these tools in our work. -Analysis & Dashboards Melbourne
Nicola - Analysis & Dashboards, .
Very insightful session into Power BI, will definitely come back for another level so I could leverage the tool for the business -Power BI Beginner Melbourne
Tham - Power BI Beginner, .
Good course -Analysis & Dashboards Melbourne
Lauren - Analysis & Dashboards, .

Trusted by Business

Procured by Government

Map of Australia