{"id":152,"date":"2015-10-26T18:02:52","date_gmt":"2015-10-26T18:02:52","guid":{"rendered":"http:\/\/99excel.com\/?page_id=152"},"modified":"2015-12-19T07:24:10","modified_gmt":"2015-12-19T07:24:10","slug":"basic-excel-training","status":"publish","type":"page","link":"https:\/\/99excel.com\/home\/basic-excel-training\/","title":{"rendered":"Basic Excel Training"},"content":{"rendered":"<h1><\/h1>\n<p>&nbsp;<\/p>\n<h2><span style=\"color: #000000;\">Microsoft Excel Training &#8211; Course Topic Selections \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<span style=\"color: #ff0000;\">99<\/span>Excel.com<\/span><\/h2>\n<hr \/>\n<h2><\/h2>\n<p><strong>The Basics<\/strong><\/p>\n<p style=\"padding-left: 30px;\">Creating a New Workbook<br \/>\nNavigating in Excel<br \/>\nMoving the Cell Pointer<br \/>\nUsing Excel Menus<br \/>\nUsing Excel Toolbars: Hiding, Displaying, and Moving Toolbars<br \/>\nEntering Values in a Worksheet and Selecting a Cell Range<br \/>\nPreviewing and Printing a Worksheet<br \/>\nGetting Help from the Office Assistant<br \/>\nSaving a Workbook &amp; Re-opening a saved workbook<\/p>\n<p><strong>Formatting a Worksheet<\/strong><\/p>\n<p style=\"padding-left: 30px;\">Creating Headers, Footers, and Page Numbers<br \/>\nAdjusting Page Margins and Orientation<br \/>\nAdding Print Titles and Gridlines, rows to repeat at top of each page<br \/>\nFormatting Fonts &amp; Values<br \/>\nAdjusting Row Height and Column Width<br \/>\nChanging Cell Alignment<br \/>\nAdding Borders<br \/>\nApplying Colors and Patterns<br \/>\nUsing the Format Painter<br \/>\nUsing AutoFormat<br \/>\nMerging Cells, Rotating Text, and using AutoFit<br \/>\nUsing AutoFill<\/p>\n<p><strong>Managing your workbooks<\/strong><\/p>\n<p style=\"padding-left: 30px;\">Switching Between Sheets in a Workbook<br \/>\nInserting and Deleting Worksheets<br \/>\nRenaming and Moving Worksheets<br \/>\nProtecting a Workbook<br \/>\nHiding Columns, Rows and Sheets<br \/>\nSplitting and Freezing a Window<br \/>\nInserting Page Breaks<br \/>\nAdvanced Printing Options<\/p>\n<p><strong>Editing a Workbook<\/strong><\/p>\n<p style=\"padding-left: 30px;\">Entering Date Values and using AutoComplete<br \/>\nEditing, Clearing, and Replacing Cell Contents<br \/>\nCutting, Copying, and Pasting Cells<br \/>\nMoving and Copying Cells with Drag and Drop<br \/>\nCollecting and Pasting Multiple Items<br \/>\nUsing the Paste Special Command<br \/>\nInserting and Deleting Cells, Rows, and Columns<br \/>\nUsing Undo, Redo, and Repeat<br \/>\nChecking Your Spelling<br \/>\nFinding and Replacing Information<br \/>\nInserting Cell Comments<\/p>\n<p><strong>Formulas<\/strong><\/p>\n<p style=\"padding-left: 30px;\">Creating a basic Formula<br \/>\nCalculating Value Totals with AutoSum<br \/>\nEditing &amp; Copying Formulas<br \/>\nFixing Errors in Your Formulas<br \/>\nFormulas with Several Operators and Cell Ranges<\/p>\n<p><strong>Working with the Forms Menu<\/strong><\/p>\n<p style=\"padding-left: 30px;\">Sorting, Subtotaling &amp; Filtering Data<br \/>\nCopy &amp; Paste Filtered Records<br \/>\nUsing Data Validation<\/p>\n<p><strong>Creating &amp; Working with Charts<\/strong><\/p>\n<p style=\"padding-left: 30px;\">Creating a Chart<br \/>\nMoving and Resizing a Chart<br \/>\nFormatting and Editing Objects in a Chart<br \/>\nChanging a Chart&#8217;s Source Data<br \/>\nChanging a Chart Type and Working with Pie Charts<br \/>\nAdding Titles, Gridlines, and a Data Table<br \/>\nFormatting a Data Series and Chart Axis<br \/>\nAnnotating a Chart<br \/>\nWorking with 3-D Charts<br \/>\nSelecting and Saving a Custom Chart<br \/>\nUsing Fill Effects<br \/>\nMapping Data<br \/>\nModifying a Map<\/p>\n<p><strong>Data Analysis &amp; Pivot Tables<\/strong><\/p>\n<p style=\"padding-left: 30px;\">Creating a PivotTable<br \/>\nSpecifying the Data a PivotTable Analyzes<br \/>\nChanging a PivotTable&#8217;s Calculation<br \/>\nSelecting What Appears in a PivotTable<br \/>\nGrouping Dates in a PivotTable<br \/>\nUpdating a PivotTable<br \/>\nFormatting and Charting a PivotTable<\/p>\n<p><strong>Automating Tasks with Macros<\/strong><\/p>\n<p style=\"padding-left: 30px;\">Recording a Macro<br \/>\nPlaying a Macro and Assigning a Macro a Shortcut Key<br \/>\nAdding a Macro to a Toolbar<\/p>\n<p><strong>Working with Other Programs<\/strong><\/p>\n<p style=\"padding-left: 30px;\">Inserting an Excel Worksheet into a Word Document<br \/>\nModifying an Inserted Excel Worksheet<br \/>\nInserting a Linked Excel Chart in a Word Document<br \/>\nInserting a Graphic into a Worksheet<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-365\" src=\"http:\/\/99excel.com\/home\/wp-content\/uploads\/excelmodule1.png\" alt=\"excelmodule1\" width=\"720\" height=\"960\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Microsoft Excel Training &#8211; Course Topic Selections \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a099Excel.com The Basics Creating a New Workbook Navigating in Excel Moving the Cell Pointer Using Excel Menus Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars Entering Values in a Worksheet and Selecting a &#8230; <a title=\"Basic Excel Training\" class=\"read-more\" href=\"https:\/\/99excel.com\/home\/basic-excel-training\/\" aria-label=\"More on Basic Excel Training\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-152","page","type-page","status-publish"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/pages\/152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/comments?post=152"}],"version-history":[{"count":1,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/pages\/152\/revisions"}],"predecessor-version":[{"id":366,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/pages\/152\/revisions\/366"}],"wp:attachment":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/media?parent=152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}