Microsoft Excel - From Basic To Moderate Level

Master The Microsoft Excel In Easy To Follow Step-By-Step Training Course With Extensive Working Files

What you'll learn

Learn the most common Excel functions used in the Office

Maintain large sets of Excel data in a list or table

Unlocking dynamic formulas with VLOOKUP functions and many more

Build a solid understanding on the Basics of Microsoft Excel

Create dynamic reports by mastering one of the most popular tools, PivotTables

Requirements

No Prior Excel Knowledge Required

Microsoft Excel 2007, 2010, 2013, 2013, 2019,2020,2021 and 2022 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures

Description

A Verifiable Certificate of Completion is presented to all students who undertake this Excel Training course.In this Microsoft Excel training course, expert training provider takes you through the basics of the worlds most popular spreadsheet software. Excel can be a complex and confusing program to use, but this course breaks it down into bite-sized pieces and teaches it in plain English. No prior experience in Excel or spreadsheets is required to get the most out of this Excel training.You will start with the absolute basics, creating and saving a new workbook. The course proceeds step by step through the process of entering data in cells, doing basic math, formatting your worksheets, setting up pages for printing and applying basic mathematical formulas. Once you are comfortable with the basics, you will move on to more advance formatting with themes, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas, and applying conditional formatting to your worksheet.By the time you have completed this video training course for Microsoft Excel, you will be comfortable with day to day operations that you would perform in this software program. You will be able to perform calculations, and create professional graphs and charts from your data. Working files are included to allow you to follow along using the same source material that the author uses throughout the lessons in this computer based training Course.

Overview

Section 1: Introduction

Lecture 1 Introduction To Microsoft Excel and The Interface

Lecture 2 Introduction To Microsoft Excel and The Interface Lectre - 01

Lecture 3 Data Creation

Lecture 4 Data Creation - 01

Lecture 5 Data Creation - 02

Lecture 6 Using Of Data Filters

Lecture 7 Cells, Columns and Rows Managment

Lecture 8 Text Management and Formats

Lecture 9 Conditional Formatting

Lecture 10 Data Styling

Lecture 11 Tab Management

Lecture 12 Basic Mathemetical formulas

Lecture 13 Ilustrations

Lecture 14 Charts

Lecture 15 Add In's

Lecture 16 Text To Columns and Data Validation

Lecture 17 Freeze

Lecture 18 Vlookup

Lecture 19 Vlookup - 01

Lecture 20 Pivot Tables

Lecture 21 Pivot Tables

Lecture 22 Reference Sheets

Lecture 23 Reference Sheets - 01

Lecture 24 Data Comparision

Section 2: Project

Lecture 25 Project Scope

Lecture 26 Project Scope - 01

Lecture 27 Project - 01

Lecture 28 Project - 02

Lecture 29 Project - 03

Lecture 30 Project - 04

Lecture 31 Project - 05

If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.,Working Professionals,Students