Microsoft Excel is an invaluable spreadsheet program for organizing, analyzing, and representing data. Excel offers various functions, formulas, and pivot tables for aggregating and analyzing large sets of information. Many companies and organizations rely on Excel for a wide range of analysis purposes. In this course, students develop basic and advanced Excel skills. By the end of this course, students will have mastered the most popular Excel tools and become confident to complete any Excel tasks, including designing sophisticated spreadsheets and performing complex calculations and analyses.
Learning outcomes
- Build a solid understanding of the basics of Microsoft Excel
- Master the advanced features of Microsoft Excel
- Maintain large sets of Excel data in a list or table
- Learn how to use and format Excel cells and manage workbooks
- Learn how to present information using different types of charts and visualizations
- Learn the most common Excel functions used in the Office
- Master the essential Excel formulas such as IF, VLOOKUP, INDEX, MATCH functions, and many more
- Learn different techniques of data management such as sorting, filtering, consolidating, etc.
- Learn to use various elements such as charts and objects to create interactive Excel reports
- Learn how to print, export, and present your results
Table of contents
Basic
Chapter 1: Introduction
Chapter 2: Get to Know the Excel Environment
Chapter 3: Manage Excel Workbooks
Chapter 4: Work with Cells
Chapter 5: Format Cells
Chapter 6: Cell Borders and Fill Colors
Chapter 7: Text Alignment
Chapter 8: Number Formats
Chapter 9: Modify Columns, Rows, and Cells
Chapter 10: Format Worksheets
Chapter 11: Work with Data
Chapter 12: Tables
Chapter 13: Charts Basics
Chapter 14: Get Help
Chapter 15: Final Tasks
Advanced
Chapter 1: Introduction
Chapter 2: Work with Ranges
Chapter 3: Work with Range Names
Chapter 4: Format Excel Ranges
Chapter 5: Formulas
Chapter 6: Worksheets
Chapter 7: Import Data
Chapter 8: Print Workbooks
Chapter 9: Analyze Data
Chapter 10: Charts
Chapter 11: Add Graphics
Chapter 12: Collaborate with Others
Chapter 13: Final Tasks
Brochure