fbpx

By

Yoda Learning

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

Realign your data by sorting in Excel

Realigning 100s of columns without manually Cut/insert columns. Thereby, reducing the task time by minimum 90%. Thus sorting in excel is an important weapon in your hand. Realign your data by sorting in Excel Watch this video for a hassle-free column realignment and sorting in excel: I hope you have liked our tip on Realign your...
Read More

Remove Gridlines In Excel – Turn ON/OFF

How to Remove Gridlines in Excel? Or How to add gridlines in excel? It’s a task in itself when we want to print content in Excel. So we tried to hack this task and made it easy for you. [Don’t forget to check the video at the end of the post] Now when I look at this...
Read More

7 formula error in Excel that make you look dumb

In this blog, I will try to help you to debug your Excel Formula. As soon as you will use excel formula, you will likely need to know how to correct the error in excel formula. First of all, we need to know how many types of error, we can get we are applying excel formula...
Read More

Create Drop Down List in Excel using Conditional Formatting in Excel

Introduction Let’s say you have a worksheet with thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw information. Similar to charts and sparklines, conditional formatting provides another way to visualize data and make worksheets easier to understand. Best features of conditional formatting in excel which if coupled...
Read More

Learn how to customized Header & Footer in printing excel sheet

This time under printing setting we will talk about headers and footers. Specially customized header and footer. Let me go to page layout. Under which let me click on the small icon which will lead me to page setup. Let me now access the tab of header & footer. Now there are some predefined templates of header. So one of them says page 1 of 10. The question mark stands for...
Read More

How to print titles and columns on the left in Excel? | Printing in Excel

One of the ignored areas in Excel is how to print a workbook or a worksheet. In this blog, I’ll talk about some of the tips and tricks like how can you make the printing in Excel look easy, better and more functional. Starting with above case study with a raw data which spans over multiple rows. So I have...
Read More

Don’t do these 10 things while preparing a financial model

A financial model is basically an abstract presentation on a real life financial problem. Making and referring to this can be really helpful in terms of economics and business management. Many of students in my Excel Training session ask about financial modeling and its do’s and don’t. As there are certain mistakes people tend to...
Read More

Learn Clipboard and 2 more special Table tricks in Microsoft Word

This tutorial helps you to uncover the hidden importance of Clipboard and how you can use various instances of copy + paste. We also work around table (one of the most hated areas in word) Checkout our Microsoft Word Online Tutorial Course. Click Here (In this Course, you will learn Basic To Advanced MS Word...
Read More

Email To-Do list to Team members in One Click using Excel VBA

In this blog, we will discuss how to email To-Do list from your outlook mail to respective team members. You would have sent email from outlook but probably not using Excel VBA Code. For example, you have a To-Do list in your excel file with tasks assigned to each team member and you need to send...
Read More

VBA Code to password protect excel for a shared Excel file

In this blog, we will try to cover how to 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...
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
1 10 11 12 13