fbpx

Category

Tutorials

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

Export data from SQL to Excel spreadsheet using VBA

In this blog, we will Import data from SQL to Excel spreadsheets using VBA. Assuming that you have a little bit of knowledge on the 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...
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 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

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

Create sales dashboard in excel using VBA Codes

You may have heard about (or seen) sales dashboard in excel a lot of time. When I was a beginner, I used to wonder how to create a sales dashboard in excel using your actual data. I recently helped one of the students of Excel VBA tutorial on how to build one. This can be...
Read More

How to Calculate Profit margin in Excel | Profit Margin formula

Struggling with profit and loss? Or still figuring out how to calculate profit margin in excel? Here is your answer, Profit margin is an important figure for business because it tells the percentage of each profited sale. Profit margins are important when pricing products, pursuing financing and generating sales reports. If you create the spreadsheet...
Read More

How to Calculate a Percentage Increase in Excel

Percentage increase calculator Sometimes percentages can be frustrating because it’s not always easy to remember what we learned about them in school. Let Excel do the work for you – simple formulas can help you find the percentage of a total and total cost after the discount. Let see how excel can help us to find...
Read More

How to add Error Bars in Excel: Standard Deviation

How to add Error Bars in Excel: Standard Deviation? Imagine that if all data was perfect, absolute and complete. Although actually, it isn’t, Excel gives us some useful tools to convey margins of error and standard deviations.  If you work in a field that needs to reflect an accurate range of data error, you can...
Read More

Converting trailing minus sign into negative numbers. (Text to Column)

Converting numbers with trailing minus sign into negative numbers. There are series of numbers, wherein some of the numbers are ending with minus sign (-). Now, if you want to apply sum, min, max or average functions, it will not work correctly as Excel cannot read 3789- as a negative. Now Splitting name into two...
Read More

Top 10 keyboard shortcuts that will help you master Microsoft Excel

Top 10 keyboard shortcuts that will help you master Microsoft Excel Top 10 keyboard shortcuts that will help you master Microsoft Excel. Print and Pin it on your board. Stay speedy with these keyboard shortcuts all the time. It’s a good source of revision of shortcuts at once glance. If you found this post helpful,...
Read More

How to freeze rows in Excel | Freeze Column in Excel

How to Freeze row and column in Microsoft Excel? is one of the most used and useful while working on large data as well as while making a dashboard. To freeze panes, freeze rows, freeze columns and freeze cells you can follow the tutorial below. How to freeze rows in Excel? Select a cell for which every row or column preceding...
Read More

Copy Text from Image Using Microsoft OneNote

Tired of typing text from the image. Then stop this time-consuming task. Learn awesome techniques to copy text from image in three simple Copy+Pasting steps using Microsoft OneNote. Try this step by step technique to copy text from images – No more re-typing pages after pages: Copy & Paste the image on Microsoft OneNote Right-click on...
Read More

Excel VBA Tutorial | What is VBA Macros in Microsoft Excel ?

Excel VBA Tutorial provides an integrated toolset that is appealing to a huge number of application areas. To make this tool, even more powerful, came to the rescue Excel VBA Macros, VBA Course or VBA Excel Functions Examples. VBA stands for Visual Basic for Applications, and it is a fully fledged programming language developed by...
Read More

Improve Office Productivity with Online Courses

One of the most favourite games in corporate drawing rooms is the Blame Game- “My employees are less productive!”, “She has got enough time to learn, I am too busy with this and that” and so on. Stop playing the blame game and accept the fact that your employees are what you have. If you...
Read More

Add APA Page number in MS Word with 3 Easy Steps

How to add APA Page numbers in MS Word? While writing documents or preparing a project report, it becomes mandatory to serialize all pages. MS Word has the option to give a serial number to the pages. The page numbers can be in the header or footer of the page with alignment options and style....
Read More

4 Super Productive Google Calendar Hacks

If you are using a Calendar app to simply check out dates, set holiday reminders or add events to it, you are probably using your Smartphone simply to make and receive calls. In other words, you are missing out on a huge potential that these Calendar apps have to offer. Here we offer you some...
Read More

Create Financial Models For Business

Create Financial Models in Excel I recently met a couple of professionals who are fresh graduates and working in the financial services sector. Since I was part of an investment team with a private equity fund where I have experience in creating investment memos and building the financial model from scratch. These guys asked me...
Read More

Microsoft Excel Go To Data Cleaning Trick

Data Cleaning Trick It is so easy to work on your own spreadsheet rather than working with Excel files made by someone else. Significant time is wasted in (1) cleaning or “sanitising” the data, and (2) establishing inter-sheet and intra-sheet formula connections. This process of Data Cleaning becomes super important if you are working in...
Read More

Working with Excel Sumif Formula

When I ask professionals in my workshops – “Which is the ONE formula you’ll pick if you were asked to choose JUST ONE?” Most of the answers hover around INDEX, VLOOKUP and IF. But they tend to forget Excel Sumif. You know what MY answer is – Excel SUMIFS()! And I will tell you why. Excel Sumif...
Read More
1 10 11 12 13 14