Microsoft Excel - From Basic To Moderate Level

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

Homepage

https://www.udemy.com/course/microsoft-excel-from-basic-to-moderate-level/