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.

What is Remote Training?

Valued by Individuals

 

4.8/5
Over 21470 Reviews
Jagg was an excellent trainer - very patient, had lots of options for people who didn't have the newest versions. I feel really confident about what I learnt today and I am very happy I did this course! -Power BI Beginner Adelaide
Melissa - Power BI Beginner, .
Excellent! Very knowledgeable instructor. -Power BI Beginner Adelaide
Jason - Power BI Beginner, .
Great course, very informative. Great instructor, very helpful -Power BI Beginner Adelaide
Sarah - Power BI Beginner, .
Great session, moves at a good pace with support when needed. Thanks -Power BI Beginner Adelaide
Matthew - Power BI Beginner, .
Excellent! -Microsoft Applications - Customised Sydney
Candice - Microsoft Applications - Customised, .
Very helpful -Microsoft Applications - Customised Sydney
Janet - Microsoft Applications - Customised, .
The learning environment and facilities are great. Ken knew the course content and is a friendly trainer.. -SharePoint Site Owner Melbourne
Robbie - SharePoint Site Owner, .
Thank you Ken Great 2 day of learning lots of information, looking forward to making our New Company SharePoint Site -SharePoint Site Owner Melbourne
Natasha - SharePoint Site Owner, .
Thank you Ken, I feel a lot more empowered and up-skilled with regards to SharePoint. I am looking forward to supporting my organisation to leverage SharePoint as one of collaboration and information management tools. -SharePoint Site Owner Melbourne
Annita - SharePoint Site Owner, .
Found it beneficial. Ken was extremely knowledgeable -SharePoint Site Owner Melbourne
Toby - SharePoint Site Owner, .
Great course, learnt a lot for the trainer. -Power BI Beginner Sydney
Aaron - Power BI Beginner, .
A good session however some revision of content from the intermediate course, which meant doing those two courses close together made those portions somewhat repetitive. Jagg was a good presenter and a good pace. -Excel Advanced Adelaide
Belinda - Excel Advanced, .
Jagg went above and beyond to help us learn the advance functions of excel. -Excel Advanced Adelaide
Ateeq-ur - Excel Advanced, .
Jagg was a great instructor - he stepped us through at a good pace, paused well to take q's and was well prepared. -Excel Advanced Adelaide
Hannah - Excel Advanced, .
Excellent range of advanced skills presented -Excel Advanced Adelaide
Oliver - Excel Advanced, .
Jag was excellent! Clear and thorough. I was a bit worried doing it remotely but found it better! Highly recommend. -Excel Advanced Adelaide
Agland - Excel Advanced, .
Was a very good informative session from Jag. -Excel Advanced Adelaide
Nilmini - Excel Advanced, .
Thank you. Well taught, clearly presented, and valuable lessons. Would recommend. -Excel Advanced Adelaide
David - Excel Advanced, .
Good pace, great course -Excel Intermediate Melbourne
Gemma - Excel Intermediate, .
Was a very informative course. John is a very patient instructor. Gives clear instructions. -Excel Intermediate Melbourne
Sonia - Excel Intermediate, .

Trusted by Business

Procured by Government

Map of Australia