Copying Moving and Pasting Data in Excel

When we are working with the data most of the time we may required to copy/move the data from one location (range) to another location. This tutorials will explains you Copying Moving and Pasting Data in Excel.

Moving a Range in Excel

We can Move the data from one range to another range by using either short cuts or in-built commands.
If you want to Move the data from one range another location:

First we need to Select the existing Range => Cut it => Choose a New Range => Paste it

Select Range to Move:

Cut it: Press Ctrl+ X or right click and select Cut command.

Choose a New Loaction:
 

Read More...

Formatting Data and Formatting Cells in Excel

Microsoft Excel provides us the tools to make rich formats, we can format the numbers, fonts, font color, background color, alignments and many more things we can do in Excel. This tutorial section will help you to learn Formatting Data and Formatting Cells in Excel.

We have many tools in Excel to work with Formatting

Home Tab

If you observe the Home Tab, you can see many commands to work with formats.

Font

We can use these commands to format the Fonts Styles like Bold, Underline, Italic, Font size, Background Color, Font Color etc. You can click on the icon at bottom-right corner to see the more Font Settings.

Read More...

Entering Data and Moving in Excel Worksheet

Entering Data and Moving in Excel Worksheet is very easy and you find that it is the time saver for data entry. You can enter any numbers, text, dates in Excel and you can format as per your requirement.

Entering Data

In order in enter data into your worksheet, you need to activate the cell by locate your mouse point to any cell When your cell is activated, it become Active Cell. Active Cell is the place where we enter the data. When we open a new Excel Workbook, by default it activates A1 (top-left corner of a Worksheet) position of a Worksheet and we can start entering the data.

We can see the cell A1 is activate and you can see the Address of the active Cell in the Address bar (rounded with red circle), you can also observe the sample text in A1.

We can also activate a Cell and enter the data in Formula bar.

Read More...

Getting Started with Microsoft Excel

In this section I will introduce the basic features of Microsoft Excel, one of the tools in the MS Office Package suite.

What is Excel?

Microsoft Excel is a very popular spreadsheet application. It has effectively become the standard and these days the word 'Excel' is synonymous with 'spreadsheet'. Excel is a spreadsheet application used to enter the data (text, numbers, etc…) to perform calculations, analysis and store it in a excel file. There are many built-in functions and formulas allow you to perform calculations and you can create attractive, readable presentations and rich visualized dashboards including charts, table,etc…

Why Should I Learn MS Excel?

MS Excel is used with many purpose because Excel:

§  has ability to Store Data and is easy to use and flexible to do the  any changes

§  can makes calculations of complex formulas

§  can works great as a basic reporting tool, you can Dashboards and Rich Visualized Templates

§  can interact with Other Applications and Databases

§  is widely using as Data Mining Tool to Process the data, Reporting and Presentations

§  has programming Capability, you can code and build the tools to automate your tasks known as “Macro”.

Starting Excel

You can start Excel by
1. Double Click on the Excel Icon on your Desktop
Or
2. Go To Run and type excel to Start Excel Application
Or
3. Click on Start Button => Select All Programs => Select Microsoft Office => Click On Excel to Start Excel Application

Exploring the Excel Interface

When you Start Excel Application, it will Open an Excel Workbook, It is the main file having collection of Worksheets. Each Worksheet look like table with Rows and Columns, and the smaller entity in the Worksheet is called a Cell where we can enter the data.

At the top of the Worksheet you can find Menu Bar also called Ribbon, collection of built-in functions and utilities are available to execute our tasks.

Entering and Editing Data

We can enter text, numbers,dates in a Cell and we can modify and update the existing data.

Formulas and Functions

There are number of formulas and functions available in Excel to deal with your data to get the required results.

Excel Built-in Tools

There are number of tools available in Excel, which help you to play with your data to achieve required results.

Read More...

Introduction to Microsoft Excel and Creating First Excel File

Microsoft Excel is one of the tools in the Microsoft Office Package suite; 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).

In This Section:

§  What is Excel?

§  Why is it used?

§  Creating your first excel workbook.

What is Excel?

As mentioned 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, and tools.

Why is it used?

Almost every organization uses Excel for their day to day activities from requirement gathering to deliver and present the output using excel.

§  Preparing the different kinds of templates, Quality Checking Template, Process Flow Templates, Project ManagementTemplates, Cost Estimation Templates, etc…

Read More...