Microsoft Office Forum
Forum Thread: How to Create Excel KPI Dashboard with Gauge Control
This video helps you to create Excel KPI Dashboards and Excel Dashboard Templates with gauges in Excel. No VBA code used to build!
Forum Thread: How to Consolidate Multiple Worksheets into One Excel Pivot Table
To summarize and report results from separate worksheet ranges, we can consolidate data from each separate worksheet range into a PivotTable report on a master worksheet.
Forum Thread: Please Excuse My Dear Aunt Sally
Be very careful while using the mathematical operators in excel. Use parenthesis to group the numbers. Excel follows the mathematical order of operators BODMAS
Forum Thread: How to Work with Excel Keyboard Shortcuts
Excel keyboard shortcuts generally start with by pressing the “Alt” key. So, once you press the “Alt” key, you will see a shortcut or in fact an alphabet for each tab in the ribbon. Like F is for File, H is for Home, N for insert and so on. In the old excel interface, I mean 2003, you can find an underline under the letter in the menu which denotes the short key.
Forum Thread: How to Get a Dynamic Dropdown List in Excel
When working with lists and reports, you sometimes have repetitive data which you want to enter again and again. While you have the excel autocomplete function but if you have similar tellers at the beginning of the data, the autocomplete wont function properly.
Forum Thread: How to Get Current Date and Time in Excel with a Click
Many times you are supposed to enter the current date or time in excel so here is what you do; simply go to the cell and enter control + colon and the current date is added.
Forum Thread: What Is the Difference Between a Main Summary Task and a Summary Task?
I am looking for the answer to this question mainly because I do not know the answer. New to project and this was asked in a school I attend.
Forum Thread: Excel "Recent/Pinned" Box Resets Itself
Excel is pinned to my taskbar; I have two workbooks that I've been using a lot lately, so naturally I pinned them to the right-click menu. The problem is, at least once a day that menu resets itself, so both of the pinned workbooks are unpinned and there are no files under the "Recent" heading. How can I stop this from happening again?
Forum Thread: Using Sumifs, Add a Filter for <Today()-365
I have a MS Query capturing inventory values and need to target the slowest moving inventory parts into segments based on their set-up dates. So if I have , =SUMIFS(M:M,E:E,"<=0",H:H,">0",J:J,"<=0",K:K,"<=0") and want to add the date filter (exclude records with setup date < today -365, How-to?
Forum Thread: Setting Page
Is There Anyway to Make a Settings Page in accrss That Has Data , Not a Form or Table Just a Single Page.
Forum Thread: Data Input and Data Store
Hello, I have the following situation:
Forum Thread: How to Distribute a List of Numbers Across an Equal Number of Rows and Columns?
I have a list of records with item numbers from 5,000 to 10,000. The list could have as few as 1 complete record and as many as 5,000. The list gets populated based on sales of a product. So every time some one purchases an item the transaction fills out the next record in the sequence.
Forum Thread: Fractions with words
How do I turn a number "2.5" into a fraction "2 1/2" in a cell when the cell contains words, "His contract ends in 2.5 weeks" to "His contract ends in 2 1/2 weeks" other than obviously imputing it manually?
Forum Thread: How to Translate Words Using Macros in Excel?
By entering English words I need to have them translated in specified by me cell(s) in any language I want.
Forum Thread: How to Convert Decimal Number with Apostrophe to Number with Decimal Point?
There is data column with decimal numbers with decimal apostrophe. I need to have same data in another column but numbers with decimal point.
Forum Thread: How to Freeze Worksheet Panes?
MY FIRST WORKSHEET PANE 1 IS FROZEN, but MY SECOND and THIRD ONE IS NOT—I CAN NOT FREEZE THEM. WHAT DO I GOT to DO?
Next Page
Prev Page