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

Day

April 7, 2017

Time Travel with PowerPoint tricks – Smart Art for Powerpoint

Time travel has been a core theme for many Hollywood science fiction flicks. Well, let me make it a reality for you. You can zoom past an hour in less than five minutes with these special powerpoint tricks. 1) Convert boring bullet points in attractive SmartArt in 5 seconds – I borrowed some text from...
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

How to remove password from Excel or Unprotect an Excel

How to remove password from excel spreadsheet or Unprotect Excel Spreadsheet without using any software or Password Remover. So what it includes? This includes changing the file extension and manipulating its constituents to get an unprotected excel file or unlock an excel file. Almost ALL Excel users wish at some point or the other felt the...
Read More

How to Customize PowerPoint Slides Only in 15 Minutes? | Powerpoint Presentation Tutorial

Is your boss constantly nagging your head to complete the PPT in few minutes? In such cases, use shortcuts to get your work done faster, smoother as well as qualitative. I exhibit five effective PowerPoint Presentation Tutorial that you wished you would know much before so that you would complete creating your presentation within no...
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

9 Excel Error in Formula and How to correct it

Do you feel agitated when you are engrossed in setting up formulas in your EXCEL and suddenly you see jargon of excel error like #NAME, #REF appearing in your excel spreadsheet? Here’s a list of top 9 mistakes that one makes while entering an Excel formula + tips on how to avoid them: 1. Excel Error –...
Read More

Export data from SQL to Excel spreadsheet using VBA

In this blog, we will Import data from SQL to Excel spreadsheet using VBA. Assuming that you have a little bit of knowledge on SQL server. Now if you are preparing reports in Excel and the data is on your SQL server then you don’t need to copy the data first from SQL server to...
Read More

Learn how to create a horizontal bar chart in Excel

Horizontal bar chart may look appealing, but to make it may be troublesome. This article shows a step by step process to make a percentage horizontal bar chart in Excel. Consider there are two tables i.e. Income and Expense Select the data with headers and Press Ctrl + T. Do it for both Income and...
Read More

Password protect excel using VBA for a shared Excel file

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 track who has modified the same. Password protect excel sheet...
Read More

Learn how to use SUMIF Excel Function

The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUMIF function can be entered as part of a formula in a cell of a worksheet. You can try the SUMIF function to add...
Read More

Custom Autofilter In Excel | Create Advanced Excel Filters using Excel VBA

In this blog, I will try to cover how to use a custom Excel VBA autofilter in excel. This Advanced Excel filter technique is meant for Advanced Excel users.  We all know how to use a custom filter or advanced filter in Excel which is also knows as Excel VBA auto filter. Creating custom Excel VBA...
Read More

Learn how to create or make excel scatter plots

In this blog, learn how to create excel scatter plots and you will able to make excel scatter plots at the end of the blog. Choosing the right type of chart or graph can be key to convey the most important insights of your data—on sight. When you want to dig a little deeper into...
Read More

How to delete rows in excel based on a condition?

In this blog, I will discuss how to delete rows in excel based on the condition. Sometimes we get the data set from another person and the need to do a lot of work to clean this data set. You need to delete a certain section of data that is not relevant or there are innumerable blank cells,...
Read More

How to Merge Excel Files in to one Or into a Spreadsheet using Excel Macro

How to merge excel files or combine excel files into a single sheet from a different workbook using excel macro is the topic of this blog. But in the earlier blog, we have covered how to merge data in a single sheet when the data are coming from the same sheet. We are trying to cover...
Read More

How to split spreadsheet into separate workbooks using Excel VBA?

Earlier we have split our data into separate excel sheet but this time, we will split spreadsheet records into a new workbook. It’s useful and reduces our effort in making different workbook with same data. Hope you have enjoyed our earlier blogs, revisit “How to split excel data into separate spreadsheets using VBA“. Split spreadsheet...
Read More

Excel Advanced filter technique using the Subtotal excel function

Subtotal Excel formula of excel advanced filter is a definite hit, both for beginners and experienced users who haven’t seen this feature in action before. If you work with large data set and often arrange your data for analysis, It’s practically impossible for someone to make a conclusion by sampling looking at this massive data....
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

Merge excel files into a single excel spreadsheet

In a continuation Excel VBA tutorial series of data manipulation using Macros; Today, we will try to merge excel files in a single excel spreadsheet. The source of the data may be from the same worksheet or from the closed workbook. We will merge excel files into a single sheet. For example, individual states data...
Read More

How to Calculate Ratio in Excel | Excel Formula

This article is been written to find calculate ratio in Excel Ratio: In simple mathematics, relationship or comparison between two more numbers is known as ratios. Ratios are normally written as “:” to show the connection between two numbers, for instance. You can learn such advanced excel tutorial in our advanced excel dashboard course. If...
Read More

Working with Excel Date Functions

In this article, let us learn more about Excel date functions and Excel date format. It will help you in areas of calculations such as due dates, project deadline & warranty expiry date. Here is a summary of what we will explain: How is a date stored in Excel (Hint: Every valid date is a...
Read More
1 2
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
Basics of Power BI DAX Function
Basics of Power BI DAX | List of Power BI DAX Function with Example
September 9, 2019
Power BI vs. Tableau
Power BI vs Tableau – Comparing Functionality, Pricing and Support
September 3, 2019
Business Analyst Interview Questions
Business Analyst Interview Questions & Answer (Q&A)
July 25, 2019
Data Analyst Interview Questions and Answers
Data Analyst Interview Questions and Answers [Q&A]
July 25, 2019
Power BI Dashboard vs. Power BI Reports
Power BI Dashboard vs. Power BI Report | BI Dashboard
July 24, 2019
Create Power BI Layouts step-by-step
Create Power BI Layouts – Power BI Tips and Tricks
July 24, 2019
Create Power BI Dashboard
5 Steps to Create your first Power BI Dashboard | Power BI Dashboard
July 24, 2019
Power BI Templates
Power BI Templates | Download Power BI Template
July 24, 2019
Complete Guide of Power BI Download and Power BI Installation Steps
July 24, 2019
Advanced Power BI Tips and Tricks
Complete Power BI Tips and Tricks – Power BI Dashboard Tutorials
July 24, 2019
HTML Snippets Powered By : XYZScripts.com