All courses available in-class or via remote login

Excel and AI

Where AI and Excel Meet – Ignite Updates

November 01, 2018

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.

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 24229 Reviews
Thank you very much for your detailed instruction Domenic! I really enjoyed your course very much. The course was really useful and I can recommend your course to everyone! -Analysis & Dashboards Perth
Saori - Analysis & Dashboards, .
Good and professional training session! thanks to Domenic for carrying out the course. -Analysis & Dashboards Perth
Ayat - Analysis & Dashboards, .
A lot of information covered however course was at a good pace with sufficent breaks. Jason was clear and easy to understand with the way he presented the information. Attending remotely it at times was hard to hear the questions from the people in the room so sometimes a bit confusing I found it really informative and would recommend to collegues and friends Thank you -Power BI Beginner Brisbane
Christine - Power BI Beginner, .
Course was great, and very informative. -Power BI Beginner Brisbane
Mark - Power BI Beginner, .
THe beginner Power BI course run by Jason was fantastic. I really feel like I have had a clear & thourough introduction to the application. -Power BI Beginner Brisbane
Anna - Power BI Beginner, .
Jason was great. Very clear in instructions and went at a good speed for someone with minimal exposure to Power BI. It was a long day of learning but covered a lot of ground -Power BI Beginner Brisbane
Melissa - Power BI Beginner, .
Good training - easy to follow -Power BI Beginner Brisbane
Rachael - Power BI Beginner, .
Excellent !!! -Power BI Beginner Brisbane
Khurram - Power BI Beginner, .
Good interactive and practical course presented well by Jason. -Power BI Beginner Brisbane
Anthony - Power BI Beginner, .
It was very helpful and informative. Steven was very patient and knowledgeable. -Excel Beginner Brisbane
Jessica - Excel Beginner, .
Steve delivered a very interesting and informative session that will support me in my position moving forward -Excel Beginner Brisbane
Margaret - Excel Beginner, .
Great course. I learnt a lot. Steven was a great trainer. -Excel Beginner Brisbane
Alison - Excel Beginner, .
Very practical and informative session. Will be very useful in my daily work. -Excel Beginner Brisbane
Julie - Excel Beginner, .
very patient, relatable presenter. Good examples -Excel Beginner Brisbane
Kate - Excel Beginner, .
Thank you. -Power BI Beginner Adelaide
Shane - Power BI Beginner, .
Excellent fundamental class for R by Tamara -R Basics Perth
Virendra - R Basics, .
It was good but I think I will need to do the Basic Course as some of the techniques were a little beyond me. Thanks Stuart for your patience. -Word Intermediate Brisbane
Carmen - Word Intermediate, .
Thank you Stuart -Word Intermediate Brisbane
Chiho - Word Intermediate, .
Learnt some good techniques. Thanks Stuart -Word Intermediate Brisbane
Millie - Word Intermediate, .
Good course. It was good to uncover details about styles. -Word Intermediate Brisbane
Graham - Word Intermediate, .

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us