Learn Microsoft EXCEL Training Self-Study Digital Course 12 Hrs

Description: Whether you are completely new to Excel or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply launch the easy-to-use interface, click to launch a video lesson or open the manual and you’re on your way to mastering Excel. This course will give you the skills you need to become great with Microsoft Excel.You’ll learn how to create and manage spreadsheets, use formulas and functions, charts and much much more….Plus, you’ll receive a certificate of completion that you can show off Topics Covered:Getting Acquainted with Excel 1. About Excel2. The Excel Environment3. The Title Bar4. The Ribbon5. The "File" Tab and Backstage View6. Scroll Bars7. The Quick Access Toolbar8. Touch Mode9. The Formula Bar10. The Workbook Window11. The Status Bar12. The Workbook View Buttons13. The Zoom Slider14. The Mini Toolbar15. Keyboard ShortcutsFile Management 1. Creating New Workbooks2. Saving Workbooks3. Closing Workbooks4. Opening Workbooks5. Recovering Unsaved Workbooks6. Opening a Workbook in a New Window7. Arranging Open Workbook Windows8. Freeze Panes9. Split Panes10. Hiding and Unhiding Workbook Windows11.Comparing Open Workbooks12. Switching Open Workbooks13. Switching to Full Screen View14. Working With Excel File Formats15. AutoSave Online WorkbooksData Entry1. Selecting Cells2. Entering Text into Cells3. Entering Numbers into Cells4. AutoComplete5. Pick from Drop-Down List6. Flash Fill7. Selecting Ranges8. Ranged Data Entry9. Using AutoFillCreating Formulas1. Ranged Formula Syntax2. Simple Formula Syntax3. Writing Formulas4. Using AutoSum5. Inserting Functions6. Editing a Range7. Formula AutoCorrect8. AutoCalculate9. Function CompatibilityCopying & Pasting Formulas1. Relative References and Absolute References2. Cutting, Copying, and Pasting Data3. AutoFilling Cells4. The Undo Button5. The Redo ButtonColumns & Rows1. Selecting Columns & Rows2. Adjusting Column Width and Row Height3. Hiding and Unhiding Columns and Rows4. Inserting and Deleting Columns and RowsFormatting Worksheets1. Formatting Cells2. The Format Cells Dialog Box3. Clearing All Formatting from Cells4. Copying All Formatting from Cells to Another AreaWorksheet Tools1. Inserting and Deleting Worksheets2. Selecting Multiple Worksheets3. Navigating Worksheets4. Renaming Worksheets5. Coloring Worksheet Tabs6. Copying or Moving WorksheetsSetting Worksheet Layout1. Using Page Break Preview2. Using the Page Layout View3. Opening The Page Setup Dialog Box4. Page Settings5. Setting Margins6. Creating Headers and Footers7. Sheet SettingsPrinting Spreadsheets1. Previewing and Printing WorksheetsHelping Yourself1. Using Excel Help2. The Tell Me Bar- 2016 Only3. The Smart Lookup and Insights- 2016 OnlyCreating 3D Formulas1. Creating 3D Formulas2. 3D Formula Syntax3. Creating 3D Range ReferencesNamed Ranges1. Naming Ranges2. Creating Names from Headings3. Moving to a Named Range4. Using Named Ranges in Formulas5. Naming 3D Ranges6. Deleting Named RangesConditional Formatting and Cell Styles1. Conditional Formatting2. Finding Cells with Conditional Formatting3. Clearing Conditional Formatting4. Using Table and Cell StylesPaste Special1. Using Paste Special2. Pasting LinksSharing Workbooks1. About Co-authoring and Sharing Workbooks2. Co-authoring Workbooks3. Adding Shared Workbook Buttons in Excel4. Traditional Workbook Sharing5. Highlighting Changes6. Reviewing Changes7. Using Comments and Notes8. Compare and Merge WorkbooksAuditing Worksheets1. Auditing Worksheets2. Tracing Precedent and Dependent Cells3. Tracing Errors4. Error Checking5. Using the Watch Window6. Cell ValidationOutlining Worksheets1. Using Outlines2. Applying and Removing OutlinesConsolidating Worksheets 1. Consolidating DataTables1. Creating a Table2. Adding an Editing Records3. Inserting Records and Fields4. Deleting Records and FieldsSorting Data1. Sorting Data2. Custom Sort OrdersFiltering Data1. Using AutoFilters2. Using the Top 10 AutoFilter3. Using a Custom AutoFilter4. Creating Advanced Filters5. Applying Multiple Criteria6. Using Complex Criteria7. Copying Filter Results to a New Location8. Using Database FunctionsUsing What-If Analysis1. Using Data Tables2. Using Scenario Manager3. Using Goal Seek4. Forecast SheetsTable-Related Functions1. The Hlookup and Vlookup Functions2. Using the IF, AND, and OR FunctionsSparklines1. Inserting and Deleting Sparklines2. Modifying SparklinesCreating Charts In Excel1. Creating Charts2. Selecting Charts and Chart Elements3. Adding Chart Elements4. Moving and Resizing Charts5. Changing the Chart Type6. Changing the Data Range7. Switching Column and Row Data8. Choosing a Chart Layout9. Choosing a Chart Style10. Changing Color Schemes11. Printing Charts12. Deleting ChartsFormatting Charts in Excel1. Formatting Chart Objects2. Inserting Objects into a Chart3. Formatting Axes4. Formatting Axis Titles5. Formatting a Chart Title6. Formatting Data Labels7. Formatting a Data Table8. Formatting Error Bars9. Formatting Gridlines10. Formatting a Legend11. Formatting Drop and High-Low Lines12. Formatting Trendlines13. Formatting Up/Down Bars14. Formatting the Chart and Plot Areas15. Naming Charts16. Applying Shape Styles17. Applying WordArt Styles18. Saving Custom Chart TemplatesData Models1. Creating a Data Model from External Relational Data2. Creating a Data Model from Excel Tables3. Enabling Legacy Data Connections4. Relating Tables in a Data Model5. Managing a Data ModelPivotTables and PivotCharts1. Creating Recommended PivotTables2. Manually Creating a PivotTable3. Creating a PivotChart4. Manipulating a PivotTable or PivotChart5. Changing Calculated Value Fields6. Formatting PivotTables7. Formatting PivotCharts8. Setting PivotTable Options9. Sorting and Filtering Using Field HeadersPowerPivot1. Starting PowerPivot2. Managing the Data Model3. Calculated Columns and Fields4. Measures5. Creating KPIs6. Creating and Managing Perspectives7. PowerPivot PivotTables and PivotCharts3D Maps1. Enabling 3D Maps2. Creating a New 3D Maps Tour3. Editing a 3D Maps Tour4. Managing Layers in a 3D Maps Tour5. Filtering Layers6. Setting Layer Options7. Managing Scenes8. Custom 3D Maps9. Custom Regions10. World Map Options11. Inserting 3D Map Objects12. Previewing a Scene13. Playing a 3D Maps Tour14. Creating a Video of a 3D Maps Tour15. 3D Maps OptionsSlicers and Timelines1. Inserting and Deleting Slicers2. Modifying Slicers3. Inserting and Deleting Timelines4. Modifying TimelinesSecurity Features1. Unlocking Cells2. Worksheet Protection3. Workbook Protection4. Password Protecting Excel FilesMaking Macros1. Recording Macros2. Running and Deleting Recorded Macros3. The Personal Macro Workbook

Price: 5 USD

Location: pte aux piment triolet

End Time: 2024-02-16T19:40:49.000Z

Shipping Cost: N/A USD