Add, change, or remove error bars in a chart - Microsoft Support
In Excel, Outlook, PowerPoint, or Word, for Windows and Mac, you can format (add, change or remove) error bars in a chart.
How to correct a #REF! error - Microsoft Support
When you use explicit cell references like this (where you reference each cell individually, separated by a comma) and delete a referenced row or column, Excel can’t resolve it, so it returns the #REF! error. This is the primary reason why using explicit cell references in …
Insert Julian dates (Functions) - Microsoft Support
Use Excel functions including TEXT, TODAY, and DATEVALUE to insert or convert a date to a Julian date.
How to correct a ##### error - Microsoft Support
Use a formula to subtract dates or Add or subtract time correctly to avoid negative date or time value results. Change negative formula results that are formatted as dates or times to a different number format. Microsoft Excel might show ##### in cells when a column isn’t wide enough to show all of the cell contents.
Add a check box, option, or Toggle button (ActiveX controls)
You can insert form controls like check boxes, option, or toggle buttons to make data entry easier. Check boxes work well for forms with multiple options. Option buttons are better when your user has just one choice. Toggle buttons indicate a state between an enabled or disabled state when the button is clicked.
QuickStart: Learn DAX Basics in 30 Minutes - Microsoft Support
DAX is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create new information from data already in your model. Why is DAX so important? It’s easy to create a workbook and import some data into it.
I get warnings about a program accessing email address information or ...
These features provide real-time protection for your computer to help guard against viruses, spyware, and other malicious software. One of the following security warnings appear: A program is trying to access e-mail address information stored in Outlook. If this is unexpected, click Deny and verify your antivirus software is up-to-date.