fbpx

Category

Tutorials

If you use ALT + TAB to toggle, read these 6 lines…

We all use Alt-Tab to toggle different windows of applications. Even though we use this key shortcut to do our daily job yet we don’t know this tricks. Alt-Tab ↹ is the common name for a keyboard shortcut that has been in Microsoft Windows since Windows 3.0. This shortcut switches between top-level windows without using...
Read More

What can you do on a date… err… with a date in excel ?

Dates are one category of information that is found in ALMOST ALL Excel reports. You can maneuver with them like a Maverick (Read: Tom Cruise’s starrer movie – Top Gun) These are the things you can do with a date in excel: You can find which day of the week it is (e.g. Sunday, Monday…)...
Read More

How to protect cells and hide formula in excel ?

Investment banker protects the excel file by password and hide formula also hide formula in google spreadsheet, but anyone having access to the file can easily access the formulas used in the cell by having a cursor on the cell. As part of our continued Excel Training series,  you will learn how to protect cells...
Read More

Excel VLOOKUP Function

Before we learn how to use Excel VLOOKUP function, we must learn when do we use Excel VLOOKUP function? Task: Imagine if you have to find when does train no. 6948 departs in the schedule chart above? Your approach: You will scan the first column top to bottom. When you find the same train no.,...
Read More

How to make original Good-looking Presentation slides

Guide to make original Good-looking Presentation slides. Today, if you want to succeed in your corporate job, you must know how to impress the ‘higher-ups‘ of your organization using your presentation slides.
Read More

What-if Analysis using Excel Dashboard, Indirect Function

In this topic, I will try to cover the features of what-if Analysis. It is a tool that allows you to try to different formulas. If you apply what-if analysis you will notice changing the values in cells and how those changes will affect the outcome of the formulas in your spreadsheet. Before we start...
Read More

INDEX Formula in Excel

Excel Index Formula is probably one of the most favorite Excel Formulae of many. In my previous post, I had mentioned about my favorite Excel formula. And it was not INDEX(). In my excel training sessions, when I happen to ask my participants about their favorite Excel formula, I am not surprised to hear the answer...
Read More

PowerPoint Picture Tools to Create Magnifier Glass Effects

Learn a new PowerPoint trick using picture tools: Magnifier Case Study: Let’s say my company has launched a new water dispenser. I would like to highlight the new features of the product. To do so, I will like to use a magnifier like an effect to attract the viewers attention (Picture tools). This is a...
Read More

Excel Versions: Evolution of Spreadsheets [Infographic]

Excel versions aka Spreadsheets have a come a long way over the years and plenty of companies today are attempting to build the best one. Spreadsheets have been used by accountants for hundreds of years. Computerised or electronic spreadsheets are of much more recent origin. Information Systems oral history and some published newspapers and magazines...
Read More

Advanced Excel Formula Auditing

Microsoft Excel has a lot of features one of it is excel formula auditing. It has a variety of powerful tools that allow checking what is happening in your spreadsheet. Today we will discuss on Advanced Excel formula. It helps you to get the relations between formula and your cells. Which cells are using the...
Read More
1 13 14 15