The 10 most useful Excel keyboard shortcuts

The problem with a list of hundreds of shortcut keys is that it is overwhelming. You cannot possibly absorb 233 new shortcut keys and start using them. The following sections cover some of my favorite shortcut keys. Try to incorporate one new shortcut key every week into your Excel...

Keyboard Shortcuts to Insert Special Symbols in Excel

The copyright ©, trademark ™, and registered trademark ®, symbols can be inserted quickly in Office applications using the Autocorrect feature. Typing (c), ™, or (r) will accomplish this. The other way to enter special symbols in Excel is by going to Insert > Symbol. You can...

3 Things to remember before you go for Excel VBA Job Interview

Like giving interview is a skill, taking interview is another great skill. I’ve taken many in the past and given more than I’ve taken and here I’m sharing the content from my experience. Your interview experience may be totally different than this but you must be aware of it and...

5 Simple but Important Fomulas In Excel

Here are some easy formula that you might use in excel 1) Anyone knows how to Combine and center the contents of the selected cells in a new larger cell. ?? Simple Answer : Click   Alt + H + M + C  and see the Magic :)  Merge & Center Text ...

Download Office 2016 IT Pro and Developer Preview version

IT professionals and developers can now get their hands on Office 2016. Microsoft has launched the IT Pro and Developer Preview of the next version of Office. Now, Office 365 commercial customers will be able to download the IT Pro and Developer Preview of Office 2016, and with...

The Best Shortcut Keys in Microsoft Excel 2010 - 2013

TabMoves one cell to the right in a worksheet SHIFT+TABMoves to the previous cell in a worksheet. CTRL+TABSwitches to the next tab in dialog box. CTRL+SHIFT+TABSwitches to the previous tab in a dialog box. CTRL+1Displays the Format Cells dialog box. CTRL+SHIFT+LUse for filtering...

7 Simple Tricks to Make Smart and Neat Excel Graphs

It’s really tempting to let terrible Excel graphs creep into your reports. Your boss doesn’t care about little things like how graphs look, right? And whatever Excel comes up with as the default is probably fine … right? Not really. You’re using data to spur action. Maybe...

VLOOKUP Explained!! See This Video Tutorial

VLOOKUP IN EXCEL EXPLAINED VLOOKUP is a powerful Excel function that allows you to look for a specified value in one column of data inside a table, and then fetch a value from another column in the same row. An example where VLOOKUP might be useful is if you have a monthly...

Must Known Excel Tips and Tricks for Basic to Intermediate Users!

Whether you’re an Excel power user or just reasonably experienced with spreadsheets, there are generally still things you can learn about Microsoft’s program, and points which can be refreshed in your memory. So, we’ve put together this compilation of 14 tips for those of...

Three tips and tricks to make Excel accounting more efficient

If you’re new to doing your accounting in Microsoft Excel, it can seem a bit daunting at first. After all, there are so many functions you can use to get the job done. The good news is, once you master all those functions, you’ll be an accounting pro. You’ll be able to do your...

Use Excel to download hundreds of images instantly

The problem: Needing to download hundreds of images instantly We got some 1000+ images on our web portal, and we need to download each of them to local drive so that we can move them to new server all together The Solution: We needed to download the entire list of images and...