office-winner

Power BI Desktop puts visual analytics at your fingertips with intuitive report authoring. Drag-and-drop to place content exactly where you want it on the flexible and fluid canvas. Quickly discover patterns as you explore a single unified view of linked, interactive visualizations.   https://powerbi.microsoft.com/en-us/ Power BI - Overview and Learning Microsoft Power BI is a collection of online services and features that enables you to find and visualize data, share discoveries, and collaborate in intuitive new ways. There are two experiences now available for Power BI: the new experience , generally referred to as Power BI , and the previous experience which is referred to as Power BI for Office 365 . The new experience is centered on PowerBI.com , an online service where you can quickly create dashboards, share reports, and directly connect to (and incorporate) all the data that’s important to you. The new experien...

ctrl+arrow keys: Move to the edge of next data region (cells that contains data)(MS Excel-Version: 2007)(MS Excel-Version: 2010) Navigate Inside Worksheets end : Turn 'End' mode on. In End mode, press arrow keys to move to the next nonblank cell in the same column or row as the active cell. From here use arrow keys to move by blocks of data, home to move to last cell, or enter to move to the last cell to the right(MS Excel-Version: 2010) Work With Data Selections ctrl+shift+o : Select all cells with comments(MS Excel-Version: 2010) Manage Active Selections shift+f8 : Add another (adjacent or non-adjacent) range of cells to the selection. Use arrow keys and shift+arrow keys to add to selection(MS Excel-Version: 2010) Manage Active Selections shift+backspace : Select only the active cell when multiple cells are selected(MS Excel-Version:2003,2007,2010) Select inside cells shift+arrow left / shift+arrow right : Select or unselect one character to the le...

  Keyboard shortcuts specific to MS Excel Escape - Esc is used to back out of situations. When you find yourself in a place where you don't want to be, try the Esc key. In PowerPoint this key will stop a running slide show. The keyboard combination Ctrl + Esc will open the Start menu. www.officewin.blogspot.com F1 - While working in an application, depressing this key will bring up the applications help menu. If there is no open application F1 will open Windows Help . www.officewin.blogspot.com F2 - Choose this key to rename a selected item. Alt + Ctrl + F2 to open a new document in MS Word Ctrl + F2 to open print preview in MS Word (this is a toggle, tap the keys again to return to the edit page) www.officewin.blogspot.com F3 - Depressing this key will display the Find: All Files dialog box. 2 - Shift + F3 will change case in MS Word. Continue to press F3 ( with the Shift key depressed) to toggle through all choices. www.officewin.blogspo...

Excel provides three handy functions to change the case of text:  UPPER: Converts the text to ALL UPPERCASE.  LOWER: Converts the text to all lowercase.  PROPER: Converts the text to Proper Case. (The First Letter In Each Word Is Capitalized.) These functions are quite straightforward. The formula that follows, for example, converts the text in cell A1 to proper case. If cell A1 contained the text MR. JOHN Q. PUBLIC, the formula would . =PROPER(A1) These functions operate only on alphabetic characters; they ignore all other characters and return them unchanged.

Removing excess spaces and non printing characters Often data imported into an Excel worksheet contains excess spaces or strange (often unprintable) characters. Excel provides you with two functions to help whip your data into shape: TRIM and CLEAN:  TRIM removes all leading and trailing spaces, and it replaces internal strings of multiple spaces by a single space.  CLEAN removes all nonprinting characters from a string. These “garbage” characters often appear when you import certain types of data. This example uses the TRIM function. The formula returns Fourth Quarter Earnings (with no excess spaces): =TRIM(“   Fourth    Quarter     Earnings     “)

Joining two or more cells Excel uses an ampersand (&) as its concatenation operator. Concatenation is simply a fancy term that describes what happens when you join the contents of two or more cells. For example, if cell A1 contains the text Tucson and cell A2 contains the text Arizona, the following formula then returns TucsonArizona: =A1&A2 Notice that the two strings are joined together without an intervening space. To add a space between the two entries (to get Tucson Arizona), use a formula like this one: =A1&” “&A2 Or, even better, use a comma and a space to produce Tucson, Arizona: =A1&”, “&A2 Another option is to eliminate the quote characters and use the CHAR function, with an appropriate argument. Note this example of using the CHAR function to represent a comma (44) and a space (32): =A1&CHAR(44)&CHAR(32)&A2 If you’d like to force a line break between strings, concatenate the strings by using CHAR(10), which inserts a line break character....

Counts the cells that contain numbers in a column of a list or database that match conditions that you specify. The field argument is optional. If field is omitted, DCOUNT counts all records in the database that match the criteria. Syntax DCOUNTA ( database , field , criteria ) Database      is the range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column. Field       indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on. Criteria       is the range of cells that contains the conditions that you specify....