April 7, 2017

### 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“. Here’s how...

### Subtotal Excel Formula – Excel Advanced Filter Trick

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....

### How to use Pivot Table in Excel For Tutorial on grouping numbers, dates and texts

How to use a pivot table in excel. In this Excel Training, I will show you the importance of grouping numbers, grouping dates and grouping texts in a pivot table report. If you have not used pivot table before then you are going to love this feature of excel. If you already created one before,...

### How to use Roundup Function in Excel

We can use a variety of formulas to round numbers in Excel depending on the situation. We have ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD and a few more. Here, we will learn how to Round up numbers in Excel. Before we start, we must know about the Roundup function. What...

### 5 Powerful Tricks to Format cells in Excel

In this article, you will learn 5 Excel tricks on how to format cells in Excel. Applying these formatting cells techniques in excel will make your worksheet or spreadsheets look attractive and easy to read. Almost all Microsoft Excel users know how to change date format, numbers and text formats using rows and columns. But...

Microsoft Excel has a lot of features. 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 information in the cell and from which...

### Learn how to enable or disable scroll lock in Excel

Tricks to Enable / Disable Scroll Lock in Excel Think: Imagine your report is due in an hour. You are working along in Excel, everything is going well, but suddenly you notice that you can no longer move around properly in your spreadsheet. You press the arrow keys, but instead of the cursor moving to...

### Merge excel files into a single excel spreadsheet [VBA Tutorial]

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. Let’s learn how to merge excel files in a single excel with an example:...

### Calculate Ratios in Excel | Excel Formula

Calculate ratios, first we must learn what is a ratio? 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. If there are 2 red balls and 3 blue balls on the table you could...

### 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: 1 – How is a date stored in Excel (Hint: Every valid date...

### 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...

### Learn how to compare two columns in Excel

How to compare two columns in Excel? Like a two-dimensional database, Excel is capable of storing many different types of data from small business contacts to personal income tax records. In both of these examples, accuracy is essential to make sure you have the information you need when you need it. In any data entry...

### #AskYoda MS Office Webinar 1001 – 15th March 2017

Here is the video of our #AskYoda webinar conducted on 15th March 2017, our expert had answered queries related to MS Excel & MS Word. Here is a glimpse of queries replied to in this Webinar: Three Student questions were answered LIVE on topics like Bhanu from executive background asked us about the Investment related...

### #AskYoda MS Office Webinar 1002 – 22nd March 2017

Here is the video of our #AskYoda webinar 02 conducted on 22nd March 2017, our expert had answered queries related to MS Excel. Here is a glimpse of queries replied to in this Webinar: Three Student questions were answered LIVE on topics like Robin from Business Analyst background asked us about the monthly reporting related...

### Excel Advanced Filters to split data into separate sheets using VBA

Excel Advanced filters technique are useful when you deal with a large dataset. In this blog, we will try to cover one of Excel Advanced filter techniques to understand how to split data into a separate sheet through VBA code (it’s a part of our Excel VBA tutorial program). For instance, we have a huge list of U.S....

### #AskYoda MS Office Webinar 1003 – 29nd March 2017

Here is the video of our #AskYoda webinar 1003 conducted on 29nd March 2017, our expert had answered queries related to MS Excel & Word. Here is a glimpse of queries replied to in this Webinar: Three Student questions were answered LIVE on topics like Mr Sandipan from customer service background asked us about the...
1 2