Course Includes
-
Recorded Lessons: 93
-
Recorded Hours: 5
-
Duration:
5 days (Avg)
Course Features
Access on mobile
TDP Assessment Test-
3 Jobs Available
Top Skills Covered
Overview
Course Description
Excel online course on Teacherdada | Excel 2016 essential training
Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Sam Parulekar. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.
This is a very easy-to-learn course as it is taught in a simple step-by-step manner.
Example files have been provided for practice.
What is this course about?
By the end of this course, you would be able to comfortably work in excel, do data analysis, and be able to present your data in a presentable format.
Background or Experience requirements.
This course does not expect any previous background of Excel. It starts from scratch and makes you comfortable with Excel.
Who this course is for?
This course is ideal for Data Entry Operators, MIS Executives, MIS Analysts, Data Analysts, Business Analysts any person who wants to enter and maintain his data.
- Ideal for Students, Home Makers, and Teachers as well.
- Contains advanced options like Introduction to Macros and Mail merge as well.
How can this online course help you?
- This course can help you to organize data and perform financial analysis.
- It can be used across all business functions and at companies from small to large.
The main areas where this course can help you would include:
- Data entry
- Data management
- Accounting
- Financial analysis
- Charting and graphing
- Introduction to programming
- Time management
- Task management
- Financial modeling
- Customer relationship management (CRM)
- Almost anything that needs to be organized!
Why is it Important to Learn excel? (4 reasons to know)
Excel is a spreadsheet that functions similarly to a database. It is made up of separate cells that may be used to create calculations, tables, graphs, and functions that make it simple to organize and analyze massive amounts of data.
Your information is arranged in Excel's rows, which are represented by numbers, and columns, which are represented by letters. With this format, you may present copious amounts of facts and information in a clear and understandable way. In the business world, Microsoft Excel is the most popular piece of software.
Almost all professions use Excel on a regular basis, whether they are entrepreneurs, business analysts, scientists, bankers, or accountants.
Top 4 reason why learning excel is essential
Excel can help you in many task
Perhaps you used Excel in school to enter a few number tables or combine two cells. Excel, however, is a lot more intricate than that. Did you know that the application can perform all of the following, for instance:
- Organize data in a user-friendly manner.
- Perform both simple and advanced mathematical operations so that you won't have to.
- Convert data sets into useful graphs and charts.
- Make forecasting predictions based on data analysis
Excel facilitates task completion.
Excel's abundance of tools and functions are made to save you time in addition to organizing data. For instance, Excel performs the arithmetic for you so that you don't have to manually add up columns for task. You can trust Excel's calculations.
Its improve you job pay
Did you know that having a knowledge of Excel can immediately improve both your career prospects and your starting pay? Any hiring manager is aware of how important Excel is as a transferable ability. It gives you options, which is one of the benefits of learning such an ubiquitous computer programme.
Excel will improve your Career - Because it used everywhere
In addition to investment bankers and accountants, Excel is used by a wide range of other professionals, including scientists, instructors, business owners, and graphic artists.
It just requires figuring out how Excel may assist you in doing your job more effectively, regardless of what you do in the office.
With this excel online course you will be master in using excel. So don't wait register today for getting this Excel Coursr online.
What you'll learn
- Excel Introduction
- Understanding the Excel Interface
- Goal Seek
- Scenario Manager
- Data Table
- Autofill Series and Flash Fill
- Data Validation
- Pivot Tables
- Mail Merging with Excel Data
Requirements
- Basic Computer Fundamentals and Terminologies
- A Computer with Windows or MAC OS and Excel 2016 installed
- Minimum 8 GB RAM
- Internet Connection
Course Content
51 Lessons | 42 Downloadable material | 5:00 Total hours
Introduction
-
WIIFM - What's in it for me? 00:02:10
Getting Started with Excel
-
Understanding the Excel Interface 00:05:12
-
Understanding the Menu System 00:06:23
-
Understanding the Quick Access Toolbar 00:04:58
-
Understanding Workbooks and Worksheets 00:07:35
Understanding the Formula Bar
-
Understanding the Formula Bar 00:04:28
-
Excel Practice file for Understanding the Formula Bar
Understanding the Status Bar
-
Understanding the Status Bar 00:04:37
-
Excel Practice file Understanding the Status Bar
Understanding the Navigation System of Excel
-
Understanding the Navigation System of Excel 00:03:17
-
Excel Practice file Understanding the Navigation System of Excel
Using shortcut menus and the Mini toolbar
-
Using shortcut menus and the Mini toolbar 00:04:34
-
Excel Practice file for Using shortcut menus and the Mini toolbar
Creating new workbooks
-
Creating new workbooks 00:03:20
Using Excel Help
-
Using Excel Help 00:03:36
Entering Data
-
Exploring Data Entry and Editing Techniques 00:05:30
-
Entering Data with Autofill 00:03:14
Understanding Undo and Redo
-
Understanding Undo and Redo 00:06:18
-
Excel Practice file for Understanding Undo and Redo
Adding Comments
-
Adding Comments 00:04:41
Using Save and Save As
-
Using Save and Save As 00:03:57
Creating Simple Formulas
-
Creating Simple Formulas 00:08:01
-
Excel sample file for Creating Simple Formulas
Copying Formulas to Adjacent Cells
-
Copying Formulas to Adjacent Cells 00:04:31
-
Excel Sample file for Copying Formulas to Adjacent Cells
Calculating Year to Date Totals
-
Calculating Year to Date Totals 00:04:36
-
Excel practice file for Calculating Year to Date Totals
Calculating Percentage
-
Calculating Percentage 00:06:41
-
Excel practice file for Calculating Percentage
Working with Relative, Absolute and Mixed Referencing
-
Working with Relative, Absolute and Mixed Referencing 00:06:40
-
Excel Practice File for Working with Relative, Absolute and Mixed Referencing
Using Sum and Average
-
Using Sum and Average 00:07:23
-
Excel practice file for Using Sum and Average
Using other common functions
-
Using other common functions 00:07:36
-
Excel Practice File for Using other common functions
Exploring Font Styles and Effects
-
Exploring Font Styles and Effects 00:05:08
-
Excel practice file for Exploring Font Styles and Effects
Adjusting Row Heights and Column Widths
-
Adjusting Row Heights and Column Widths 00:06:33
-
Excel practice files for Adjusting Row Heights and Column Widths
Working with alignment and Wrap Text
-
Working with alignment and Wrap Text 00:05:48
-
Excel Practice files for Working with alignment and Wrap Text
Working with Borders
-
Working with Borders 00:05:30
-
Excel Practice files for Working with Borders
Formatting numbers and dates
-
Formatting numbers and dates 00:09:37
-
Excel practice files for Formatting numbers and dates
Using conditional formatting
-
Using conditional formatting 00:08:43
-
Excel Practice files for Using conditional formatting
Creating and using tables
-
Excel practice files for Creating and using tables
-
Excel practice files for Creating and using tables
Understanding Data Validation
-
Understanding Data Validation 00:11:18
-
Excel practice file for Understanding Data Validation
Understanding Text to Columns
-
Understanding Text to Columns 00:07:45
-
Excel practice files for Understanding Text to Columns
Financial Function PMT
-
Financial Function PMT 00:03:36
-
Excel Practice file for Financial Function PMT
Data Table
-
Data Table 00:04:16
-
Data Table
Scenario Manager
-
Scenario Manager 00:06:16
-
Scenario Manager
Goal Seek
-
Goal Seek 00:03:15
-
Excel Example file for Goal Seek
Autofill Series
-
Autofill Series 00:02:21
Flash Fill Data
-
Flash Fill Data 00:05:09
-
Excel sample file for Flash Fill Data
Searching Data using VLOOKUP (Exact)
-
Searching Data using VLOOKUP (Exact) 00:08:29
-
Excel example file for Searching Data using VLOOKUP (Exact)
Searching Data using HLOOKUP (Exact)
-
Searching Data using HLOOKUP (Exact) 00:03:00
-
Excel example file for Searching Data using HLOOKUP (Exact)
Searching Data using VLOOKUP (Approximate)
-
Searching Data using VLOOKUP (Approximate) 00:06:39
-
Excel example file for Searching Data using VLOOKUP (Approximate)
Organizing Data using Data Sort
-
Organizing Data using Data Sort 00:08:18
-
Excel example file for Organizing Data using Data Sort
Data Subtotal
-
Data Subtotal 00:05:16
-
Excel example file for Data Subtotal
Filtering Data using Data Filter
-
Filtering Data using Data Filter 00:09:56
-
Excel example for Filtering Data using Data Filter
Understanding the data and creating Branch wise Pivot
-
Understanding the data and creating Branch wise Pivot 00:06:50
-
Excel example file for Understanding the data and creating Branch wise Pivot
Creating a Branch wise and opened by Pivot
-
Creating a Branch wise and opened by Pivot 00:04:04
-
Excel example file for Creating a Branch wise and opened by Pivot
Creating a Date wise Pivot
-
Creating a Date wise Pivot 00:02:51
-
Excel example file for Creating a Date wise Pivot
Creating a Count of Account Types Pivot
-
Creating a Count of Account Types Pivot 00:02:30
-
Excel example file for Creating a Count of Account Types Pivot
Creating a Bucketing Pivot
-
Creating a Bucketing Pivot 00:04:04
-
Excel example file for Creating a Bucketing Pivot
Creating a Conditional Formatting Pivot
-
Creating a Conditional Formatting Pivot 00:03:08
-
Excel example file for Creating a Conditional Formatting Pivot
Creating a Graph out of Pivot Data
-
Creating a Graph out of Pivot Data 00:05:35
-
Excel example file for Creating a Graph out of Pivot Data
Merging Excel Data with Word Document
-
Merging Excel Data with Word Document 00:05:02
-
Sample Word file for Mail Merge
-
Sample Excel file for Mail Merge
Frequently asked questions
What topics are covered in the Excel 2016 Essential Training course?
The course covers a wide range of topics, including the Excel interface, basic functions and formulas, data formatting, chart creation, pivot tables, data analysis tools, and printing options.
Is this course suitable for beginners?
Yes, this course is ideal for beginners. It starts with the basics of Excel 2016 and gradually progresses to more advanced topics, ensuring that learners of all levels can benefit from the training.
How long is the course?
The course typically consists of several modules, totaling approximately 4-5 hours of instructional content. Students can progress through the material at their own pace.
Are there any prerequisites for enrolling in the course?
There are no formal prerequisites for this course. However, a basic understanding of computer operations and familiarity with using a mouse and keyboard will be beneficial.
Can I take the course on my mobile device?
Yes, the course is often designed to be mobile-friendly, allowing you to access the materials on tablets and smartphones. However, a larger screen may enhance your learning experience.
