{"id":31,"date":"2015-08-26T16:33:33","date_gmt":"2015-08-26T16:33:33","guid":{"rendered":"http:\/\/99excel.com\/?page_id=17"},"modified":"2016-06-10T07:04:34","modified_gmt":"2016-06-10T07:04:34","slug":"advance-excel-training","status":"publish","type":"page","link":"https:\/\/99excel.com\/home\/advance-excel-training\/","title":{"rendered":"Advance Excel Training"},"content":{"rendered":"

<\/h1>\n

Introductory Topics \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a099<\/span>Excel.com<\/span><\/h1>\n
\n

Getting started<\/strong>
\n\u2022 Topic A: Spreadsheet terminology
\n\u2022 Topic B: Exploring the Excel window
\n\u2022 Topic C: Getting help
\n\u2022 Topic D: Navigating workbooks
\nEntering and editing data<\/strong>
\n\u2022 Topic A: Entering and editing text and values
\n\u2022 Topic B: Entering and editing formulas
\n\u2022 Topic C: Working with pictures
\n\u2022 Topic D: Saving and updating workbooks
\nAdvanced functions<\/strong>
\n\u2022 Topic A: Logical functions
\n\u2022 Topic B: Math and statistical functions
\n\u2022 Topic C: Financial functions
\n\u2022 Topic D: Displaying and printing formulas
\nLookups and data tables<\/strong>
\n\u2022 Topic A: Using lookup functions
\n\u2022 Topic B: Using MATCH and INDEX
\n\u2022 Topic C: Creating data tables
\nAdvanced list management<\/strong>
\n\u2022 Topic A: Validating cell entries
\n\u2022 Topic B: Exploring database functions
\nPivotTables and PivotCharts
\n\u2022 Topic A: Working with PivotTables
\n\u2022 Topic B: Rearranging PivotTables
\n\u2022 Topic C: Formatting PivotTables
\n\u2022 Topic D: PivotCharts
\nExporting and importing<\/strong>
\n\u2022 Topic A: Exporting and importing text files
\n\u2022 Topic B: Exporting and importing XML data
\n\u2022 Topic C: Querying external databases
\nAnalytical options<\/strong>
\n\u2022 Topic A: Goal Seek and Solver
\n\u2022 Topic B: The Analysis ToolPak
\n\u2022 Topic C: Scenarios
\n\u2022 Topic D: Views
\nMacros and custom functions<\/strong>
\n\u2022 Topic A: Running and recording a macro
\n\u2022 Topic B: Working with VBA code
\n\u2022 Topic C: Creating functions
\nConditional formatting and SmartArt<\/strong>
\n\u2022 Topic A: Conditional formatting with graphics
\n\u2022 Topic B: SmartArt graphics
\nPower User Topics<\/p>\n

Advanced formulas, functions, and arrays<\/strong>
\n\u2022 Topic A: Text functions
\n\u2022 Topic B: Date and time functions
\n\u2022 Topic C: Information functions
\n\u2022 Topic D: Array formulas
\nAdvanced editing and formatting<\/strong>
\n\u2022 Topic A: The Paste Special command
\n\u2022 Topic B: The Go To Special dialog box
\n\u2022 Topic C: Merging styles
\n\u2022 Topic D: Additional chart formatting
\nAnalyzing and sharing information<\/strong>
\n\u2022 Topic A: Wizard add-ins
\n\u2022 Topic B: Solver models and reports
\n\u2022 Topic C: Statistical analysis tools
\n\u2022 Topic D: Embedding and linking
\nAdvanced customization<\/strong>
\n\u2022 Topic A: Popular and Save options
\n\u2022 Topic B: Formulas options
\n\u2022 Topic C: Automating Excel
\n\u2022 Topic D: Advanced options<\/p>\n

 <\/p>\n

 <\/p>\n

\"excelmodule2\"<\/p>\n

 <\/p>\n

 <\/p>\n

[sg_popup id=1]<\/p>\n","protected":false},"excerpt":{"rendered":"

Introductory Topics \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a099Excel.com Getting started \u2022 Topic A: Spreadsheet terminology \u2022 Topic B: Exploring the Excel window \u2022 Topic C: Getting help \u2022 Topic D: Navigating workbooks Entering and editing data \u2022 Topic A: Entering and editing text and values \u2022 Topic B: Entering and editing formulas \u2022 Topic … 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-31","page","type-page","status-publish"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/pages\/31","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=31"}],"version-history":[{"count":4,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/pages\/31\/revisions"}],"predecessor-version":[{"id":463,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/pages\/31\/revisions\/463"}],"wp:attachment":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/media?parent=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}