By

Yoda Learning

10 Ninja Tips in Excel

Excel Tips We have made this infographic on Top 10 useful Ninja Tips in Excel. A quick reference point for busy professional working on big financial Data models. Take a look at these Excel Shortcuts to improve your efficiency and productivity in excel. Subscribe now and Get a handbook on Excel Tips and Tricks: I...
Read More

Get Rid of Mail Merge Once and for All

In this blog, I will try to cover how to get rid of Mail Merge by using the sample Excel VBA code. We all know how to do the mail merge in MS Word. But today I will discuss on mail merge in Excel. The data in your spreadsheet and you want to send the...
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

How to make original Good-looking Presentation slides

How 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. Here’s a list of few pointers you should always remember when making such a PowerPoint presentation slides: Don’t be too mainstream, get over...
Read More

Copy Text from PDF without Line Breaks & More Word Tricks

How to copy text from pdf without broken lines We have been working on Excel, VBA & Powerpoint tutorial and felt the need for exploring Word Tricks to enhance the productivity and save a ton of time of professionals who use MS Word for multiple purposes like writing an idea, designing template, making a professional report...
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) Learn more Word Tricks These three Word Tricks helps you to be more productive at work: Copy and Paste Using...
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

5 excel charts hack to make your boss smile | Excel Tips

Doesn’t it feel great to get that approval from your boss that everyone around you is striving for? Of course, it does. After reading this article, that dream is going to come true really soon.   Here are some excel charts hack to be used in your Excel Dashboard to make your charts stand out from...
Read More

Macro to convert Excel to PDF file and Email it using Outlook | Excel Tips

Which of these tasks is part of your daily work life? To Convert Excel to PDF Sending PDF attachments via email Mostly every one of us has to do these tasks daily. You may recall that sometimes you have to convert data in Excel to PDF and then attach it to Outlook mail. It doesn’t...
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

Create a report in excel for sales data analysis using Pivot Table Techniques

Create a report in excel for sales data analysis is an important aspect of any business. Unless you are able to measure and analyse data, how can you improve your performance? It’s true that improving performance is a whole new story, but unless your data measurement isn’t accurate, you can never hope to reach the...
Read More

Add sizzle to your presentation with PowerPoint special effects

People ask me often – “Where did you learn all the PowerPoint special effects from?” I answer – “Investor Relations!” I frequently visit “Investor Relations” section of numerous companies. They contain Annual Reports, Quarterly Reports, and Investor Presentations, etc. I am always keen to go through their “Investor Presentations” reports. A few of them use...
Read More

Top 3 Ninja level charts for EVERY business…PowerPoint Tips

If my friends ask me my top three picks of the best charts that I use frequently, I will share these: Waterfall 2-axis Stacked Combo Thermometer 1) Waterfall charts have few advantages: A: It can depict sequence in which an activity must be construed. Watch this chart as used in one of the presentations (publicly...
Read More

LIVE case study – How I drafted my sales pitch…

It took me approx. 3.0 hrs. to write one of the most important sales pitch of my life till date. Aim – To showcase our e-learning library (Excel, PowerPoint, Macros, Outlook, Word) to Corporate L&D and help them understand why our e-learning product is the best for them and the convenience with which it can be implemented in the...
Read More

Create a Dependent Combobox in Excel and VBA

In this blog, we will discuss how to create a Combobox in Excel and as well as through VBA. List box & a Combobox are similar but have slightly different controls, to let users make multiple choices of items or to enter their own value in a list. Typical examples of items in these types...
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

How to Customize PowerPoint Slides Only in 15 Minutes? | PPT Tips

Is your boss constantly nagging on your head to complete the PPT in few minutes? In such cases, use shortcuts to get your work done faster, smoother as well as qualitative. I exhibit five effective PowerPoint Presentation Tips that you wished you would know much before so that you would complete creating your presentation within...
Read More

Top 10 Best Practices – Effective email subject lines

One of my clients recently asked if I had any good write-up on best practices on how to write professional & effective email subject lines. I was surprised and I thought who would need a write-up or a guideline on a topic as simple as writing effective email subject lines. I mean, did we ever went...
Read More

If you use ALT + TAB to toggle, read these 6 lines…

We all use Alt  Tab to toggle different windows of applications. Even though we use this key shortcut to do our daily job yet we don’t know this tricks. Alt  Tab ↹ is the common name for a keyboard shortcut that has been in Microsoft Windows since Windows 3.0. This shortcut switches between top-level windows without...
Read More
1 2 3 4 6
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
Excel Find circular reference for dummies
July 25, 2017
Gridlines onoroff
Remove Gridlines In Excel – Turn ON/OFF
July 25, 2017
7 formula error in Excel that make you look dumb
July 25, 2017
Find & Replace – using wildcard Character (*)
July 25, 2017
Conditional Formatting in Excel w. Drop-down list based Input
July 25, 2017
Learn how to customized Header & Footer in printing excel sheet
July 25, 2017
print-titles-and-columns-excel-trick-and-tips
How to print titles and columns on the left in Excel? | Printing in Excel
July 25, 2017