fbpx
Email: [email protected] Call Now! +1 203-349-9909 / +91-8080042523

By

Yoda Learning

How to use Pivot Table in Excel

In this Excel Training, I will show you the importance of pivot table in excel. Pivot table performs 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, you...
Read More

Working with Excel Formula Shortcuts | Excel tips & tricks

What will you get in excel formula shortcuts? You will come to know every single excel formula shortcuts and how to use it. You can use this shortcuts you optimize your daily work. With the help of this tutorial, I had helped almost 10000+ visitors to improve the skills and save time at the office....
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

How to Attach File in Excel or Object in Excel Spreadsheet

In this blog, we will learn how to attach a file in Excel.? Attach an Existing File 1. Click on the cell on which you want to insert the object. 2. Select the “Insert” tab. Then, Click “Object” in the Text group and then the Object dialog box will appear. 3. Select the “Create From...
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

How to Find circular reference in Excel

In Excel, Circular reference warning is received with raised eyebrows and terrified looks most of the time. But from our experience, we know it to be all smoke and no fire, which we will prove to you right here. So what really is a circular reference? It simply means that your formula includes a cell which is...
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

Find & Replace – using wildcard Character (*)

This time we’ll talk about “Find and Replace” and we’ll see its importance in the context of data cleaning. In fact, I have to start with the data which is going to illustrate how is this going to be used. For example, if I have a set of names with certain extra data with respect...
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
1 6 7 8 9 10 12