Microsoft Excel Online Training

Excel is a powerful program that is used for data analysis and documentation. It uses tables and cells inside rows and columns to organize data and perform the necessary calculations. Using a spreadsheet system, users can use formulas to organize, calculate, and format data. Excel is widely used in workplaces around the world, as it is an excellent program for analyzing stocks, forecasting, budgeting, organizing client sales lists, and a lot more. Businesses need to use this computer program as a primary tool for work because of its different powerful functions and applications.

In this course, students will get familiar with basic spreadsheet concepts and Excel’s use cases. They will learn how to manage their workbooks, work with cells, format cells and numbers, set borders, align text, and modify columns, rows, cells, format worksheets, and work with data. Moreover, students will learn about tables and charts, work with ranges and range names, formulas, worksheets, print workbooks, and analyze data. By the end of this course, students will be able to work efficiently with Microsoft Excel, create their own spreadsheets and worksheets, modify their columns, rows, cells, charts, and graphics, and use the help feature if they need assistance.

Learning outcomes

• Get familiar with the spreadsheet concept
• Learn to format and work with cells
• Learn to manage workbooks
• Get familiar with cell borders and fill colors
• Learn about text alignment
• Get familiar with number formats
• Learn how to modify columns, rows, and cells
• Learn how to format worksheets
• Learn to work with data
• Get familiar with tables and charts in Excel
• Learn to work with ranges and range names
• Get familiar with formulas
• Learn about worksheets and how to import data
• Learn how to print workbooks
• Get familiar with analyzing data
• Get familiar with graphics
• Learn about collaboration in Excel

Table of contents

Chapter 1: Intro to Course

• 1.1. Welcome!
• 1.2. About TechClass Office Product...
• 1.3. Learning Outcomes
• 1.4. Your Expectations, Goals, and Knowledge
• 1.5. Abbreviations
• 1.6. Copyright Notice

Chapter 2: Introduction to Microsoft Excel

• 2.1. Basic Spreadsheet Concepts
• 2.2. What Is Microsoft Excel?
• 2.3. Microsoft Excel Uses

Chapter 3: Get Started with Excel

• 3.1. Get Started with Excel
• 3.2. Title Bar
• 3.3. Quick Access Toolbar
• 3.4. Ribbon and File Tab
• 3.5. Name Box and Formula Bar
• 3.6. Workbook
• 3.7. Scroll Bar and Status Bar

Chapter 4: Manage Excel Workbooks

• 4.1. Create a New Workbook
• 4.2. Save a Workbook
• 4.3. Open and Close a Workbook
• 4.4. Workbook Views
• 4.5. OneDrive
• 4.6. Share
• 4.7. Export
• 4.8. Quiz

Chapter 5: Work with Cells

• 5.1. Name Cells and Add Comments
• 5.2. Enter and Modify Data
• 5.3. AutoComplete and AutoFill
• 5.4. Selection Techniques
• 5.5. Copy and Move Cells
• 5.6. Undo and Redo
• 5.7. Check Spelling
• 5.8. Find and Replace
• 5.9. Symbols
• 5.10. Quiz

Chapter 6: Format Cells

• 6.1. Computer Fonts
• 6.2. Change Font, Font Size, and Font Color
• 6.3. Bold, Italic, and Underline
• 6.4. Cell Styles
• 6.5. Format Painter

Chapter 7: Cell Borders and Fill Colors

• 7.1. Borders
• 7.2. Draw Borders
• 7.3. More Borders
• 7.4. Fill Colors

Chapter 8: Text Alignment

• 8.1. Horizontal Text Alignment
• 8.2. Vertical Text Alignment
• 8.3. Orientation
• 8.4. Indentation
• 8.5. Wrap Text and Shrink to Fit
• 8.6. Merge and Center
• 8.7. Quiz

Chapter 9: Number Formats

• 9.1. Currency, Date, and Time Format
• 9.2. Percentage Format, Number Group

Chapter 10: Modify Columns, Rows, and Cells

• 10.1 Modify and AutoFit Columns Width
• 10.2. Modify and AutoFit Row Height
• 10.3. Insert Rows, Columns, and Cells
• 10.4. Delete Rows, Columns, Cells, and Clear Contents
• 10.5. Hide Rows, Columns, and Cells
• 10.6. Quiz

Chapter 11: Format Worksheets

• 11.1. Insert and Delete Worksheets
• 11.2. Move and Copy Worksheets
• 11.3. Rename and Change the Tab Color
• 11.4. Group Worksheets

Chapter 12: Work with Data

• 12.1. Freeze Rows and Columns
• 12.2. Split a Worksheet
• 12.3. Sort
• 12.4. Filter
• 12.5. Quiz

Chapter 13: Tables

• 13.1. Format Data as a Table
• 13.2. Modify Table Styles
• 13.3. Remove a Table

Chapter 14: Work with Ranges

• 14.1. Fill a Range with the Same Values
• 14.2. Fill a Range with a Series of Values

Chapter 15: Work with Range Names

• 15.1. Define a Range Name
• 15.2. Use Worksheet Text to Define a Range Name
• 15.3. Navigate a Workbook Using Range Names
• 15.4. Change and Delete a Range Name
• 15.5. Paste a List of Range Names
• 15.6. Background Color and AutoFormat
• 15.7. Quiz

Chapter 16: Formulas

• 16.1. Excel Formulas
• 16.2. Build a Formula
• 16.3. Functions
• 16.4. Add a Function to a Formula
• 16.5. AutoSum
• 16.6. Reference
• 16.7. Move or Copy a Formula
• 16.7. Quiz

Chapter 17: Worksheets

• 17.1. Gridlines, Headings, and Formula Bar
• 17.2. Background
• 17.3. Hide and Unhide a Worksheet
• 17.4. Header and Footer
• 17.5. Theme
• 17.6. Quiz

Chapter 18: Import Data

• 18.1. External Data
• 18.2. Import Data

Chapter 19: Analyze Data

• 19.1. Set Data Validation Rules
• 19.2. Summarize Data
• 19.3. Highlight Cells Rules
• 19.4. Top or Bottom Rules
• 19.5. Analyze Cell Values with Data Bars
• 19.6. Analyze Cell Values with Color Scales
• 19.7. Analyze Cell Values with Icon Sets
• 19.8. Create a Custom Conditional Formatting Rule
• 19.9. Quiz

Chapter 20: Charts

• 20.1. Chart Types
• 20.2. Insert a Chart
• 20.3. Chart Elements
• 20.4. Chart Titles
• 20.5. Data Labels
• 20.6. Chart Legends
• 20.7. Chart Gridlines
• 20.8. Data Table
• 20.9. Chart Layout and Style
• 20.10. Select a Different Chart Type
• 20.11. Change the Chart Source Data
• 20.12. Move and Resize a Chart
• 20.13. Add a Sparkline to a Cell
• 20.14. Quiz

Chapter 21: Graphics

• 21.1. Picture
• 21.2. Shape
• 21.3. SmartArt
• 21.4. 3D Model
• 21.5. Screenshot
• 21.6. WordArt
• 21.7. Move, Resize and Crop a Graphic
• 21.8. Format a Picture
• 21.9. Quiz

Chapter 22: Collaborate

• 22.1. Protect a Worksheet
• 22.2. Enable Track Changes
• 22.3. Track Workbook Changes
• 22.4. Quiz

Chapter 23: Print Workbooks

• 23.1. Margins
• 23.2. Page Orientation
• 23.3. Page Break
• 23.4. Paper Size
• 23.5. Print Area
• 23.6. Print Titles
• 23.7. Preview and Print
• 23.8. Quiz

Chapter 24: Excel Help

• 24.1. Help
• 24.2. Contact Support
• 24.3. Feedback
• 24.4. Show Training

Chapter 25: Final Tasks

• Final Project

Brochure