Become Professional In Microsoft Excel - Ideal For Beginners

Published 1/2023MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 206.16 MB | Duration: 0h 33m

Get proficient in Excel formulas and charts starting from 0.

What you'll learn

Learn the basics of how Excel is being built and works.

Learn how to create and save Excel workbooks.

Learn how to apply Excel formulas with practical examples.

Learn how to create basic diagrams to visualise data.

Learn how to format cells.

Requirements

No experience needed. This course is for bners.

Description

This course is aimed for absolute bners in Microsoft Excel. You need zero prior knowledge about Excel.In this course you will learn the basics about Excel and will be equipped with hands on skills to successfully work with data, delivered in a quick and actionable manner.You will be perfectly capable to start at any data entry junior position at financial firms and in general businesses because you will know the basics of Excel.It is ideal for those who need knowledge about Excel for either their studies or their work.The content of this course starts with a general overview of how to install it. We will also cover how you can create and save worksheets and briefly outline the basic building blocks of the Excel interface.Other important topics outlined in this course are formatting and how you can style worksheets in order to create professionally looking deliverables and outshine your competition.The main focus of this course is purposely being on Excel formulas. You will learn the basic and most important formulas and each formula is being delivered by a real life working example which you can adapt and transform for your own work requirements.To wrap up the course, there will also be focus on the three important charts, namely pie, line and column charts. You will learn in what situations these charts can be best applied and each chart type is being explained by one illustrative example.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Overview of Excel

Lecture 3 Let's have a look at how you can install Excel on your computer

Section 2: Excel Basics

Lecture 4 Excel program interface

Lecture 5 Create a workbook in Excel

Section 3: Excel data entry

Lecture 6 Excel data entry

Section 4: Excel formulas

Lecture 7 Excel formulas - basic & advanced