fbpx

Category

Tutorials

7 formula error in Excel that make you look dumb

In this blog, I will try to help you to debug your Excel Formula. As soon as you will use excel formula, you will likely need to know how to correct the error in excel formula. First of all, we need to know how many types of error, we can get we are applying excel formula...
Read More

Create Drop Down List in Excel using Conditional Formatting in Excel

Introduction Let’s say you have a worksheet with thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw information. Similar to charts and sparklines, conditional formatting provides another way to visualize data and make worksheets easier to understand. Best features of conditional formatting in excel which if coupled...
Read More

Learn how to customized Header & Footer in printing excel sheet

This time under printing setting we will talk about headers and footers. Specially customized header and footer. Let me go to page layout. Under which let me click on the small icon which will lead me to page setup. Let me now access the tab of header & footer. Now there are some predefined templates of header. So one of them says page 1 of 10. The question mark stands for...
Read More

How to print titles and columns on the left in Excel? | Printing in Excel

One of the ignored areas in Excel is how to print a workbook or a worksheet. In this blog, I’ll talk about some of the tips and tricks like how can you make the printing in Excel look easy, better and more functional. Starting with above case study with a raw data which spans over multiple rows. So I have...
Read More

Don’t do these 10 things while preparing a financial model

A financial model is basically an abstract presentation on a real life financial problem. Making and referring to this can be really helpful in terms of economics and business management. Many of students in my Excel Training session ask about financial modeling and its do’s and don’t. As there are certain mistakes people tend to...
Read More

Learn Clipboard and 2 more special Table tricks in Microsoft Word

This tutorial helps you to uncover the hidden importance of Clipboard and how you can use various instances of copy + paste. We also work around table (one of the most hated areas in word) Checkout our Microsoft Word Online Tutorial Course. Click Here (In this Course, you will learn Basic To Advanced MS Word...
Read More

Email To-Do list to Team members in One Click using Excel VBA

In this blog, we will discuss how to email To-Do list from your outlook mail to respective team members. You would have sent email from outlook but probably not using Excel VBA Code. For example, you have a To-Do list in your excel file with tasks assigned to each team member and you need to send...
Read More

VBA Code to password protect excel for a shared Excel file

In this blog, we will try to cover how to password protect Excel Sheet based on the User as part of excel VBA tutorial. For Example, you have a master excel sheet in your centralized location. Now everyone can access the same file and if someone changes something on that it is very difficult or hard to...
Read More

Selecting Multiple Options in Dependent Drop Down List Box using VBA

In our earlier blog we have already discussed how to create a dependent drop down list box in Excel and as well as in VBA when we are using the list box in VBA. Now in this blog, we will discuss how to select multiple options from the dependent drop down list Box as it...
Read More

Quarterwise Sales Comparison Dashboard with Charts in excel using VBA

Thanks for your feedback on our earlier blogs. We have already covered how to create a summary report quickly via Excel VBA. In this blog, we will cover the charts in excel. If you have not gone through the earlier blog, then please go through this link: Create Summary Reports Quickly via Excel VBA. In this...
Read More

Top 10 Best Practices – Effective email subject lines

One of my clients recently asked if I had any good write-up on best practices on how to write professional & effective email subject lines. I was surprised and I thought who would need a write-up or a guideline on a topic as simple as writing effective email subject lines. I mean, did we ever went...
Read More

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
1 13 14 15 16