Microsoft Excel 2019 Basic
Microsoft Excel 2019 BasicFree Cheat SheetsVisit ref.customguide.comQuick Reference GuideThe Excel 2019 Program ScreenQuick Access ToolbarTitle BarKeyboard ShortcutsFormula BarGeneralClose ButtonOpen a workbook . Ctrl OCreate a new workbook . Ctrl NFile TabSave a workbook . Ctrl SRibbonPrint a workbook . Ctrl PClose a workbook . Ctrl WNameBoxHelp . F1Activate Tell Me field . Alt QActive CellSpell check . F7ColumnsCalculate worksheets . F9Create absolute reference . F4Scroll BarsRowsNavigationMove between cells . , ,,Right one cell . TabLeft one cell . Shift TabDown one cell . EnterUp one cell . Shift EnterWorksheet TabViewsZoomSliderDown one screen . Page DownTo first cell of active row . HomeEnable End mode . EndGetting StartedTo cell A1. Ctrl HomeTo last cell. Ctrl EndCreate a Workbook: Click the Filetab and select New or press Ctrl N. Double-click a workbook.Select an Entire Worksheet: Click theSelect All button where thecolumn and row headings meet.Open a Workbook: Click the File taband select Open or press Ctrl O.Select a recent file or navigate to thelocation where the file is saved.Select Non-Adjacent Cells: Click thefirst cell or cell range, hold down theCtrl key, and select any non-adjacentcell or cell range.Preview and Print a Workbook: Clickthe File tab and select Print.Cell Address: Cells are referenced bythe coordinates made from theircolumn letter and row number, suchas cell A1, B2, etc.Undo: Click the Undo button onthe Quick Access Toolbar.Redo or Repeat: Click the Redobutton on the Quick Access Toolbar.The button turns to Repeat onceeverything has been re-done.Use Zoom: Click and drag the zoomslider to the left or right.Select a Cell: Click a cell or use thekeyboard arrow keys to select it.Select a Cell Range: Click and dragto select a range of cells. Or, pressand hold down the Shift key whileusing the arrow keys to move theselection to the last cell of the range.Click the topic links for free lessons!EditingCut . Ctrl XCopy. Ctrl CPaste . Ctrl VUndo . Ctrl ZRedo . Ctrl YFind . Ctrl FReplace . Ctrl HEdit active cell . F2Clear cell contents. DeleteFormattingJump to a Cell: Click in the NameBox, type the cell address you wantto go to, and press Enter.Change Views: Click a View button inthe status bar. Or, click the View taband select a view.Recover an Unsaved Workbook:Restart Excel. If a workbook can berecovered, it will appear in theDocument Recovery pane. Or, clickthe File tab, click Recover unsavedworkbooks to open the pane, andselect a workbook from the pane.Bold . Ctrl BItalics . Ctrl IUnderline . Ctrl UOpen Format CellsCtrl Shiftdialog box . FSelect All. Ctrl ASelect entire row . Shift SpaceSelect entire column . Ctrl SpaceHide selected rows . Ctrl 9Hide selected columns. Ctrl 0 2020 CustomGuide, Inc.Contact Us: sales@customguide.com
Edit a WorkbookBasic FormattingInsert ObjectsEdi a Cell s Con en s: Select a cell and click inthe Formula Bar or double-click the cell. Editthe cell s contents and press Enter.Format Text: Use the commands in the Fontgroup on the Home tab, or click the dialog boxlauncher in the Font group to open the dialogbox.Complete a Series Using AutoFill: Select thecells that define the pattern, i.e. a series ofmonths or years. Click and drag the fill handleto adjacent blank cells to complete the series.Clear a Cell s Con en s: Select the cell(s) andpress the Delete key. Or, click the Clearbutton on the Home tab and select ClearContents.Cut or Copy Data: Select cell(s) and click theCut or Copy button on the Home tab.Paste Data: Select the cell where you want topaste the data and click the Paste button inthe Clipboard group on the Home tab.Preview an Item Before Pasting: Place theinsertion point where you want to paste, clickthe Paste button list arrow in the Clipboardgroup on the Home tab, and hold the mouseover a paste option to preview.Paste Special: Select the destination cell(s),click the Paste button list arrow in theClipboard group on the Home tab, and selectPaste Special. Select an option and click OK.Move or Copy Cells Using Drag and Drop:Select the cell(s) you want to move or copy,position the pointer over any border of theselected cell(s), then drag to the destinationcells. To copy, hold down the Ctrl key beforestarting to drag.Find and Replace Text: Click the Find &Select button, select Replace. Type the textyou want to find in the Find what box. Type thereplacement text in the Replace with box. Clickthe Replace All or Replace button.Check Spelling: Click the Review tab and clickthe Spelling button. For each result, selecta suggestion and click the Change/ChangeAll button. Or, click the Ignore/Ignore Allbutton.Insert a Column or Row: Right-click to the rightof the column or below the row you want toinsert. Select Insert in the menu, or click theInsertbutton on the Home tab.Delete a Column or Row: Select the row orcolumn heading(s) you want to remove. Rightclick and select Delete from the contextualmenu, or click the Deletebutton in the Cellsgroup on the Home tab.Hide Rows or Columns: Select the rows orcolumns you want to hide, click the Formatbutton on the Home tab, select Hide &Unhide, and select Hide Rows or HideColumns.Basic FormattingChange Cell Alignment: Select the cell(s) youwant to align and click a vertical alignment, ,button or a horizontal alignment, ,button in the Alignment group on theHome tab.Click the topic links for free lessons!Format Values: Use the commands in theNumber group on the Home tab, or click thedialog box launcher in the Number group toopen the Format Cells dialog box.Wrap Text in a Cell: Select the cell(s) thatcontain text you want to wrap and click theWrap Text button on the Home tab.Merge Cells: Select the cells you want tomerge. Click the Merge & Center buttonlist arrow on the Home tab and select a mergeoption.Cell Borders and Shading: Select the cell(s)you want to format. Click the Bordersbutton and/or the Fill Color button andselect an option to apply to the selected cell.Copy Formatting with the Format Painter:Select the cell(s) with the formatting you wantto copy. Click the Format Painter button inthe Clipboard group on the Home tab. Then,select the cell(s) you want to apply the copiedformatting to.Adjust Column Width or Row Height: Click anddrag the right border of the column header orthe bottom border of the row header. Doubleclick the border to AutoFit the column or rowaccording to its contents.Basic FormulasEnter a Formula: Select the cell where youwant to insert the formula. Type and enterthe formula using values, cell references,operators, and functions. Press Enter.Insert an Image: Click the Insert tab on theribbon, click either the Picturesor OnlinePicturesbutton in the Illustrations group,select the image you want to insert, and clickInsert.Insert a Shape: Click the Insert tab on theribbon, click the Shapes button in theIllustrations group, and select the shape youwish to insert.Hyperlink Text or Images: Select the text orgraphic you want to use as a hyperlink. Clickthe Insert tab, then click the Linkbutton.Choose a type of hyperlink in the left pane ofthe Insert Hyperlink dialog box. Fill in thenecessary informational fields in the right pane,then click OK.Modify Object Properties and Alternative Text:Right-click an object. Select Edit Alt Text inthe menu and make the necessarymodifications under the Properties and Alt Textheadings.View and Manage WorksheetsInsert a New Worksheet: Click the InsertWorksheet button next to the sheet tabsbelow the active sheet. Or, press Shift F11.Delete a Worksheet: Right-click the sheet taband select Delete from the menu.Hide a Worksheet: Right-click the sheet taband select Hide from the menu.Insert a Function: Select the cell where youwant to enter the function and click the InsertFunction button next to the formula bar.Rename a Worksheet: Double-click the sheettab, enter a new name for the worksheet, andpress Enter.Reference a Cell in a Formula: Type the cellreference (for example, B5) in the formula orclick the cell you want to reference.Change a Workshee s Tab Color: Right-clickthe sheet tab, select Tab Color, and choosethe color you want to apply.SUM Function: Click the cell where you want toinsert the total and click the Sum button inthe Editing group on the Home tab. Enter thecells you want to total, and press Enter.Move or Copy a Worksheet: Click and drag aworksheet tab left or right to move it to a newlocation. Hold down the Ctrl key while clickingand dragging to copy the worksheet.MIN and MAX Functions: Click the cell whereyou want to place a minimum or maximumvalue for a given range. Click the Sumbutton list arrow on the Home tab and selecteither Min or Max. Enter the cell range youwant to reference, and press Enter.Switch Between Excel Windows: Click theView tab, click the Switch Windowsbutton, and select the window you want tomake active.COUNT Function: Click the cell where youwant to place a count of the number of cells ina range that contain numbers. Click the Sumbutton list arrow on the Home tab and selectCount Numbers. Enter the cell range youwant to reference, and press Enter.Freeze Panes: Activate the cell where youwant to freeze the window, click the View tabon the ribbon, click the Freeze Panesbutton in the Window group, and select anoption from the list.Select a Print Area: Select the cell range youwant to print, click the Page Layout tab on theribbon, click the Print Area button, andselect Set Print Area.Adjust Page Margins, Orientation, Size, and2020 CustomGuide,Inc.Breaks: Click the Page Layouttab on theContactribbonand useUs:the sales@customguide.comcommands in the PageSetup group, or click the dialog box launcherin the Page Setup group to open the Page
Microsoft Excel 2019 IntermediateQuick Reference GuideFree Cheat SheetsVisit ref.customguide.comChart OptionsChart ElementsChart artAreaGridlineAxisTitlesLegendChartsChartsCreate a Chart: Select the cell range that containsthe data you want to chart. Click the Insert tab onthe ribbon. Click a chart type button in the Chartsgroup and select the chart you want to insert.Insert a Sparkline: Select the cells you want tosummarize. Click the Insert tab and select thesparkline you want to insert. In the Location Rangefield, enter the cell or cell range to place thesparkline and click OK.Move or Resize a Chart: Select the chart. Placeece ec ab der and, with the 4headed arrow showing, click and drag to moveit. Or, click and drag a sizing handle to resize it.Change the Chart Type: Select the chart and clickthe Design tab. Click the Change Chart Typebutton and select a different chart.Filter a Chart: With the chart you want to filterselected, click the Filter button next to it.Deselect the items you want to hide from the chartview and click the Apply button.Create a Dual Axis Chart: Select the cell range youwant to chart, click the Insert tab, click theCombo button, and select a combo chart type.Print and DistributeSet the Page Size: Click the Page Layout tab.Click the Size button and select a page size.Set the Print Area: Select the cell range you wantto print. Click the Page Layout tab, click the PrintArea button, and select Set Print Area.PaC aLege d: Select the chart, clickthe Chart Elements button, click the Legendbutton, and select a position for the legend.Print Titles, Gridlines, and Headings: Click thePage Layout tab. Click the Print Titlesbuttonand set which items you wish to print.Show or Hide Chart Elements: Select the chartand click the Chart Elements button. Then,use the check boxes to show or hide eachelement.Add a Header or Footer: Click the Insert tab andclick the Header & Footer button. Complete theheader and footer fields.Insert a Trendline: Select the chart where youwant to add a trendline. Click the Design tab onthe ribbon and click the Add Chart Elementbutton. Select Trendline from the menu.Adjust Margins and Orientation: Click the PageLayout tab. Click the Margins button to selectfrom a list of common page margins. Click theOrientation button to choose Portrait orLandscape orientation.Click the topic links for free lessons!Chart TypesColumn: Used to comparedifferent values vertically side-byside. Each value is represented inthe chart by a vertical bar.Line: Used to illustrate trendsover time (days, months, years).Each value is plotted as a pointon the chart and values areconnected by a line.Pie: Useful for showing values asa percentage of a whole when allthe values add up to 100%. Thevalues for each item arerepresented by different colors.Bar: Similar to column charts,except they display information inhorizontal bars rather than invertical columns.Area: Similar to line charts,except the areas beneath thelines are filled with color.XY (Scatter): Used to plotclusters of values using singlepoints. Multiple items can beplotted by using different coloredpoints or different point symbols.Stock: Effective for reporting thefluctuation of stock prices, suchas the high, low, and closingpoints for a certain day.Surface: Useful for findingoptimum combinations betweentwo sets of data. Colors andpatterns indicate values that arein the same range.Additional Chart ElementsData Labels: Display values from the cellsof the worksheet on the plot area of thechart.Data Table: A table added next to thechart that shows the worksheet data thechart is illustrating.Error Bars: Help you quickly identifystandard deviations and error margins.Trendline: Identifies the trend of thecurrent data, not actual values. Can alsoidentify forecasts for future data.2020 CustomGuide, Inc.Contact Us: sales@customguide.com
Intermediate FormulasManage DataTablesAbsolute References: Absolute referencesalways refer to the same cell, even if theformula is moved. In the formula bar, add dollarsigns ( ) to the reference you want to remainabsolute (for example, A 1 makes thecolumn and row remain constant).Export Data: Click the File tab. At the left,select Export and click Change File Type.Select the file type you want to export the datato and click Save As.Remove Duplicate Values: Click any cell in thetable and click the Data tab on the ribbon.Click the Remove Duplicates button.Select which columns you want to check forduplicates and click OK.Name a Cell or Range: Select the cell(s), clickthe Name box in the Formula bar, type a namefor the cell or range, and press Enter. Namescan be used in formulas instead of celladdresses, for example: B4*Rate.Reference Other Worksheets: To referenceanother worksheet in a formula, add anexclamation point ! af e e ee a ethe formula, for example: FebruarySales!B4.Reference Other Workbooks: To referenceanother workbook in a formula, add brackets[] ad ef e a eefa, fexample: [FebruarySales.xlsx]Sheet1! B 4.Order of Operations: When calculating aformula, Excel performs operations in thefollowing order: Parentheses, Exponents,Multiplication and Division, and finally Additionand Subtraction (as they appear left to right).Use this mnemonic device to remember nate Text: Use the CONCAT function CONCAT(text1, e 2, ) to join the textfrom multiple cells into a single cell. Use thearguments within the function to define the textyou want to combine as well as any spaces orpunctuation.Payment Function: Use the PMT function PMT(ra e,nper,p , ) to calculate a loanamount. Use the arguments within the functionto define the loan rate, number of periods, andpresent value and Excel calculates thepayment amount.Date Functions: Date functions are used toadd a specific date to a cell. Some commondate functions in Excel include:DateTodayNow DATE(year,month,day) TODAY() NOW()Display Worksheet Formulas: Click theFormulas tab on the ribbon and then click theShow Formulas button. Click the ShowFormulas button again to turn off theformula view.Click the topic links for free lessons!Import Data: Click the Data tab on the ribbonand click the Get Data button. Select thecategory and data type, and then the file youwant to import. Click Import, verify thepreview, and then click the Load button.Use the Quick Analysis Tools: Select the cellrange you want to summarize. Click the QuickAnalysisbutton that appears. Select theanalysis tool you want to use. Choose fromformatting, charts, totals, tables, or sparklines.Outline and Subtotal: Click the Data tab on theribbon and click the Subtotal button. Usethe dialog box to define which column you wantto subtotal and the calculation you want to use.Click OK.Use Flash Fill: Click in the cell to the right of thecell(s) where you want to extract or combinedata. Start typing the data in the column. Whena pattern is recognized, Excel predicts theremaining values for the column. Press Enterto accept the Flash Fill values.Create a Data Validation Rule: Select the cellsyou want to validate. Click the Data tab andclick the Data Validation button. Click theAllow list arrow and select the data you wantto allow. Set additional validation criteriaoptions and click OK.TablesFormat a Cell Range as a Table: Select thecells you want to apply table formatting to.Click the Format as Tablebutton in theStyles group of the Home tab and select a tableformat from the gallery.Sort Data: Select a cell in the column you wantto sort. Click the Sort & Filter button on theHome tab. Select a sort order or selectCustom Sort to define specific sort criteria.Filter Data: Click the filter arrow for thecolumn you want to filter. Uncheck the boxesfor any data you want to hide. Click OK.Add Table Rows or Columns: Select a cell inthe row or column next to where you want toadd blank cells. Click the Insertbutton listarrow on the Home tab. Select either InsertTable Rows Above or Insert Table Columnsto the Left.Insert a Slicer: With any cell in the tableselected, click the Design tab on the ribbon.Click the Insert Slicer button. Select thecolumns you want to use as slicers and clickOK.Table Style Options: Click any cell in the table.Click the Design tab on the ribbon and selectan option in the Table Style Options group.Intermediate FormattingApply Conditional Formatting: Select the cellsyou want to format. On the Home tab, click theConditional Formattingbutton. Select aconditional formatting category and then therule you want to use. Specify the format toapply and click OK.Apply Cell Styles: Select the cell(s) you want toformat. On the Home tab, click the Cell Stylesbutton and select a style from the menu.You can also select New Cell Style to define acustom style.Apply a Workbook Theme: Click the PageLayout tab on the ribbon. Click the Themesbutton and select a theme from the menu.Collaborate with ExcelAdd a Cell Comment: Click the cell where youwant to add a comment. Click the Review tabon the ribbon and click the New Commentbutton. Type your comment and then clickoutside of it to save the text.Invite People to Collaborate: Click the Sharebutton on the ribbon. Enter the emailaddresses of people you want to share theworkbook with. Click the permissions button,select a permission level, and click Apply.Type a short message and click Send.Co-author Workbooks: When another useropens the workbook, click the ec einitials on the ribbon, to see what they areediting. Cells being edited by others appearwith a colored border or shading.Protect a Worksheet: Before protecting aworksheet, you need to unlock any cells youwant to remain editable after the protection isapplied. Then, click the Review tab on theribbon and click the Protect Sheetbutton.Select what you want to remain editable afterthe sheet is protected.Add a Workbook Password: Click the File taband select Save As. Click Browse to select asave location. Click the Tools button in thedialog box and select General Options. Set apassword to open and/or modify the workbook.Click OK.2020 CustomGuide, Inc.Contact Us: sales@customguide.com
Microsoft Excel 2019 AdvancedFree Cheat SheetsVisit ref.customguide.comQuick Reference GuidePivotTable LayoutPivotTable ElementsPivotTable Fields PanePivotTable FieldsPaneActive PivotTableSearch PivotTableFieldsFields PaneOptionsToolsMenuFieldListThe PivotTable Fields pane controls howdata is represented in the PivotTable.Click anywhere in the PivotTable toactivate the pane. It includes a Searchfield, a scrolling list of fields (these arethe column headings in the data rangeused to create the PivotTable), and fourareas in which fields are placed. Thesefour areas include:Filters: If a field is placed in theFilters area, a menu appears abovethe PivotTable. Each unique valuefrom the field is an item in themenu, which can be used to filterPivotTable data.Column Labels: The uniquevalues for the fields placed in theColumns area appear as columnheadings along the top of thePivotTable.PivotTable FieldAreasRow Labels: The unique values forthe fields placed in the Rows areaappear as row headings along theleft side of the PivotTable.PivotTablesPivotChartsCreate a PivotTable: Select the data range to beused by the PivotTable. Click the Insert tab onthe ribbon and click the PivotTable button inthe Tables group. Verify the range and then clickOK.Create a PivotChart: Click any cell in a PivotTableand click the Analyze tab on the ribbon. Click thePivotChart button in the Tools group. Select aPivotChart type and click OK.Values: The al e a e he meaof the PivotTable, or the actual dataha calc la ed f he fieldplaced in the rows and/or columnsarea. Values are most oftennumeric calculations.Add Multiple PivotTable Fields: Click a field in thefield list and drag it to one of the four PivotTableareas that contains one or more fields.Filter PivotTables: Click and drag a field from thefield list into the Filters area. Click he field liarrow above the PivotTable and select thevalue(s) you want to filter.Group PivotTable Values: Select a cell in thePivotTable that contains a value you want togroup by. Click the Analyze tab on the ribbonand click the Group Field button. Specify howthe PivotTable should be grouped and then clickOK.Refresh a PivotTable: With the PivotTableselected, click the Analyze tab on the ribbon.Click the Refresh button in the Data group.Format a PivotTable: With the PivotTableselected, click the Design tab. Then, select thedesired formatting options from the PivotTableOptions group and the PivotTable Styles group.Click the topic links for free lessons!Modify PivotChart Data: Drag fields into and out ofthe field areas in the task pane.Refresh a PivotChart: With the PivotChart selected,click the Analyze tab on the ribbon. Click theRefresh button in the Data group.Not all PivotTables will have a field ineach area, and sometimes there will bemultiple fields in a single area.The Layout GroupModify PivotChart Elements: With the PivotChartselected, click the Design tab on the ribbon. Clickthe Add Chart Element button in the ChartElements group and select the item(s) you want toadd to the chart.Apply a PivotChart Style: Select the PivotChart andclick the Design tab on the ribbon. Select a stylefrom the gallery in the Chart Styles group.Update Chart Type: With the PivotChart selected,click the Design tab on the ribbon. Click theChange Chart Type button in the Type group.Select a new chart type and click OK.Enable PivotChart Drill Down: Click the Analyzetab. Click the Field Buttons list arrow in theShow/Hide group and select ShowExpand/Collapse Entire Field Buttons.Subtotals: Show or hide subtotals andspecify their location in the PivotTable.Grand Totals: Add or remove grand totalrows for columns and/or rows.Report Layout: Adjust the report layout toshow in compact, outline, or tabular form.Blank Rows: Emphasize groups of databy manually adding blank rows betweengrouped items.2020 CustomGuide, Inc.Contact Us: sales@customguide.com
MacrosAdvanced FormattingAdvanced FormulasEnable the Developer Tab: Click the File taband select Options. Select CustomizeRibbon at the left. Check the Developercheck box and click OK.Customize Conditional Formatting: Click theConditional Formatting button on theHome tab and select New Rule. Select a ruletype, then edit the styles and values. Click OK.VLOOKUP: Looks for and retrieves data from aspecific column in a table.Record a Macro: Click the Developer tab onthe ribbon and click the Record Macrobutton. Type a name and description thenspecify where to save it. Click OK. Completethe steps to be recorded. Click the StopRecording button on the Developer tab.Edit a Conditional Formatting Rule: Click theConditional Formatting button on theHome tab and select Manage Rules. Selectthe rule you want to edit and click Edit Rule.Make your changes to the rule. Click OK.Run a Macro: Click the Developer tab on theribbon and click the Macros button. Selectthe macro and click Run.Edit a Macro: Click the Developer tab on theribbon and click the Macros button. Select amacro and click the Edit button. Make thenecessary changes to the Visual Basic codeand click the Save button.Delete a Macro: Click the Developer tab onthe ribbon and click the Macros button.Select a macro and click the Delete button.Macro Security: Click the Developer tab onthe ribbon and click the Macro Securitybutton. Select a security level and click OK.Analyze DataCommon Formula Errors:ide enHLOOKUP: Looks for and retrieves data from aspecific row in a table.Goal Seek: Click the Data tab on the ribbon.Click the What-If Analysisbutton andselect Goal Seek. Specify the desired value forthe given cell and which cell can be changed toreach the desired result. Click OK.Advanced FormulasNested Functions: A nested function is whenone function is tucked inside another functionas one of its arguments, like this:Troubleshoot Formulas####### - The c l mn i ndisplay all cell data.Change the Order of Conditional FormattingRules: Click the Conditional Formattingbutton on the Home tab and select ManageRules. Select the rule you want to resequence. Click the Move Up or MoveDown arrow until the rule is positionedcorrectly. Click OK.UPPER, LOWER, and PROPER: Changes howtext is capitalized.UPPER Case lower case Proper Casegh#NAME? - The text in he f m la i nrecognized.#VALUE! - There is an error with one ormore formula arguments.IF: Performs a logical test to return one valuefor a true result, and another for a false result.LEFT and RIGHT: Extracts a given number ofcharacters from the left or right.#DIV/0 - The formula is trying to divide avalue by 0.#REF! - The formula references a cell thatno longer exists.Trace Precedents: Click the cell containing thevalue you want to trace and click the Formulastab on the ribbon. Click the Trace Precedentsbutton to see which cells affect the value inthe selected cell.Jan6,010Feb7,010Total13,020Error Checking: Select a cell containing anerror. Click the Formulas tab on the ribbonand click the Error Checking button in theFormula Auditing group. Use the dialog tolocate and fix the error.The Watch Window: Select the cell you want towatch. Click the Formulas tab on the ribbonand click the Watch Window button. Clickthe Add Watch button. Ensure the correctcell is identified and click Add.AND, OR, NOT: Often used with IF to supportmultiple conditions.MID: Extracts a given number of charactersfrom the middle of text; the example belowld e n da .AND requires multiple conditions.OR accepts several different conditions.NOT returns the opposite of the condition.MATCH: Locates the position of a lookup valuein a row or column.SUMIF and AVERAGEIF: Calculates cells thatmeet a condition.SUMIF finds the total.AVERAGEIF finds the average.INDEX: Returns a value or the reference to avalue from within a range.Evaluate a Formula: Select a cell with aformula. Click the Formulas tab on the ribbonand click the Evaluate Formula button.Click the topic links for free lessons!2020 CustomGuide, Inc.Contact Us: sales@customguide.com
Cut or Copy Data: Select cell(s) and click the Cut or Copy button on the Home tab. Paste Data: Select the cell where you want to paste the data and click the Paste button in the Clipboard group on the Home tab. Preview an Item Before Pasting: Place the insertion point where you want to paste, click the Paste button list arrow in the Clipboard
Excel 5.0 Excel 5.0 1993 Excel 5.0 1993 Excel 7.0 Excel 95 1995 Excel 8.0 Excel 97 1997 Excel 98 1998 Excel 9.0 Excel 2000 1999 Excel 2001 2000 Excel 10.0 Excel XP 2001 Excel v.X 2001 Excel 11.0 Excel 2003 2003 Excel 2004 2004 2.1.2 Worksheet Document Definition: Worksheet Document A worksheet document consists of a single sheet only.
Power Map Power Map provides a new perspective for your data by plotting geocoded data onto a three-dimensional view of the earth and optionally showing changes to that data over time. To use Power Map, you import raw data into a Microsoft Excel 2013 workbook, add the data to an Excel data model, and enhance the data in the data model if necessary.File Size: 1MBPage Count: 17Explore furtherGetting an excel list of all Azure Virtual machinesdbaharrison.blogspot.comDownload Azure Devops Board To Excelwww.how-use-excel.comGetting an excel list of all Azure Virtual machines .www.firstcloud.ioGetting an excel list of all Azure Virtual machines .laptrinhx.comRunning Excel On Azurewww.how-use-excel.comRecommended to you based on what's popular Feedback
1. Memulai Excel 2003 Untuk membuka aplikasi Excel 2003 kita dapat mengklik icon Excel yang ada pada layer desktop atau menggunakan menu Start All Program Microsoft Office Microsoft Office Excel 2003 hingga muncul tampilan lembar kerja Excel. Menu Microsoft Excel
Click the Excel 2019 app to run the Excel app and display the Excel start screen Click the Blank workbook thumbnail on the Excel start screen to create a blank Excel workbook in the Excel window-7-Starting and Using Excel (3 o
Microsoft Excel can also be used to balance a checkbook, create an expense report, build formulas, and edit them. CREATING A NEW DOCUMENT OPENING MICROSOFT EXCEL ON A PC To begin Microsoft Excel, Go to Start All Programs Applications Microsoft Office Microsoft Excel
click Start - (All) Programs - Microsoft Office - Microsoft Office Excel 2007. If you have a Microsoft Excel document in Windows Explorer, in My Documents, or in an email, etc, you can double-click it. This would also start Microsoft Excel and would open the document. The classic way users launch Microsoft Excel is from the Start menu on the .
Microsoft Excel Math Formula Guide . Microsoft Excel is a spreadsheet software that is used to organize and calculate data. This handout will focu s on how to use built-in Excel functions to solve basic mathematical calculations. Basics of Excel . An Excel sheet is a grid consisting
Starting Excel You start Excel from the Start menu in Windows. Click the Start button, click All Programs, click Microsoft Office, and then click Microsoft Excel 2010. The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Ribbon, Backstage view, and the status bar.
