Tutorials

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. Download it now! If you found...
Read More

Remove Password from Excel Using VBA [Macros] Tutorial

In this blog, we will try to cover how to remove password from Excel using VBA as part of our continued effort to give 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 have...
Read More

Text to Columns in Excel | Split cells in excel

Text to Columns in Excel or Split Cells in Excel is used in data cleaning and data re-arrangement. Excel text to columns formula technique is used for following: While covering up this blog, we have explained how to split Text into multiple columns easily. This blog is basically for the people who face problems in Excel because they...
Read More

Create Magnifier Glass Effect in Powerpoint Picture

I frequently visit “Investor Relations” section of numerous companies. On one such occasion, I stumbled upon an Investor PowerPoint Presentation of a Global Auto major (BMW Jan 2014). I was mesmerized by the look of a Powerpoint picture in certain slides and started exploring techniques on how to highlight in powerpoint slides. The following picture...
Read More

20 Excel Shortcuts Keys For Beginners Using Keyboard 2017

Excel Shortcut Keys For Beginners When starting with Microsoft Excel, knowing a few excel shortcuts will reduce your work time and make it easier to work on Excel. Using the mouse to do all the task reduces your productivity. Here are a few shortcuts to use when you just begin working with Microsoft Excel. These...
Read More

How to remove password from Excel or Unprotect an Excel

How to remove password from excel spreadsheet or Unprotect Excel Spreadsheet without using any software.  So what it includes? This includes changing file extension and manipulating its constituents to get an unprotected excel file or unlock an excel file. Almost ALL Excel users wish at some point or the other felt the need of some...
Read More

How to delete rows in excel based on a condition?

In this blog, I will discuss how to delete rows in excel based on condition. Sometimes we get the data set from another person and the need to do a lot of work to clean this data set. You need to delete a certain section of data which is not relevant or there are innumerable...
Read More
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