Microsoft Excel - Beginner to Advanced

Microsoft Excel - Beginner to Advanced

Duration of the course : 7hr 52min (LIFE TIME UPDATED VIDEOS / LIFE TIME ACCESS)

Language : English

Course Title : Microsoft Excel – Beginner to Advanced

What will students learn in your course?

· Microsoft Excel – Startup

· Microsoft Excel – Editing Tools

· Microsoft Excel – Speak cells, Comments and Fill series

· Microsoft Excel – Working with sheets

· Microsoft Word – Dropdown list – Short functions

· Microsoft Excel – Data Validation Microsoft Excel – Working with objects and dynamic data

· Microsoft Excel – Age Calculator - Bar Code-Charts

· Microsoft Excel – Basics formulas, Auditing tools

· Microsoft Excel – Student mark sheet – lookups

· Microsoft Excel – Advanced tools

· Microsoft Excel – Office tools

· Microsoft Excel – Advanced

ABOUT THE COURSE

The specialization course on Microsoft Excel covers step-by-step instructions starting from Fundamentals to Advanced including Basic Concepts, Filling, Logical Functions, Lookups to advanced lookups. Data Validations, Macros, Conditional Formatting, MIS Reports, Dashboards, Charts, Pivot Table, Protection, Printing Configuration, Sort & Filters, Data Imports, VBA Basics and much more.

A Compulsion Course for Accounting, Financial, MIS, Data Analysis, MNC Employees, Students, Teachers, Tax Professional, Auditors & Business Management Sectors.

The course is enriched with numerous real-life business scenarios, charts, screenshots, observations and solved illustrations on Microsoft Excel. The professional course is structured in a blended format which gives you a flexibility to learn at your own pace while getting help from experts.

Hey, does your job or business involve working with data?

are you looking to improve your Microsoft excel skills?

Do you want make your day to day work simpler than ever?

If it yes, then let me tell you a secret formula which will instantly accelerate your career growth.

All you have to do is enroll this Microsoft Excel Beginner to advanced level course.

No matter which industry you belong To, you need this excel skills to

Save hours of time, getting better jobs, getting better promotions

What are you waiting for, join me to become Pro-User?

Module 1: Microsoft Excel (Beginner to Advanced)

1.1 Microsoft Excel – Startup

In this section students will learn basics of excel in very simple methods, its provide complete guidance on launching excel, saving a document, tabs, groups, sheets, columns, rows, cells and some basics formulas that are used commonly.

· Introduction to Microsoft Excel-Course-English

· How to Open Close Save Excel Applications

· How to Open and Close MS Excel, what is Menus, Tools, Sheets, Columns, Rows & Cells

· Excel Commonly Used Formulas I Sum I Subtraction I Avg I Percentage I Multiplication I ………..Product I Division & more

· Learn How to Create Tabs, Groups and add Toll to it in MS Excel

1.2 Microsoft Excel – Editing Tools

In this section learner will understand text writing, text editing, text design, text format, cell text alignment and characteristics of cell.

· Excel – Editing Data I over writing I editing I find & replace I undo & redo I Go to

· MS Excel – Home Tab – Group Clip Board Explained – Copy, Cut, Paste, Copy as Picture, Format Painter, Past Special

· MS Excel – Home Tab – Font Group Explained – Font Size, Font Face Style, Bold Italic, Underline, Borders, Fill color

· Home Tab – Alignment Group Explained – Merge, Wrap Text, Alignments & more

· MS Excel – Characteristics of Cell

1.3 Microsoft Excel – Speak cells, Comments and Fill series

This section helps students to understand how to enable speak cells & stop speaking cells, what is comment, what is the use of it, how to edit it, how to fill data automatically with the help of flash fill tools.

· Speak Cells – on Enter, by Rows, By Columns, Stop Speaking Cells I Microsoft Excel

· MS Excel – Text to Columns

· MS Excel – Comments – add, edit, delete & Show all

· MS Excel – Fill Series – with formatting, without formatting & more

· Fill Series – Advance Fill – Numbers, Months, Days, Custom List Edit & Add, Fill Down, Right & more

· Fill Series – Flash Fill

1.4 Microsoft Excel – Working with sheets

This chapter helps user to work with multiple sheets at a time, to compare sheet horizontally, vertically, protection of sheet or cells, hide and unhide rows and columns and many more.

· MS Excel – How to Hide and Unhide Rows, Columns, Sheets

· Freeze Panes – Top Row, Columns & Multiple Rows & Columns

· MS Excel – Filters – Learn How to Use Filter to analysis a Big Data

· MS Excel – Split Sheet Window

· MS Excel – How to Insert & Delete Cells, Rows, Columns

· MS Excel – Working with Sheets

· MS Excel – View Sheets Side by Side from One Excel File

· MS Excel – Workbook Protection – Learn how to setup a Password to open Excel File

· MS Excel – Sheet & Cells Protection

1.5 Microsoft Word – Dropdown list – Short functions

This section guide learners on how to create and remove dropdown lists, how to manage names, join multiple cells, trim, print, Date formulas. It also guides user on creating hyperlinks in excel, page printing design tools like page headers, footers, logo and many more.

· MS Excel – Create & Remove Drop Down List

· Concatenate – Join Multiple Text Strings into ONE

· MS Excel – Trim Functions – Remove unnecessary Elements from strings

· MS Excel – Print Formulas Left, Right, Middle

· MS Excel – Date Related Formulas

· MS Excel – Hyper Links – Cell to Sheet, Website, Existing File, Create New Documents

· MS Excel – Print, Page Setup, Margins, Size, Excel to PDF

· MS Excel – Page Header & Footer I Add Page Numbers, Logo, Report Name, Date, Time & ----------------more

1.6 Microsoft Excel – Data Validation

In this chapter faculty teaches students what is data validation, how important it is, how to apply different types of data validation, how to enable error or input message boxes, how to apply dependent and independent dropdown lists in Microsoft excel application.

· MS Excel – Conditional Formatting

· Introduction to Data Validation – Time limitation

· Data Validation – Restrict Cells, Input & Error Message, Drop Down List, Date & more

· Data Validation – Part 2 – Circle Invalid data, Error, Stop, Warning, Info Messages Settings

· MS Excel – Data Validation – Dependent – Multiple Drop-Down Lists

1.7 Microsoft Excel – Working with objects and dynamic data

This chapter will give complete knowledge to the students on objects, how to insert live data from web sources. Chapter also helps user understand how to format multiple sheets a at time, how to calculate multiple sheets at time and many more.

· MS Excel – Import Data from Web

· MS Excel – Import Data from Text Document – with Auto Refresh

· MS Excel – Import – Text, Word, PPT, Jpeg, Video, PDF & More Objects

· MS Excel – Format Multiple Sheets at a time

· MS Excel – 3d Sum

· MS Excel – Consolidate (3d Sum extension)

1.8 Microsoft Excel – Age Calculator - Bar Code-Charts

In this section students will understand how to prepare age calculator, bar code generation, with charts-charts included line charts, bar charts, pie charts and many more.

· MS Excel – Age Calculator in Multiple Ways – Exclusive formula

· MS Excel – Bar Code I Install Bar code font I Generate Bar Codes

· MS Excel – Charts – Pie Charts – Create & Customize

· MS Excel – Charts – Columnar Charts

1.9 Microsoft Excel – Basics formulas, Auditing tools

Hello learners, in this section faculty guides you on some basics formulas like logical functions, if, and, not , iferror, Auditing tools,

· Logical Functions – Logical Test I Boolean Expression I TRUE or FALSE I Comparative Operators

· Logical Test – IF Function

· Logical Functions – Nested IF – Learn How to work with Nested if Formula

· Logical Functions – AND function

· Logical Function – Not & IFERROR

· Show Formula, Trace Dependents, Trace Precedents, Evaluate Formula, Formula Text

· Statistical Formulas – Sum, Sum if, Sumifs, Count, Countif, Countifs, Avg, Avgif, Avgifs

· Formulas – sum product, mround, floor, ceiling

1.10 Microsoft Excel – Student mark sheet – lookups-

Dear Students, in this section we are going cover most powerful formulas of excel like v lookup basics to advanced, h lookup basics to advanced lookups, and x lookups, how to prepare student marksheet preparation.

· Student Mark Sheet Calculation – Sum, Average, Rank, Grade, Pass-Fail, Status

· VLOOKUP – Formula, Functionality, Rules, Approximate & Exact Match & more

· VLOOKUP – Introduction

· HLOOKUP– Formula, Functionality, Rules, Approximate & Exact Match & more

· Download, Add & use X Lookup New Formula in MS Excel

· X Lookup – Introduction

· X Lookup New Formula in MS Excel

1.11 Microsoft Excel – Advanced tools

Hello everyone, in this section we are going discuss some of the important topics like index, match, pivot table, EMI Calculation, create and maintain registers.

· Index Formula – Find a Position of the Value, and Call cells references

· Match Formula – Find Position of the Value

· Pivot Table Introduction & Basics of Pivot Table

· Create a PivotChart from Table & Pivot Table

· Pivot Table – Use slicers to filter data

· Pivot Table, Charts, Progress Dashboard

· MS Excel Calculate EMI I Prepare Loan Statement I Principal I Interest

· Working with Tables

· Create & Maintain Registers – Using Group Sheets, Drop Down Lists, Data Validation, 3D Sum, -----------Name Ranges

1.12 Microsoft Excel – Office tools

In this section you are going to learn some of the office tools like sharing a document, commission calculation, attendance sheets preparation, salary sheet preparation and many more.

· Share a workbook with Co Authors, Employees or with Anyone

· MS Excel – Copy Cells, Move Cells

· Commission Calculation in MS Excel

· Attendance Sheet Preparation in MS Excel

· Attendance Sheet Extension – Salary Calculation with CA, DA, Commission, Advance Salary, -------------PF & ESI

· Creating Professional Invoice in Excel

· Excel to SMS Free

· VBA & Macro Introduction

· MS Excel – Enabling Developer Tab

· Basics of Macros – Record & Run1

· Saving Macros

· MS Excel – VBA Coding – Display Message BOX

Learn by doing in small, easy to understand I Excel with this A-Z MS Excel Course. Microsoft Excel 2010, 2013, 2019

Url: View Details

What you will learn

• Microsoft Excel Basics, Advanced & Pro
• An Introduction to Microsoft Excel
• How to Open MS Excel, What is Menus, Tools, Sheets, Columns, Rows & Cells

Rating: 4.3

Level: All Levels

Duration: 7.5 hours

Instructor: Urs Ravi I Vedanta Educational Academy