Excel Fundamentals

Course details

Chapter 1: Office Workspace Basics
• Basic Window Elements
• Exploring Microsoft Office Backstage
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with KeyTips
• Using the Status Bar
• Getting Help
Chapter 2: Introduction to Excel
• What is Excel?
• Getting to Know the Excel Window
• Moving the Cell Selector
• Opening a Workbook
• Navigating a Workbook
• Selecting Cells
• Creating Workbooks
• Saving a Workbook
• Closing a Workbook
Chapter 3: Entering and Editing Data
• Entering Text, Numbers, and Data
• Editing Data
• Using AutoComplete and AutoFill
• Copying Data
• Moving and Clearing Data
• Using Undo and Redo
• Finding and Replacing Data
Chapter 4: Introduction to Formulas and Functions
• What are Formulas and Functions?
• Entering Formulas
• Entering Functions
• Using the Insert Function Tool
• Using AutoSum
• Copying and Moving Formulas
Chapter 5: Working with Functions
• Using Statistical Functions
• Using Financial Functions
• Testing Conditions with IF
• Using Date and Time Functions
• Using Linked Values in Formulas
• Copying Formula Values
• Controlling Automatic Calculations
Chapter 6: Formatting Data 
• Introduction to Formatting
• Applying Number Formats
• Applying Font Formats
• Changing Cell Alignment
• Applying Cell Styles
• Copying Formats
• Clearing Formats
• Finding and Replacing Formats
Chapter 7: Formatting Worksheets 
• Inserting and Deleting Rows and Columns
• Inserting and Deleting Cells
• Adjusting Column and Row Sizes
• Hiding Worksheet Components
• Inserting and Deleting Worksheets
• Copying and Moving Worksheets
• Customizing Sheet Tabs
• Adding a Worksheet Background
Chapter 8: Adding Charts and Graphics 
• Creating a Chart
• Enhancing a Chart
• Modifying Chart Data
• Changing Chart Types
• Drawing Shapes
• Inserting Pictures
• Creating SmartArt
Chapter 9: Viewing and Printing Workbooks
• Changing View Options
• Splitting and Freezing a Worksheet
• Sorting and Filtering Data Info about Slicers
• Customizing the Page Layout
• Adding Headers and Footers
• Modifying Page Breaks
• Previewing and Printing the Worksheet
• Printing Selected Data
Chapter 10: Managing Workbooks 
• Arranging Multiple Workbooks
• Adding Hyperlinks
• Working with Comments
• Saving Workbooks in Different Formats
• Saving a Workbook as a Web Pages
• Creating Folders
• E-Mailing a Workbook Updated on 15 January, 2024