Excel Tips and Tricks

Excel Tips and Tricks Excel in life
Excel Tips and Tricks
Excel in life
this website will talk about excel formula and functions and macros
Just here for the view

Most recent posts

11/17 14:51 Access Query from MS Excel
In Microsoft Office 97, the default path for the Northwind database is \Program Files\Microsoft Office\Office\Samples\North... A QueryDef is created in Microsoft Access and saved with the database file. It consists of a query and may or may not...
9/27 12:32 Comment Box Shapes and Picture
Bored with the same rectangle yellow comment boxes on your file? Here is a way to change them to shapes of your choice with picture on it (I am Using Excel 2007)Select the cell with the commentPress Shift+F2 to edit the comment boxSelect any border...
9/14 11:42 Get rid of GETPIVOTDATA Option
If you want to disable the Generate GetPivotData setting, follow these steps, as appropriate for the version of Excel that you are running. Microsoft Excel 2003On the Tools menu, click Customize. <
8/17 10:00 INFO function
=Info() can be used to get information about the location of the file, information about the OS, excel version, about the memory status etc....Here are some examples:=info("directory") Path of the current directory or folder.=info("memavail") Amount...
8/07 13:12 Some Text functions
We will see some Text functions which can be very useful:1. TEXT() :This functions formats a number and convert it to Text. For E.g., Cell A1 is having date 1/1/2009. We can convert this date to text in whatever format we like; e.g.,...

People who like this blog also like

Other blogs by this author

Advert approval stats

Average advert is approved in 1 hour
A low time means the owner takes their buyers seriously and doesn't tie up their credits.
0.00% of advert requests declined
Higher percentages suggest a more discerning site owner, applicants should check their advert is likely to fit with the blog topic and format
0.00% of approved requests declined
Higher percentages indicate a risk of last-minute cancellation