#thinkleaf training

[thinkleaf]

Hiding Charts, Shapes and Pictures in Excel – Microsoft Excel Tips

Hiding Charts, Shapes and Pictures in Excel – Microsoft Excel Tips

We all are familiar how to hide rows, columns and even sheets in excel. In this posting we are going to explore on options how to hide graphical objects like charts, pictures, SmartArt, shapes which are present in an excel sheet. There are some times we would like to share the report which contains only the data. What if we already have some graphical objects like charts, pictures etc. In this…

View On WordPress

[thinkleaf]

Create Your Own Tab in Excel 2010 / 2013 – Microsoft Excel Tips

Create Your Own Tab in Excel 2010 / 2013 – Microsoft Excel Tips

Based on the field of work and type of data we use certain features of excel frequently. If you are using Excel 2010 or greater then you can now add new tabs to the Excel ribbon. When you create a tab, you can place those frequently used features on it, so that you do not have move around to different tabs to access them. Custom tab created by yourself will house everything you need to work on…

View On WordPress

[thinkleaf]

How to use WATCH WINDOW in Excel – Microsoft Excel Tips

How to use WATCH WINDOW in Excel – Microsoft Excel Tips

Let us take a situation to understand, how to use the WATCH window feature of excel effectively. You have an excel file which contains 13 sheets in total, for every month data you have provided a sheet and 13th sheet you have the consolidated data. You have a cell value in the 13th sheet, if you change it, all the 12 sheet formulas are going to be affected. Taking this situation, if you really…

View On WordPress

[thinkleaf]

VLOOKUP Formula With Wild Characters - Excel Tips

VLOOKUP Formula With Wild Characters – Excel Tips

Wildcard characters are mainly used when we search for certain types of files in our computer. In Microsoft Excel, we use these wildcard characters in filters, formulas even in VBA codings. Wildcard characters are used when you are searching text values based on its length or based on criterias like starting with / ending with / containing a specific character in a text value.

? and * are called…

View On WordPress

[thinkleaf]

Calculating Multiple Conditions Based Total Using SUMPRODUCT - Microsoft Excel Tips

Calculating Multiple Conditions Based Total Using SUMPRODUCT – Microsoft Excel Tips

SUMPRODUCT is widely used to perform complicated summarization based on multiple conditions. When you need to add two or three columns of data based on four different conditions, SUMPRODUCT can be a real deal.

We can do it through SUMIFS but it will be multiple SUMIFS which is added finally using SUM function to arrive to such kind of result. SUMPRODUCT will do the job much easily using two…

View On WordPress

[thinkleaf]

What is WBS and how do we create them? - Microsoft Project Tips

What is WBS and how do we create them? – Microsoft Project Tips

WBS stands for “Work Breakdown Structure”. As we have discussed in our earlier posts, summary tasks and sub tasks are smaller parts of our bigger goal which is our project. In order to manage our project well, we need these smaller manageable parts. Allocating unique ID value for these manageable tasks are called WBS codes. These codes are used in project while we need reports on scheduling and…

View On WordPress

[thinkleaf]

Creating Recurring Tasks In Your Project – Microsoft Project Tips

Creating Recurring Tasks In Your Project – Microsoft Project Tips

Recurring tasks are the tasks which repeats at a regular intervals in our project. Let us think, what are the tasks repeats at a regular interval in our project? Client Meetings, Conference Call With Client, Internal Team Update Meetings etc. In this posting we are going to see, how we schedule these kind of recurring tasks.

1. Click on the blank row, where you want to create the recurring task.

View On WordPress

[thinkleaf]

Creating Summary Task – Microsoft Project Tips

Creating Summary Task – Microsoft Project Tips

When you have a bigger goal to accomplish, the experts’ advise us to break it down to manageable phases and manageable phases are further broken down to smaller tasks. Even in Project world, our Project is the major goal for us, to accomplish them, you needto break down the project into Phases and Phases should be further broken down to tasks. Here the Phases refers to “Summary Tasks” and smaller…

View On WordPress