Hi, my name is Shir and I'm the founder and CEO of shirconsulting.com where we focus on converting the existing data from your business into massive savings and extraordinary profits. Today we're going to learn the basics of Excel. Let's get started.
So, as you know there are many different versions of Microsoft EXCEL. Right now, we're using EXCEL 2010 although you may have 2007 or even 2003. There are plenty of differences between them. The RIBBON is the latest addition from 2007 and was improved a little bit in 2010. But the only things you need to worry about really are what to do if you have an early version or what to do if you a later version.
So if you have the most recent version of Microsoft EXCEL 2010, you will want to save that file both as a .XLSX, which is the most recent version, or you can save as a previous version which is now 97-2003 which is a .XLS extension. That way anyone who has an older version of EXCEL can still read your file.
There's a detailed breakdown of all the differences between the versions of EXCEL which can be found by pressing the F1 key to bring up EXCEL HELP and then going to the table of contents and clicking on the File conversion and Compatibility section. You can see a list of all the different formats that are supported in EXCEL. Here's what each of the extensions mean. You can also click here for the full breakdown of what to do in compatibility mode, how to check for compatibility, what is supported, which features are supported in the newer versions that are not supported in previous versions. So if you really want to know in-depth what the differences are - this is a great place to look.
However, all you need to know really is that there are new formatting templates, new tables and new charts which will not be supported in previous versions in EXCEL. So by default whenever you save a file in EXCEL 2010, it saves it as a .XLSX but as a good practice, save it as well as a, save as or F12 on the keyboard and save it as a .XLS for anyone who does not have the latest version of Microsoft EXCEL. And that's all you need to know about File Compatibility in Microsoft EXCEL!