MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Excel 2013 Fundamentals

### Course Summary

This course covers everything you need to know to get started in Excel 2013. Starting with an overview of how to navigate in Excel using both the mouse and keyboard shortcuts, Heather Ackmann dives into popular topics including writing formulas and expres

• +

### Course Syllabus

 ● Introduction to Excel 2013 ◦ Introduction ◦ Creating a New Workbook ◦ Opening an Existing Workbook ◦ Signing into Excel 2013 ◦ The Ribbon ◦ The Quick Access Toolbar ◦ The Formula Bar ◦ The Status Bar ◦ Navigating, Selecting, and Entering Data ◦ Introduction ◦ Navigating a Spreadsheet ◦ Selecting and Entering Data ◦ AutoFill ◦ FlashFill ◦ Saving ● Working with Rows, Columns, and Worksheets ◦ Introduction ◦ Inserting and Deleting Rows and Columns ◦ Hiding and Unhiding Rows and Columns ◦ Adding, Renaming, and Coloring Worksheets ◦ Moving and Deleting Worksheets ◦ Viewing Multiple Worksheets or Workbooks ● Introduction to Formulas ◦ Introduction ◦ Excel Math ◦ Creating a Simple Formula ◦ Relative, Absolute, and Named References ◦ Named References ● Introduction to Functions and 3D Formulas ◦ Introduction ◦ Excel Functions ◦ Sum, Average, and Count ◦ Introduction to 3D Formulas ● Sorting and Filtering Data ◦ Introduction ◦ Quick Sort and Custom Sort ◦ Creating Subtotals ◦ AutoFilter ◦ Custom Filters ◦ Advanced Filters ● Introduction to Formatting ◦ Formatting Basics ◦ Working with Alignment ◦ Number Formats ◦ Date and Times ◦ Conditional Formatting ● Introduction to Charts ◦ Introduction ◦ Chart Types ◦ Creating a Chart ◦ Chart Elements ◦ Chart Filters ◦ Change the Chart Type ◦ Sparklines and Data Bars ◦ Introduction to PivotTables and PivotCharts ◦ Introduction ◦ Creating a PivotTable ◦ Formatting a PivotTable ◦ Creating a Calculated Field ◦ Slicers ◦ Creating a PivotChart ◦ Introduction to Printing ◦ Introduction ◦ Print Views and Page Breaks ◦ Print Scaling ◦ Print Settings ◦ Adding Print Titles and Gridlines ◦ Conclusion ◦ Conclusion

Course Fee:
USD 29

Self-Study

Active