Articles by "MS-Excel"

Showing posts with label MS-Excel. Show all posts

,

What is a Pivot Table?


Pivot Table, basically, is a data summarization tool, that can automatically sort, count, total or average and can summarize a data table as per your needs. This is quite simple but very useful MS Excel tool that works on drag-and-drop concept.

To know more about Pivot Table, watch the video below:


[youtube src="GCeYCGzmqN4" frameborder="0" allowfullscreen"/]




P.S. We don't own this video, this video is posted on YouTube by Dave Bruns on his YouTube Channel Exceljet. He is awesome feel Free to Subscribe his Channel.

,

MS Excel 30+ Shortcuts


When you are working on MS Excel, knowing some basic shortcuts will surely save your time and energy. Also, it feels cool finishing up the work in style when you don't want to struggle with mouse. Do it there on the keyboard itself.


So, here we are with a video on 30+ MS Excel Shortcuts. You will definitely find them cool.


P.S. We don't own this video, this video is posted on YouTube by Dave Bruns on his YouTube Channel Exceljet. He is awesome feel Free to Subscribe his Channel.


[youtube src="k_MIeDLEgC8" frameborder="0" allowfullscreen"/]

, ,


Knowledge of MS Excel is a must nowadays. Whatever you do at your workplace has a substantial dependency on this Spreadsheet Software.

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.

But, the main problem we face using MS Excel is not knowing which functions to use and where?

Here is the complete guide that contains various examples of over 150 functions. Click on the link below to download this MS Excel Function Dictionary >>



 Download




The entire app is an Excel document that you can navigate through with the help of several buttons and links.

You can view the entire list of functions by accessing the Index from the interface. This is divided into several columns, such as name, category, location and a small description.



You can access Function Index, Function Examples and Catagories on a single click as shown in Screenshot above.

Accessing any of the entries provides a more thorough description of the function, the syntax, formatting and some examples. These should help you understand each function and enable you to use them properly.


Try this MS Excel Function Dictionary and share your views with us in the comments section below.


:: Don't forget to Share this with your Friends if you liked the information provided above! ::

Author Name

Contact Form

Name

Email *

Message *

Powered by Blogger.