Create interesting icons with ALT combination + Number key
Welcome EVBA.Info - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...
Printable Keyboard Shortcuts
Disclosure: Some of the links below are affiliate links which means I may earn a commission if you click through and make a purchase. Like a lot of people in this technology driven generation, I spend
Outlook – free personal email and calendar from Microsoft
Get free Outlook email and calendar, plus Office Online apps like Word, Excel and PowerPoint. Sign in to access your Outlook, Hotmail or Live email account.
Running Totals and Running Balance with Excel Pivot Tables - How To - PakAccountants.com
Learn how to do Running totals and running balance super easily with this technique in Excel Pivot Tables in this step by step tutorial for beginners
#Excel #Tip: Count or Sum using Cell color in Excel
One of the most sought after feature among heavy Excel users i.e. count or sum cells in Excel based on cell background color. I really wish we had a formula or a feature that does it for us but it isn’t available yet. But we do have the solution if we turn to VBA and […]
#Excel Dynamic Drop Down Lists that can sort and update automatically - 3 methods
To make a workable and practical drop down list in Excel we need to get a sorted unique data for from the data range that is unsorted and has duplicates. And...
Microsoft Word keyboard shortcuts
Picture based reference guides for anything and everything. If it seems like something someone might print, physically post, and reference then it...
How to Change the Color of the Gridlines in Excel
You may not have thought about the color of the gridlines in Excel before, but if you’re bored with the default gray color or you want to use a color that’s easier on your eyes, you can change the color of the gridlines.
How to Sort an Item Row (Left to Right) With Excel Pivot Tables?
Everyone can sort virtually anywhere with Excel Pivot Tables, but it was quite surprising for me that I can sort any row from left to right.
How to compare two Excel files for differences
Learn a variety of methods to compare Excel files and identify differences between them. See how to open two Excel windows side by side, how to use Excel formulas to create a difference report, highlight differences with conditional formatting, and