Introduction to Microsoft Excel and Creating First Excel File

Home/Excel/Introduction to Microsoft Excel and Creating First Excel File

Microsoft Excel is one of the tools in the Microsoft Office Package; it is used to create spreadsheets. It has many in-built functions and tools to work with data and create different type of reports and dashboards. It also provided the feature to the users to work behind the existing tools and can enhance its capabilities. To implement functionality beyond a regular spreadsheet, Microsoft Visual Basic programming environment is provided with Microsoft Office Excel. This programming language is called as Visual Basic for Application (VBA).



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

In This Section:

What is Excel?
As explained above, Microsoft Excel is one of the tools in the Microsoft Office Package. It is a spreadsheet application, it have powerful tools to deal with the data and create different kinds of reports, dashboards, tools.

Why is it used?
Almost every organization uses Excel for thier day to day activities from requirement gathering to deliver and present the output.

  • Preparing the initial project plans and documents.
  • Preparing the different kinds of templates, MOM Template, Quality Checking Template, RCA Template, Process Flow Templates, Project Management Templates, Cost Estimation Templates, etc…
  • Preparing different kind of dashboards, Scorecards to analyse KPIs which includes rich visualized charts, tables and formats
  • Developing the tool to automate the repitative task to increase the quality of the outputs and save the process time.

Creating your first excel workbook:
You can launch the Excel application in different ways and enter the data and then we can save the file in desired location.

To open a new excel workbook:
» Goto Start Menu
» Select All Programs
» Select Microsoft Office
» Select Excel


» Open run dialog
» Type excel and then Enter

It will open a new excel workbook

To save the file:
» Ctrl+S OR Choose Save from the File Menu of the Excel workbook
It opens a file dialog box
» Choose desired location
» Give the desired name
» Click on the Save button to save the file

By |May 2nd, 2013|Excel|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment

Related pages

concatenate function excelvba open documenthow password protect excelvba inputbox cancelexcel vba programingexcel hyperlink to foldervba runsqlvba uppercollections in vbasas do until loopexcel chartingcreate line chart in excel 2010excel macro cellsworksheet tabssort highest to lowest excelexcel vba arraycolor code vbahow to determine duplicates in excelupdate sql vbasql server query examplevba delete duplicatesspecial characters in excel formulasmerge columns excelddl dml dcl tcl commands sql serverhow to create a userform in excel 2010substitute formula in excelexcel macro to change cell colorcreating excel macrovba pivot tabledatabase interview questions for freshersexcel instr functionvlookup returns naexcel mysql querytextstream vbaautofilter excel vbaexcel 2007 unhide sheetwhere is the pivot table in excel 2010creating a scorecard in exceldashboard ppt templatesql operatorsexcel vba this worksheetcreating an if statement in excelhow to format rows in excelexcel 2010 unprotect workbookmsgbox vbokonlyxml convert to excelexcel macro buttonsmacro to close workbookadvance vbavlookup examples in excelinserting check box in exceldisplay message box vbaoption button excelpyramid templatesworkbooks open vbahow to select different rows in excelexcel 2007 macroswhat is ascending order in excelproject schedule template xlsado excelpivot table sample datamake drop down list in excel 2007sql developer interview questions and answers for experiencedexcel macro copy rowms word meeting minutes templateexcel chart wizardwhat is merge cells in excelwhat is hlookup in excelhlookup formula in excel 2010useful vbs scriptsif and isblank excel formulavba excel delete rowformula sumifsave macro in excelstacked clustered chart excel 2013reference excel cell in vba