Microsoft Excel Online Course (5 credits)


Price:
Sale price€99.75

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

Payment & Security

Payment methods

American Express Apple Pay Mastercard PayPal Visa

Your payment information is processed securely. We do not store credit card details nor have access to your credit card information.


Security

Customer Reviews

No reviews yet
0%
(0)
0%
(0)
0%
(0)
0%
(0)
0%
(0)

You may also like

Recently viewed