10 Crazy Excel Tips & Tricks You Must Know!

10 Excel Tips and Tricks which are Incredibly Easy, Quick & Handy: Automatically SUM () with Alt + =: Did you know you could add an entire row or column by simply clicking the first empty cell? Click, press ALT + ‘=’ and simply add up the numbers in every above cell. Number Formatting Keyboard […]

Read More
Excel accounting more efficient

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 accounting […]

Read More

12 Basic Shortcuts That Will Make You An Excel Guru And Add Hours To Your Life

Microsoft Excel is a crucial tool for anyone operating in modern business. But there are risks. For one thing, it can be intimidating for beginners. Furthermore, Excel errors can have devastating consequences, such as the one that undermined one of the most famous economics papers of all time.

But it doesn’t have to be this way. There are a few basic skills and shortcuts that can really save you a bunch of time. It takes years to become an Excel expert, but if you’re trying to justify putting it on your resume you should at least know these 12 shortcuts.

Read More
Tips to use MS Excel

Excel Keyboard Shortcuts for Financial Modeling

Below is a list of some of the most important and commonly used keyboard shortcuts which are used in Finance. Learning to use these shortcuts will greatly speed up your work in Excel. Basics & General F2 – Edit Cell F4 – Repeat Last Action Ctrl + Z – Undo Last Action Ctrl + O – Open File Ctrl + […]

Read More
change negative numbers to positive in Excel

How to Change Negative Numbers to Positive in Excel?

When you are processing operations in Excel, sometimes, you may need to change the negative numbers to the positive numbers or vice versa. Are there any quick tricks you can apply for changing negative numbers to positive? This article will introduce you the following tricks for converting all negative numbers to positive or vice versa easily.

Read More
Excel Keyboard Shortcuts

List of Excel Keyboard Shortcuts By Category

List of Excel Shortcuts By Category This article assumes you are using Excel on a Windows PC. If you are using a Mac, these shortcuts will change slightly. Here is a complete list of all Excel keyboard shortcuts on Mac. Function Keys F1 Displays the Office Assistant or (Help > Microsoft Excel Help) F2 Edits […]

Read More
10 Top Excel Keyboard Shortcuts

10 Top 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 routine. 1) Quickly move between worksheets […]

Read More