A common complaint about Power Pivot KPI icons is that it seems no matter which set of icons you select, it only shows the standard Red-Yellow-Green circle icons.
Microsoft Excel
Microsoft Excel – Understanding Excel Functions with Help
Admit it, you’ve used Excel functions without any idea how they work. Someone said, “Click here for this. Click here for that.” You’ve dutifully followed orders, blindly clicking on cells with no real clue as to why.
It’s time to lift the veil of mystery and understand why these functions are so demanding of such data.
Here is just one of many options for understanding function logic:
This first part has nothing to do with obtaining function information, but it’s a great time saving trick. If you like to type your functions directly in the cell; press your EQUAL button [=] and start typing the first few letters of the function name. As you type, Excel will begin to AutoComplete the function’s name.
Microsoft Excel – Convert Answers to Values FAST!
If you are new to Excel, you no doubt have already discovered the need to take a series of numbers created by formulas and convert them to fixed values. In other words, replace the questions with the answers. With no idea how to accomplish this, beginners usually spend great stretches of time retyping the numbers into the answer cells to make them “permanent”.
Eventually, someone who feels your pain turns you on to the technique of highlighting all of your formula cells, clicking Copy, then in the same cells clicking Paste Special…, Paste Link.
You could now not be more ecstatic. “This is going to save me sooooo much time”, you say to yourself.
Well, guess what. There’s an even FASTER way to accomplish this task. Try this out:
Excel Comma Style Keyboard Shortcut
If you are an Excel user who LOVES working from the keyboard as much as possible (i.e. data entry, navigation, feature activation, etc…) then you simply MUST know of this little gem of a keyboard shortcut. Although we have no scientific data to back up …
PowerPivot Tutorial
Microsoft PowerPivot TutorialWatch this video on YouTube In this Microsoft Excel PowerPivot tutorial, you’ll see how to use Microsoft Excel PowerPivot to import data from multiple data sources, link the data based on common fields and finally create a PivotTable and PivotChart to quickly analyze …
Free Tutorial: How to Format Cells in Microsoft Excel using the Format Painter Tool
How to Format Cells in Microsoft Excel using the Format Painter ToolWatch this video on YouTube In this Microsoft Excel tutorial, you’ll see how to format cells in Microsoft Excel using the Format Painter tool. Learn more about Microsoft Excel in our Microsoft Excel Training …
Microsoft Excel Keyboard Shortcuts
Keyboard shortcuts may seem like a throwback to the olden days, but they can seriously ramp up your productivity once you start using them. Especially for tasks you do on a repeated basis. Here are some of the most common Microsoft Excel keyboard shortcuts. F7 …