Free Excel Help – Chart Titles

There are many features available in Microsoft Excel that could help you in making your presentations come to life. One of the features is that you can make use of are Microsoft Excel charts and graphs, which help you when it comes to presenting large amounts of numerical data. There are a lot of choices […]

Read More
Free Excel Help – Macros

Tired of repeating the same manual operations while managing data? It is very understandable. Repeating the very same action again and again, day in and day out, can be very frustrating not to mention expensive.  Excel spreadsheets can be managed effectively, repeating tasks and getting frustrated can be successfully prevented in Microsoft Excel using Macros. […]

Read More
Free Excel Help – Named Ranges

Dynamic named ranges are one of the strongest aspects of Excel. It is commonly used in listing the controls, PivotTables, and charts. First thing is to formulate a list in column of A of your worksheet. Before anything else, there are still problems that could surface such as the updating or redefining of the named […]

Read More
Free Excel Help – Arrays

A variable which has is a similar type but holds a different value is what an array means. It is used in almost every programming language which can also be mixed or paired to different variables for a simple or more complicated structure of data. Due to the property of an array that it holds […]

Read More
Free Excel Help – Updating Pivot Tables

A Pivot Table is very useful in visually deriving meaning from data. It is also very helpful in analyzing the relationships between the data’s columns and the rows. Manipulation of data, viewing of data in different perspectives, and other data related actions can be done in the Pivot Table, dynamically. After creating the Pivot Table […]

Read More
Microsoft Excel Pivot Tables

Microsoft Excel Pivot Tables are used in the user’s spreadsheet to present quantitative data in an easy and user-friendly manner to allow the user to quickly analyze large amounts of data. To manipulate data in an Excel PivotTable it must have data that is capable of being able to be categorized or grouped. To create […]

Read More
Free Excel Help – Pivot Tables Data

In Microsoft Excel, Pivot Tables are interactive tables allowing the user to summarize and group numbers of data in a tabular concise format for easy analysis and reporting. Excel Pivot Tables aim is to count, total and sort the data, thus, this table is also available in Microsoft Access. It was originally called Pivot Tables […]

Read More
Free Excel Help – Keyboard Shortcuts

Free Excel help article on Microsoft Excel keyboard shortcuts. Navigating within a worksheet Keyboard shortcut                                          Action Tab, ->                                                             Skips to the next cell on the right Shft+Tab, <-                                                    Skips to the cell on the left ?                                                                     Move one cell up. ?                                                                     Move one cell down. Ctrl+->                                                             Move to the last occupied cell of a row of data Ctrl+<-                                                             Move to the […]

Read More
Free Excel Help – Keyboard Shortcuts For Business

For most people, when it is your first time to work with Microsoft Excel, you will concentrate on just completing your task rather than learning how to work efficiently for a faster completion of your task. That can usually be said for any software application. However, when you are ready to learn about the keyboard […]

Read More
Free Excel Help – Date Function

In this free Excel help article we will look at some more of the Microsoft Excel date functions. To this list we will also add some of the Microsoft Excel time functions too as they both go hand-in-hand. EOMONTH  – The function stands for End Of the Month. It is a very useful Excel function […]

Read More
Free Excel Help – Dates Functions

In this free Excel help article we’ll look at some of the Microsoft Excel’s Date functions. The format of the date used in our article is mm/dd/yyy but this of course can be changed in Microsoft Excel. TODAY – This is a function that does not take in any arguments.  Used in a cell as […]

Read More
Free Excel Help – TAN Function

Microsoft Excel is a spreadsheet that is used by business to manage data. By default, when you create a new Excel workbook the workbook will contain three worksheets. Sheet is a shortened name for a worksheet or spreadsheet in Excel. A worksheet is comprised of a grid or table composed of columns and rows making […]

Read More
Free Excel Help – Data Consolidation

For our example let us consider several Microsoft Excel worksheets say for the various months from January till December containing sales data spread across an array of cells ranging from B5 to E16. Now suppose we wish to do a sum function just on only the data for the months of January and February, i.e. […]

Read More
Free Excel Help – Conditional Formatting

It never amazes me at what an enthusiastic response I get when I first introduce someone to the Microsoft Excel Conditional Formatting feature.  Out of all the things Microsoft Excel can do, this one seems to get some of the most excited responses.  People just love it and want to learn how to use it.  […]

Read More
Free Excel Help – AutoFilter

Have you ever used a Microsoft Excel AutoFilter? If not have you at least heard of it? No, well let me give you a quick overview of the Excel AutoFilter. The Excel AutoFilter allows you to filter and sort records based on one or more criteria. You do so using a simple interface, a drop-down […]

Read More