Wednesday, October 22, 2014

Let’s Start with MS-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.
OBJECTIVE:


  • 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  
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.