By

Yoda Learning

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:...
Read More

How to Calculate Ratios in Excel | Excel Formula

How to find ratio? How to calculate ratio in excel? What is ratio Formula? Before learning all this 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...
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: 1 – How is a date stored in Excel (Hint: Every valid date...
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

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

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

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

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

#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...
Read More
1 4 5 6
Tricks to create Hyperlink in Excel
December 6, 2017
How to Calculate Profit margin in Excel
December 6, 2017
How to Calculate a Percentage Increase in Excel
November 30, 2017
How to add Error Bars in Excel: Standard Deviation
November 30, 2017
How to convert invalid date formats into valid data formats?
November 29, 2017
Converting trailing minus sign into negative numbers. (Text to Column)
November 29, 2017
Text to Columns in Excel | Transfer Single Columnar Data into Multiple Columns.
November 29, 2017
4Excelshorcuts-workingwithformulas
Working with Excel Formula Shortcuts | Excel tips & tricks
September 27, 2017
Top 10 keyboard shortcuts that will help you master Microsoft Excel
September 26, 2017
freeze-panes-excel
Freeze row and column in Excel “How to”
August 26, 2017
How to Copy Text from Image
Copy Text from Image Using Microsoft OneNote
August 17, 2017
Excel VBA Macro Tutorial | What is VBA Macros in Microsoft Excel ?
July 26, 2017
online-courses
Improve Office Productivity with Online Courses
July 26, 2017
Add APA Page number in MS Word with 3 Easy Steps
July 26, 2017
googlecalneder
4 Super Productive Google Calendar Hacks
July 26, 2017
Chrome and Excel Shortcuts
July 26, 2017
Finalnancial
Create Financial Models For Business
July 26, 2017
Microsoft Excel Go To Data Cleaning Trick
July 26, 2017
SUMIFS Excel Formula
Working with Excel Sumif Formula
July 26, 2017
Data-Sort-Option-Sort Option
Realign your data by sorting in Excel | Excel tips and Tricks | Excel shortcut
July 26, 2017