Friday, October 24, 2014

Let’s Start with Excel 2013

In modern office or any kinds of Executive work spreadsheet program is essential and Excel 2013 is till now a smart spreadsheet program. By this program, you can organize, store, summarize and analyze information. So Excel is a power full program for any kinds of complicated data like making budget, organizing data, making database or creating an invoice.

The Excel interface

Work with the Excel environment

Introduce with Worksheet views

The Quick Access Toolbar


Excel 2010 and Excel 2013 are almost similar  and very close to Excel 2007 to use but  not  similar with older version like Excel 2003.

Excel 2013 interface:

At the time of opening Excel 2013 you will see the Start Screen and by this face you can choose a template, create a new workbook and also go to the recently edited workbooks.
From the below Start Screen, you can select blank workbook to create a new work book with access the Excel interface 


Become familiar with the Excel 2013 interface

Working with the Excel environment

In Excel 2013, you will get the common features like the Ribbon and Quick Access Toolbar and as well as Backstage view.

The Ribbon:

In Excel 2013, The Ribbon consists of multiple tabs and each Tab has several groups of commands.

Excel 2013

Ribbon Tab system
Multiple tabs
Groups of commands

Home Tab: The home Tab is the first tab which contains all common used commands to work with data including cut-copy-paste, front, alignment, number, styles, formatting and cells.


Insert Tab: The insert Tab is the next tab of home tab which contains all graphical used commands to work with data including Tables, charts, sparklines, filters, symbols and more. Sparklines is new in this version.
Page layout: The Page Layout Tab is the next tab of Insert tab which contains all print formatting used commands to work with data including themes, margin, Page setup, sheet options and more.

Formulas tab: The Formulas Tab is the next tab of Page layout tab which contains all types of formulas and functions to summarize, analyze and calculate numerical data.

Data tab: The Data tab is the next tab of Page layout tab which contains all Sort, Filter and Data Tools commands to summarize, analyze a large amount of data.

Review tab: The Review tab is the next tab of Data tab which contains all editing features like proofing, comments, Protecting, sharing and track changes.

View tab: The View tab is the next tab of Review tab which contains different view commands like workbook view, zoom, and freeze panes and macros.

Contextual tabs: This tab will appear on special work like working with tables and pictures for formatting.

Ribbon showing or hiding:

You can maximize or minimize the Ribbon if you want. For this purpose follow the below instructions:
  1. Go to top-right corner (see the image below) and you will find arrow sign as Ribbon Display Options  and click on it.
2.  From the drop down Manu you can select your minimizing option

 Auto-hide Ribbon:  to display your spreadsheet as full- screen or hides your Ribbon, you can use Auto-hide/show Mood. See the below given image where for showing or hiding the Ribbon by clicking.

The Quick Access Toolbar

 You will find Quick Access Toolbar just above (left corner) the Ribbon. For quickly access in some common commands click on your desired commands like save, undo or Redo. You can add more commands on Quick Access Toolbar  

To add more commands on Quick Access Toolbar:

  1. First go to Quick Access Toolbar and you will see the drop-down arrow and then click the drop-down arrow.
  2. Secondly, from the drop-down arrow click on the command which on you want to add.

  3.Now the new chosen command will be added on Quick Access Toolbar.

Backstage view:

In Excel 2010/2013 Backstage view is new added which allows you to access various like save, print, opening new file or sharing your spreadsheet.

How to access Backstage view: just click on file then you will get info written page with back arrow sign.

Below to learn more about using Backstage view. If you click on arrow you will back to the previous page.


Worksheet views

In Excel 2013, there are three types of viewing options for displaying your worksheet located in the bottom right of worksheet. . These are Normal view, Page Layout view, or Page Break view. These three views are used in various issues especially for printing.
  • If you want to change worksheet views, just click on your chosen view command (see the below image).
Normal view:  Here you will see at the below normal view (default view) of worksheet.

Page Layout view: Again look at the below given Page Layout view of worksheet which will help you basically for how the print will look.

Page Break view: Look at the below Page Break view of worksheet by which you can change the location of page breaks and help you to print huge data from worksheet.

Excel 2013:

How to Customize the Ribbon:

If you want to create your desired tab with chosen commands, you can customize the Ribbon. here you can create command by custom group or without group or whatever you wish. For your purpose, follow the below instruction.
  1.  To start the customization, Right-click the Ribbon (see the below image) and then from the drop-down menu select Customize the Ribbon

2. Then you will get the below Excel Options dialog box. From here chose and select your chosen New Tab.

3. Now after selecting the New Group, next select a command, and then click on Add.  For easily doing, you can drag it into a group.
4. After finishing your adding commands, click OK.  You will get the new command on Ribbon.

NOTE: If you don't find your desired command, click on the Choose commands from and then from the drop-down box, you can have to select All Commands.



No comments:

Post a Comment