Introduction to Excel
What you’ll learn
Ms Excel
Basics of Excel
Conditional Formatting and Cell Referencing
Excel Formulas/Calculations, data consolidation and V lookup
Requirements
This course is good for anyone who wants to learn Excel from scratch!
Description
MS-Excel contains more functions and features than any other spreadsheet software. It’s capable of handling larger spreadsheets. At a basic level, it is used for storing information, analyzing and sorting, and reporting. It’s extremely popular in business because spreadsheets are highly visual and fairly easy to use.Some of the most common business uses of MS Excel are for business analysis, managing human resources, performance reporting, and operations management.Why this Course?This course will help you in building your excel skills from scratch. It will foster your fundamental knowledge for Excel that will help you in core managerial functions. This course will help you in digitization and easy maintenance of your data that will ultimately build your overall working efficiency and command. This course will explain each and every basic features and facility of excel that will help you in understanding this software logically. Excel helps us in making our routines processes simple and convenient. This course will include18 Modules.Practice Excel Sheets.In simplified language for easy understandability.Functions where Excel can help you?Attendance ManagementPayroll ProcessingProject ManagementAccountsChartingFinancial PlanningMIS reportsAssignmentsData BaseCRMPhone Book.Who is your Trainer?Trainer for this course in Mr. Sambhav Jain. He is an Excel expert and an IIT Mumbai Alumni and currently working as a Management Consultant. He is also a co-founder of channel Labour Law Advisor. He is also an Active Investment Consultant.
Overview
Section 1: Introduction
Lecture 1 Lecture 1 : Introduction
Lecture 2 Lecture 2 : Text editing
Lecture 3 Lecture 3 : Sheet Formatting
Lecture 4 Lecture 4 : Condition Formatting
Lecture 5 Lecture 5 : Sort & Filter
Lecture 6 Lecture 6 : Basic Calculations
Lecture 7 Lecture 7 : Cell Referencing
Lecture 8 Lecture 8 : Logical Reasoning
Lecture 9 Lecture 9 : Logical statements
Lecture 10 Lecture 10 : Calculations
Lecture 11 Lecture 11 : Data visualization & summarization
Lecture 12 Lecture 12 : Data visualization & summarization (Detailed analysis)
Lecture 13 Lecture 13 : Data summarization (Detailed analysis)
Lecture 14 Lecture 14 : Pivot tables (Detailed analysis)
Lecture 15 Lecture 15: Data Consolidation
Lecture 16 Lecture 16 : Data consolidation Part 2
Lecture 17 Lecture 17 : Data consolidation Part 3
Lecture 18 Lecture 18 : V Lookup
Students,Beginners in Business,Beginners in Professional Field
Course Information:
Udemy | English | 3h 44m | 2.84 GB
Created by: LLA Professional Training Institute
You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com