{"product_id":"microsoft-excel-training-course","title":"Microsoft Excel Training Course","description":"\u003cdiv\u003e\u003cp\u003eIntroduction to \u003cstrong\u003eMicrosoft Excel training\u003c\/strong\u003e empowers participants with key skills to create and edit worksheets, implement formulas and functions, and sort and filter detailed data with tables and slicers. Visualize the numbers in a consumable and professional format analyzing data with charting, conditional formatting, sparklines, and pivot tables.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eMicrosoft Excel Training Course Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this Microsoft Excel training, you will learn to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEfficiently navigate and manipulate worksheets and workbooks.\u003c\/li\u003e\n\u003cli\u003eImplement an income and expense statement with formulas, functions, and names.\u003c\/li\u003e\n\u003cli\u003eDesign a reusable data entry template that protects formulas.\u003c\/li\u003e\n\u003cli\u003eImplement conditional formatting to analyze sales information.\u003c\/li\u003e\n\u003cli\u003eConnect, prepare, and validate data employing editing tools, formulas, and Flash Fill.\u003c\/li\u003e\n\u003cli\u003eIdentify, sort, and select detailed data with tables and slicers.\u003c\/li\u003e\n\u003cli\u003ePresent and analyze data with conditional formatting, charting, sparklines, and printing parameters.\u003c\/li\u003e\n\u003cli\u003eConstruct IF functions that make decisions - present results visually.\u003c\/li\u003e\n\u003cli\u003eCombine data with 3-D formulas.\u003c\/li\u003e\n\u003cli\u003eAnalyze summary data with PivotTables and implement a quick dashboard.\u003c\/li\u003e\n\u003cli\u003eLeverage continued support with after-course one-on-one instructor coaching and computing sandbox.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eNone.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eMicrosoft Excel Training Exam Information\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearning Tree end-of-course exam included\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eMicrosoft Excel Training Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction to Microsoft Excel\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eWorking with cell ranges—navigating and selecting cells with the mouse and keyboard \u003c\/li\u003e\n\u003cli\u003eEntering and editing data and employing AutoFill to enter data \u003c\/li\u003e\n\u003cli\u003eInserting and deleting rows, columns, or cells. \u003c\/li\u003e\n\u003cli\u003eAdjusting column width and row height \u003c\/li\u003e\n\u003cli\u003eManipulating data with cut, copy, paste, with the clipboard, or dragging the mouse \u003c\/li\u003e\n\u003cli\u003eLeveraging multiple worksheets \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Formulas and Functions\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eWriting simple formulas \u003c\/li\u003e\n\u003cli\u003eExploring audit tools to examine and evaluate formulas \u003c\/li\u003e\n\u003cli\u003eReferencing cells in formulas using relative and absolute references \u003c\/li\u003e\n\u003cli\u003eConfiguring cells for the number format and alignment \u003c\/li\u003e\n\u003cli\u003eConstructing common functions with the aid of the function wizard and the Formula tab \u003c\/li\u003e\n\u003cli\u003eImplementing names in formulas and functions \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Worksheet Formatting and Presentation\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eSetting up initial cell formatting \u003c\/li\u003e\n\u003cli\u003eDrawing attention to data with formatting \u003c\/li\u003e\n\u003cli\u003eWorking with templates - Protecting cell ranges and worksheets \u003c\/li\u003e\n\u003cli\u003eAnalyzing data with conditional formatting \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Getting Data In and Out\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eImporting data into Excel from various sources: text, web, Microsoft Access, SQL (Structured Query Language) Server \u003c\/li\u003e\n\u003cli\u003eTransforming data with global replace and data tools \u003c\/li\u003e\n\u003cli\u003eTEXT and DATE functions \u003c\/li\u003e\n\u003cli\u003e2013 Flash Fill assistant \u003c\/li\u003e\n\u003cli\u003eSetting WISE (Written, Integrated, Synergistic, and Expansive) goals \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Sorting, Selecting and Subtotaling data\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eSubtotaling a Filtered list with the subtotal command \u003c\/li\u003e\n\u003cli\u003eImplementing Tables and Table Formulas \u003c\/li\u003e\n\u003cli\u003eSubtotaling a table with the Total Row \u003c\/li\u003e\n\u003cli\u003eFiltering Tables with Slicers \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Present Data Visually\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eLeveraging charts to create a visual presentation \u003c\/li\u003e\n\u003cli\u003eCreating charts using wizards \u003c\/li\u003e\n\u003cli\u003eAdjusting chart settings, including titles, labels, and chart types \u003c\/li\u003e\n\u003cli\u003eWorking with Views of the spreadsheet \u003c\/li\u003e\n\u003cli\u003eSetting up your workbook for printing \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Introducing Advanced Features\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eImplementing dates \u003c\/li\u003e\n\u003cli\u003eSummarizing data from other worksheets with 3-D formulas \u003c\/li\u003e\n\u003cli\u003eDesigning IF functions and conditional formatting \u003c\/li\u003e\n\u003cli\u003eAnalyzing summary data with Pivot tables and slicers \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"266A97US \/ 2026-06-10T09:00:00 \/ Online","offer_id":47534172438747,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"267D38US \/ 2026-07-08T09:00:00 \/ Austin","offer_id":48216535630043,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"268A75CN \/ 2026-08-19T09:00:00 \/ Ottawa","offer_id":48216535662811,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269C55US \/ 2026-09-23T09:00:00 \/ New York","offer_id":48216535695579,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AB50US \/ 2026-10-28T09:00:00 \/ Herndon, VA","offer_id":48216535728347,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BB94US \/ 2026-11-23T09:00:00 \/ Austin","offer_id":48216535761115,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271A21CN \/ 2027-01-06T09:00:00 \/ Ottawa","offer_id":48216535793883,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"272B25US \/ 2027-02-24T09:00:00 \/ New York","offer_id":48294634717403,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"273B50US \/ 2027-03-23T09:00:00 \/ Herndon, VA","offer_id":48500532478171,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274B44US \/ 2027-04-21T09:00:00 \/ Austin","offer_id":48619725291739,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"276A21CN \/ 2027-06-02T09:00:00 \/ Ottawa","offer_id":48825880248539,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/microsoft-excel-training-course","provider":"Learning Tree International","version":"1.0","type":"link"}