fbpx
[email protected] +1 203-349-9909 / +91-8080042523

Category

Tutorials

Create a report in excel for sales data analysis using Pivot Table Techniques

Create a report in excel for sales data analysis is an important aspect of any business. Unless you are able to measure and analyse data, how can you improve your performance? It’s true that improving performance is a whole new story, but unless your data measurement isn’t accurate, you can never hope to reach the...
Read More

Add sizzle to your presentation with PowerPoint special effects

People ask me often – “Where did you learn all the PowerPoint special effects from?” I answer – “Investor Relations!” I frequently visit “Investor Relations” section of numerous companies. They contain Annual Reports, Quarterly Reports, and Investor Presentations, etc. I am always keen to go through their “Investor Presentations” reports. A few of them use...
Read More

Top 3 Ninja level charts for EVERY business…PowerPoint Tips

If my friends ask me my top three picks of the best charts that I use frequently, I will share these: Waterfall 2-axis Stacked Combo Thermometer Waterfall charts have few advantages: A: It can depict sequence in which an activity must be construed. Watch this chart as used in one of the presentations (publicly available)...
Read More

Create a Dependent Combobox in Excel and VBA

In this blog, we will discuss how to create a Combobox in Excel and as well as through VBA. List box & a Combobox are similar but have slightly different controls, to let users make multiple choices of items or to enter their own value in a list. Typical examples of items in these types...
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

Unprotect Excel | Excel Password Remover Online

Open password protected the file from this simple excel tips & tricks. Learn how to unprotect excel or remove password from excel. Let me warn you up front – THE MOMENT you learn applying this trick on How to Unprotect Excel, you’ll JUMP in ecstasy. If you are ready, then read on… Almost ALL Excel users...
Read More

How to Update and Delete Using Excel VBA Userform ? | VBA Userform

Learn How to Update and Delete Using Excel VBA Userform? It’s useful for making a task easy in business areas like Banking Record, Personal Finance, Stock Reporting, Recordkeeping, Automate Training room booking, Hotel Room booking, Car Booking, booking IT resources and approval of business expenses such as refreshments, conveyance, stationery etc. Download Sample FilesThis technique will help...
Read More

Remove Password from Excel Using VBA [Macros] Tutorial

How to remove password from Excel using VBA as part of our continued effort to give valuable resource of learning for Excel VBA Macros tutorial students. If you are following our blogs on a regular basis then probably you have gone through the blog where Rishabh have very clearly shown to us that how to...
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

Perform Google Search on Internet Explorer using Excel VBA | Excel VBA

First time in my life I have come across to create this type of automation and finally, I got success. How to search data in Google using Excel VBA: For example: Write “Apple” in Google search box Press Enter↵ It will show you the statistics that how many records it has populated and also how...
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

How to unlock or lock cells in excel- Single or multiple

How to lock or unlock cells in Excel? In Microsoft Excel 2007 or later version, we want to protect few cells only in a worksheet, then how to do it? Solution: There are two situations to lock cells in excel depending on these reasons. If You Want the Majority of Cells Locked If You Want the...
Read More

How to Remove Duplicates in Excel | Find & Delete Duplicates

How to Find and Remove Duplicates in Excel In Microsoft Office Excel you have several ways to filter for unique values or find and remove duplicates in Excel. Now, you will learn how to find & remove duplicate values in excel. Use the Remove Duplicates command in the Data Tools group on the Data To...
Read More

Error in excel when you Insert Column or Row in Excel (Solved)

Are you fed up with the Errors in Excel while entering a row or column? Then you have come to the right place.  Error in excel when you Insert Column or Row in Excel (Solved) This blog will clear all your doubts and ensure that you will never have any errors next time you use...
Read More

Combine Text with Date or Time in Excel – Reporting Tips

  Many time you prepare financial reports in multiple sheets where you have to mention the date of signing report along with the certain text. Combine text with a date by following these simple steps: Hence it increases responsibility to update the date on each sheet. What if you enter a proper date in one sheet...
Read More

Calculate Elapsed Time in Excel

We want to calculate elapsed time in excel i.e. Add or Subtract hours, minutes and seconds to the time. How to calculate elapsed time in Excel? Use the following formula TIME (HOURS, MINUTES, SECONDS) to calculate elapsed time in excel. After entering the formula, you may require changing the cell format as per your requirement. In...
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
1 9 10 11 12 13
Tableau Data Types | Different Data Types In Tableau
December 11, 2019
Alteryx for Beginners – Alteryx Online FREE Course
December 3, 2019
online Excel Course
Online Excel Course – Online Excel Training Course
November 26, 2019
Power BI Architecture
Power BI Architecture | Power BI Security
November 21, 2019
Power BI Interview Questions
101 Power BI Interview Questions and Answers[Q&A]
November 11, 2019
Alteryx Shortcuts and Alteryx Hotkeys
Alteryx Hotkeys – Alteryx Keyboard Shortcuts
November 1, 2019
Alteryx vs Tableau
Alteryx vs Tableau – Choose the right Data Analytics Tools
October 25, 2019
Alteryx Gallery Questions and Answers
Alteryx Analytics Gallery Questions and Answers | Alteryx Gallery – Public Gallery
October 24, 2019
Difference between Business Analyst and Financial Analyst - Business Analyst vs Financial Analyst
Difference between Business Analyst and Financial Analyst | Business Analyst vs Financial Analyst
October 24, 2019
What is Alteryx - Introduction to Alteryx Designer
What is Alteryx? | Introduction to Alteryx Designer
October 22, 2019
Comparison between Alteryx vs KNIME
Alteryx vs KNIME Comparison | Data Analytics tools
October 18, 2019
Financial Analyst Interview Questions and Answers
Financial Analyst Interview Questions & Answers [Q&A]
October 16, 2019
Alteryx Data Types
Alteryx Data Types | Alteryx Data Analytics
October 15, 2019
Alteryx Download and Installation Guide for Windows and Mac
Alteryx Download and Install for Windows and Mac | Alteryx Designer
October 14, 2019
Data Science Interview Questions with Answers
Data Science Interview Questions and Answers [Q&A]
September 26, 2019
Power bi vs SSRS
Power BI vs. SSRS | Difference between Power BI and SSRS
September 20, 2019
Tableau Interview Questions
Tableau Interview Questions and Answers [Q&A]
September 18, 2019
Power BI Data Sources
Power BI Data Sources and Power BI Services
September 16, 2019
What is Power BI_ _ Introduction to Microsoft Power BI
What is Power BI? | Introduction to Microsoft Power BI
September 13, 2019
POWER BI COMPONENTS
Power BI Components and Building Blocks of Power BI
September 13, 2019