Get 20+ Excel courses at Simon Sez IT, including training for Excel 365, 2021, 2019, 2016, 2013, and more ️ https://www.simonsezit.com/course-category/excel/ Get a FREE 2.4 hour Excel 2019 Beginners course here ►
https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/

Start using Microsoft Excel 2013 by getting yourself acquainted with its various new features. Some of which include the Quick Analysis tool, Flash Fill, and Chart Recommendations. There are also other features such as the ability to choose a template for the setup and design, to work on two workbooks at the same time, to share an Excel worksheet online, to save to a new file format, and new Excel functions related to math and other calculation facilities. Find out more about these features in this video.

Get the full course on Excel 2013 course here: https://www.simonsezit.com/course-category/excel/

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining

Twitter: http://bit.ly/177EU5J
Google+: http://bit.ly/11JbHdb

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -)

Welcome back to our course on Excel 2013. In this section, I’m going to take a pretty quick look at what’s new in Excel 2013. If you haven’t used Excel before, what’s new may not mean very much to you, but this is quite a short section and I still think it’s worth you going through this section because it will also highlight some of the features that I’ll be concentrating on as they are new ones.
So first of all, there’s a whole section on what’s new in Office 2013 and within that there’s a section on what’s new in Excel 2013. There’s a video at the beginning that takes you through the main points.

There are quite a few new features some of them are really quite small in terms of the overall scale and scope of Excel 2013. And to be fair, some of them are quite advanced topics which you’d really need to look at our advanced course to be able to see the impact of. But what I’m going to do here is just go through the main ones that will affect us on this course and I suggest you go through what’s new in Excel 2013 on the Microsoft website, particularly if you’ve used Excel before, and there you can get links to some of the changes in more detail.

Now for existing users, people who have used earlier versions of Excel, one of the most noticeable difference will be the change of the overall look and feel. We’re going to look at Excel 2013 in the next section and one of the things you’ll notice is that everything seems to be a little bit more open, everything seems to be a little bit less crowded. And one of the reasons for this is that the whole of Office 2013 now is geared up for use with touch devices and therefore allowing for people with slightly fat fingers, my fingers are probably slightly fat fingers, it gives you a little bit more space to use touch on the screen. Now that’s not to say the use of touch has taken over, far from it. But if you’re trying to use a product like Excel with a touch screen, you do need a certain amount of flexibility in terms of being able to touch the screen accurately, particularly as with Excel you may have a very large amount of data on a worksheet. So if you’re a new user, one of the things you’ll notice is there seems to be a lot more space which in itself I think is not a bad thing anyway.

Another key feature when you first open Excel 2013 is that you’ll see a page where you can start with one of the provided templates. And with Excel 2013, templates do most of the setup and design work for you. Now if you’re creating a spreadsheet for a common type of application, there’s a good chance that Excel 2013 will include a template that you can start to work from. Of course, the use of Excel is so wide now, and the number of applications is so wide, that there can’t possibly be a template for every possible job. But if you’re doing something straightforward, perhaps like a budget or something like that, the chances are there’ll be something that will get you started at least.

Now the next two or three topics that are new in Excel 2013 are, first of all, Quick Analysis Tool which enables you to do pretty much instant data analysis on a set of data. And there’s also a Flash Fill facility that lets you fill out an entire column of data in a flash, as it says there. There is also what I think is really quite a significant new tool, which is a Chart Recommendations Tool.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.