Tag Archives: Excel 2010

This post will cover how to create a simple graph for each record, using REPT function. The parameter are very simple to follow, you just need to specify Text ,and Number of Times you want to repeat the text. It is the simplest way of visually observing the  performance and status of person record. Read More

Excel provides option of changing the worksheet gridlines. You can change the color of gridlines, make them apparent on hard-copy, and even remove gridlines. Follow the simple procedure to change different settings of gridlines in Excel 2010, Read More

Excel Macro feature lets you to record actions you perform on worksheet, and run the actions again for future use. But it would be extremely useful if you can run macro with a simple click on button, rather than running it manually.  By creating macro-buttons you will be able to associate macros with buttons, and show them on the worksheet for performing different tasks you have recorded with macro. Excel enables you to create custom buttons to link macros with them, this post will elaborates how to create macros and associate  buttons them with. Read More

Excel Chart provides a way to represent data visually, but by customizing chart we can convert it in to pictograph (graph with pictures). It is an ideogram which convey its meaning through depicting images which resembles real-world objects, eventually making chart self-explanatory. Enhancing the chart would be very useful, it makes your audience comprehend the table data, without even looking at it. In this post we will be creating a simple pictograph. Read More

If you have been caught up in the maze of numbers and values all day long in Excel, then it would be fascinating to create scatter graph for your datasheet. With Scatter graph & Trendlines you will be able to grasp the trend of your data. With this data visualization tool you can help your audience to understand the crux of the datasheet by visually conveying them what data actually means, and most importantly help them to comprehend the trend of your datasheet values. This post will put some light on it. Read More

Excel allows user to filter data in numerous ways. Using Slicers, you will be able to depict the datasheet fields more comprehensively. This feature lets you to slice your data by showing only the element stored in the tables.  However, the real usage of Slicers can be seen with pivot table. Unlike Pivot table, which pivots down the datasheet, it enables you to compare and evaluate the data from different perspectives. This post will explain how you can use Slicer with Pivot Table and Charts. Read More

With Excel 2010 Camera tool, you will be able to take a snapshot of a selected datasheet portion. This enables you to place a live picture anywhere in the worksheet, you can apply different styles, colors, and designs over it. Apart from taking an exact screenshot of the highlighted data set, it also syncs the data with the image; whenever you make changes to the original data set, live image gets updated, showing you the latest cells values. You can easily copy the snapped data set to clipboard and share with others. Moreover, all image related effects can be applied over the data set snapshot. When you select the image, image tools tab appears on the ribbon, allowing you to change the orientation of the image and apply different styles. In this post, we will guide you through the process of enabling Camera feature on the quick access toolbar and applying different effects over the data set snapshot. Read More

There are many ways in which you can enter time into cell, but Excel has an built-in function which facilitates users to convert values into time format, by using this function you can convert data in hrs:mm format, and hrs:mm:sec format. It automatically shows military time format against the suitable values in the cell. This post covers how to change values into time format. Read More

Excel Payment (PMT) function is extremely useful when you need to know the monthly payment amount on full loan/credit payment, it actually evaluates amount to be paid monthly on the basis of credit amount, interest amount, and time. The basic parameters of this function are rate, nper (number of payments), pv (present value), and fv (future value), so if you need to calculate an amount which also considers these parameters, then this post will help. Read More

Excel HLOOKUP function can be used when you are dealing with huge datasheet and need to look up the values of the specific record. HLOOKUP stands for Horizontal lookup, used to find specific data from the datasheet. Unlike VLOOKUP function, it looks for the values horizontally which enables the user to extract a complete record. This post elaborates how & where you can use HLOOKUP function. Read More

Excel 2010 SmartArt graphics enables user to present their data presentation across, in a very flamboyant way, with it you can add different colors, shapes, layouts, and much more. Unlike charts and other pictorial representation tools included in Excel, it empowers you to create graphics that best describe your data and to make your audience understand the crux of it. You can choose a graphic from the list, containing loads of design and layouts. Read More

Excel has an inherent quality of working with XML file even if it doesn't comply with universally accepted  standards, XML file may contain data in incompatible formats, which eventually begets the problem of exchanging data between systems over the internet. Converting data in to XML can mitigate the probable of encounter any incompatibility problem. XML is use to store data in files or in databases, and through Excel 2010 you can retrieve data from XML files for performing advance operations over it. Read More

By default, Excel uses relative referencing, that's mean if you want to use the same formula somewhere else in the datasheet, it will be automatically changed with its original reference. In some cases, a relative reference is useful, but when you want to apply the same formula with absolute reference, you need to slightly change the formula. In this post we will check how how absolute and relative references work using a simple example. Read More

Excel VLOOKUP function can be used when you need to look up the values in the specific table and check it against the other data fields for comparison purpose. VLOOKUP stands for Vertical lookup, used to find specific data from the datasheet. By creating a sample table generally referred as lookup table you can extract info from it and compare it with the desired field to yield required results. This post elaborates where you can use VLOOKUP  function. Read More

Excel 2010 enables user to insert objects, which could be very useful if you want to embed different objects in to the datasheet, but when it comes to embedding video file in to datasheet, it does not support it directly. If you have been looking for a way to embed video to complement the datasheet or for illustrating any process, then this post will help you by elaborating the easiest way possible to embed video in Excel datasheet. Read More

Sometime it happens that you need to send Excel worksheets via email, but for that you don't need to follow the orthodox way of sending datasheet by attaching it with email. Excel provides a tool, which enables you to send it over with a single click. This post illustrates how to make Email option apparent in Excel 2010, and how to use it. Read More

Excel 2010 Data Bars makes it easier to observe that how data values relate to each other. This feature represents data graphically inside the cell, and helps user to compare data cells more effectively and efficiently by adding bars, which defines the data of the cell. It is better to represent the data graphically rather then using orthodox Conditional Formatting style. This post will cover how to make the most of Data Bars, in a simple datasheet. Read More

In Excel 2010 by using COUNTIF conditional logic, you will be able to count occurrence of data and show the result if the condition is met. It enables user to use a condition that contain two arguments (range,criteria), that would be applied on data which yields counting results, only if specified criteria is TRUE. Thus facilitating user to create a group for certain type of data that falls into specific category. This post explains simple usage of COUNTIF logic.

Read More