First thing to do when switching from Excel 2003 to 2007/2010/2016/2019 - KING OF EXCEL

Sunday, January 5, 2020

First thing to do when switching from Excel 2003 to 2007/2010/2016/2019

First thing to do when switching from Excel 2003 to 2007/2010/2016/2019

is to know where are the old menus and toolbar icons!!!

I guess there are still a lot of of Excel 2003 users in Hong Kong, mainly in workplaces.  No idea if it is also common in other cities. There are so many reasons for not upgrading.  Not to my surprise, one of the most commonly heard reasons is the resistance to change.
As an ordinary user, I am sure you would feel more frustration than excitement on the first day you switched from Excel 2003 to 2007/2010/2013.  Before you could appreciate the benefits from (just to name a few)
  • the enhanced features in Conditional Formatting
  • the variety and functionality of new Functions
  • the introduction of Table in 2007
  • the introduction of Slicer in 2010
  • the improvement in Auto Filter
  • so on and so forth
you probably faced difficulties in basic stuff like Printing and Page Setup…  Does it sound familiar?
If you just switched from Excel 2003, or are planning to do so, the first thing you should do is to spend time to get yourself familiarized with the new Interface – the Ribbon.
Let’s see where are those “File”, “Edit”, “Insert”, “Format” etc in the new Excel. (note: Excel 2002 and 2010 being used in the following screenshots).

File

Image

Image
Seems not a drastic change.

Edit 

Image
Edit goes Home.

View

Image
  • For “Header and Footer…”, go to Page Layout tab
  • For “Comments”, go to Review tab
Basically, View is View.

Insert

Image
A lot of migration happened to “Insert”  ~_~

Format

Image
Format goes Home.

Tools

ImageImage
So many changes to Tools… @_@

Data

Image
Well, Data is still Data.  Except PivotTable.

Windows

Image
Windows goes View.

Chart Tools and PivotTable Tools

Image

Image
Note: Pay attention to the Ribbon.   Corresponding tools are available when an object is selected.

What about Right Click Menu??

Image
We don’t need it at all as most of them have been grouped into different tabs of the Ribbon.
No?! There are something icons not being found on any tabs on the Ribbon.
You are correct.  Maybe that’s what Quick Access Toolbars (QAT) for!
Image
Image
Btw, more customization can be made to Ribbon in Excel 2010.
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment