Connect with Peer Bloggers
Get your Bloggers ID and network with best bloggers around the world.
4
vlookup(), match() and offset() in Excel Formula – explained in plain english [spreadcheats]
office 2010 excel ― VLOOKUP may not make you tall, rich and famous, but learning it can certainly give you wings. It makes you to connect two different tabular lists and saves a ton of time. In my opinion understanding VLOOKUP, OFFSET and MATCH worksheet formulas can... (more)
ShallyD ―
Posted on Feb 2nd, 2012
- Share
- Comment (0)
- Views (18)
- Bury
5
Excel Formula Errors – Understand and Debug Them
office 2010 excel ― “Trial and Error” has to be the most effective ways to learn something new. Most of the stuff I learned in my life is through that. Be it insurance or excel or programming. My learning has always gone up when I make a mistake. I am sure most you... (more)
ShallyD ―
Posted on Feb 2nd, 2012
- Share
- Comment (0)
- Views (17)
- Bury
5
check what version of PowerPivot for Excel is installed on my machine?
office 2010 excel ― A: There are few ways to check version of PowerPivot for Excel that is installed on your machine.Option 1:Start ExcelGo to menu "PowerPivot" and then click on the button "Settings" New window "PowerPivot Options and Diagnostics" will pop up with... (more)
ShallyD ―
Posted on Feb 1st, 2012
- Share
- Comment (0)
- Views (25)
- Bury
6
How to install PowerPivot for Excel and list of know issues
office 2010 excel ― Step by step guide on installing PowerPivot for ExcelIf you are running an operation system other than Microsoft Windows 7, install .NET Framework 3.5 SP1 first.Download and install Microsoft Office 2010. Important note: To work with PowerPivot you... (more)
ShallyD ―
Posted on Feb 1st, 2012
- Share
- Comment (0)
- Views (22)
- Bury
8
How to Program Macros in Microsoft Excel
office 2010 excel ― Microsoft Excel is a spreadsheet application that offers an extensive set of features to customize your workflow. Macros are one part of the program that considerably extend its functionality. A macro is a small program that runs inside an Excel... (more)
ShallyD ―
Posted on Jan 18th, 2012
- Share
- Comment (0)
- Views (20)
- Bury
7
How to Write a Simple Macro in Microsoft Excel
office 2010 excel ― 1-Define exactly what is it that you expect your macro to do. While macros are usually short, they're still programs, so you have to have a clear idea of its final behavior.2-Go to Tools->Macro->Macros... in the menu to bring the Macro dialog.... (more)
ShallyD ―
Posted on Jan 18th, 2012
- Share
- Comment (0)
- Views (19)
- Bury
7
Adding a Range Name in Excel
office 2010 excel ― Excel Range Name OverviewA range in Excel is a group of one or more cells in a worksheet.A name can be given to a range to make it easier to identify this cell or cells when creating formulas or charts.Range names are created by selecting the... (more)
ShallyD ―
Posted on Jan 18th, 2012
- Share
- Comment (0)
- Views (23)
- Bury
7
Convert a Row to a Column in Excel the Easy Way
office 2010 excel ― Sometimes we’ve entered data in a column in Excel, only to realize later that it would be better to have this data in a row, or vise-versa. Here’s a simple trick to convert any row or set of rows into a column, or vise-versa, in Excel.Please... (more)
ShallyD ―
Posted on Jan 13th, 2012
- Share
- Comment (0)
- Views (19)
- Bury
8
Add Windows Calculator to the Excel Quick Launch Toolbar
office 2010 excel ― If you like to use Windows Calculator to perform quick calculations while in Excel, you can save time by adding it to your Quick Access Toolbar.Click Customize Quick Access Toolbar and then choose “More Commands”. On the left hand side choose ... (more)
ShallyD ―
Posted on Jan 13th, 2012
- Share
- Comment (0)
- Views (20)
- Bury
9
New Attributes in Excel
office 2010 excel ― Your Microsoft 2010 will come with characteristics that will lead to integration of your on the net computer system use with your Pc more immediately. This will be the continuation of pattern which was there strongly in Windows XP and Windows 7.... (more)
ShallyD ―
Posted on Jan 9th, 2012
- Share
- Comment (0)
- Views (18)
- Bury
10
Microsoft Excel 2010 simplified my daily tasks
office 2010 excel ― I am currently working as a store manager in ‘Next Super Market’, a store located in the outskirts of New Jersey. It is a small set-up and every employee is expected to multi-task. I am the only person handling the store; managing its resources... (more)
ShallyD ―
Posted on Jan 9th, 2012
- Share
- Comment (0)
- Views (20)
- Bury
9
Retrieval and Recovering Corrupt Excel Files Data
office 2010 excel ― MS excel is a user-friendly spreadsheet application meant for calculations, data maintenance and data keeping at the same time. Working conveniently with rows and columns and using formula, it becomes a preferred choice of users who invest much time... (more)
ShallyD ―
Posted on Jan 6th, 2012
- Share
- Comment (0)
- Views (22)
- Bury
11
Recovering Excel Files 2010 in Best Practicable Manner
office 2010 excel ― Excel spreadsheets have specialization that they allow users to editandarrange the database that has been entered in lists and tables. XLS files of MS Excel helps you to keep up a track of the CDs in your hush-hush music or movie collection, planning... (more)
ShallyD ―
Posted on Jan 6th, 2012
- Share
- Comment (0)
- Views (20)
- Bury
13
Use Sparklines in Microsoft Excel 2010
office 2010 excel ― Sparklines are new to Excel 2010 and look set to become a very popular tool. Essentially a Sparkline is a mini-graph which occupies just one cell within the spreadsheet. They're useful for spotting trends in data, in much the same way that the... (more)
ShallyD ―
Posted on Jan 6th, 2012
- Share
- Comment (0)
- Views (20)
- Bury
10
Building Excel Formulas
office 2010 excel ― Formula BasicsFormulas must begin with the equal sign (=); that's how Excel distinguishes them from values and labels.You can construct formulas that subtract, multiply, divide, and exponentiate. The– symbol means subtraction, the * means... (more)
ShallyD ―
Posted on Jan 5th, 2012
- Share
- Comment (0)
- Views (21)
- Bury
Find Topics
Popular From: ShallyD
