Learn Excel (basic, formulas and charts corporate work)- The Basics

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

In this Microsoft Excel training, you will learn how to navigate and manipulate worksheets and workbooks. With formulas, functions, and names. Design a pivot table with charts, slicers, and filters.
Formulas will start from basic functions as count till nesting formulas as an index. At the end of the training each attendee will understand the importance of excel and why it’s the most used tool in the accounting and how to use it.
Improved data management using Excel. Excel makes it possible to efficiently store and manage large sets of data so you can track, sort, and filter to find just the information you need at any time. Excel, like other spreadsheets, uses a grid-based structure to hold data within cells. You can use the data to create tables and categorize information within rows or columns, making it easier to maintain and update. Whether managing a list of names and addresses an inventory of products and parts, or tracking who is working on which parts of a project, Excel helps to organize your information
Perform better data analysis with Excel. With built-in formulas, functions, and pivot tables, Excel makes it possible to perform calculations and gain insights from data that has been well organized.

Show More

What Will You Learn?

  • Excel syntax, basic, shortcuts etc
  • Basic statistical functions
  • Xlookup/Reference function
  • Text/Date & Time Formulas
  • Pivot table and Chart introductio

Course Content

Introduction

  • Introduction to Excel
    00:00

Basic statistical functions and some formulas

More formulas and filters

Xlookup

Pivot Table and chart

Student Ratings & Reviews

No Review Yet
No Review Yet