fbpx

Category

Tutorials

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

11 Simple PowerPoint Presentation Tips

PowerPoint Presentation Tips We have made this infographic on Top 11 simple PowerPoint Presentation tips. Discover these nifty keyboard shortcuts, which will help you to master your presentation skills and learn new awesome tricks. Further, if you are looking for powerpoint tips go to our Yoda Learning blog. You must check out our new blog where...
Read More

Excel Go To Special technique for Dummies [Infograph]

Excel is filled with a vast ocean of techniques, but a regular user may find it difficult to discover all of them at once. Excel Go to Special is one of them. Just check out this post where we have listed down a specific technique in Excel for dummies.  Go to Special technique is one...
Read More

5 Steps to Create your first Power BI Dashboard | Power BI Dashboard

A Power BI dashboard is usually known as a canvas and it can have only one page to tell a story using visualizations. Since it is restricted to one page, a perfect dashboard contains only the most important fundamentals of the story.   A dashboard is not only attractive but also very interactive and highly customizable....
Read More

Complete Power BI Tips and Tricks – Power BI Dashboard Tutorials

Learn all the Power BI Tips and Tricks. Power BI is an interactive data visualization and analytics tool for business intelligence. You can use it to pull data from a wide range of systems in the cloud and on-premises and create dashboards that track the metrics that you want to analyze, or drill in and...
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

Insert Non-Breaking Space & more Word Tricks | Microsoft Word Tips

This video is a collection of word tricks on Insert Non-Breaking Space & more, where you can use quick parts to save frequently used text or retrieve an older copied text. We also cover a hidden shortcut which helps you create a non-breaking space. Quick Parts: In MS Word, Quick Parts is used as a...
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

Basics of Power BI DAX | List of Power BI DAX Function with Example

Do you know about the Power BI DAX Function? Microsoft introduced its visualization tool in 2013 and named it as Power BI. Power BI is a cloud-based platform and can be handled beautifully to give the best visualization to even the most critical business data.   It helps in evaluating and sharing the data and...
Read More

How to Split Cells In Excel

Merging and splitting cells in Microsoft Excel is very similar. Below are the steps required for merging and splitting cells in each of these programs. These steps help you with How to Split Cells in Excel. Follow the step by step process and split excel cells into multiple cells. This tutorial will help you to...
Read More

Remove Password from Excel Using VBA [Macros] Tutorial

How to remove password from Excel using VBA as part of our continued effort to give the valuable resource of learning for Excel VBA Macros tutorial students. If you are following our blogs on a regular basis then probably you have gone through the blog where Rishabh has very clearly shown to us that how...
Read More

How to make original Good-looking Presentation slides

Guide to make original Good-looking Presentation slides. Today, if you want to succeed in your corporate job, you must know how to impress the ‘higher-ups‘ of your organization using your presentation slides.
Read More

What-if Analysis using Excel Dashboard, Indirect Function

In this topic, I will try to cover the features of what-if Analysis. It is a tool that allows you to try to different formulas. If you apply what-if analysis you will notice changing the values in cells and how those changes will affect the outcome of the formulas in your spreadsheet. Before we start...
Read More

Excel Versions: Evolution of Spreadsheets [Infographic]

Excel versions aka Spreadsheets have a come a long way over the years and plenty of companies today are attempting to build the best one. Spreadsheets have been used by accountants for hundreds of years. Computerised or electronic spreadsheets are of much more recent origin. Information Systems oral history and some published newspapers and magazines...
Read More

Custom Autofilter In Excel | Create Advanced Excel Filters using Excel VBA

In this blog, I will try to cover how to use a Custom Autofilter in Excel using Excel VBA. This Advanced Excel filter technique is meant for Advanced Excel users. We all know how to use a custom filter or advanced filter in Excel which is also knows as Excel VBA auto filter. Creating custom Excel...
Read More
1 9 10 11 12 13 16