Loading

62.5% OFF

MS Excel 2016- Basic to Advanced

  • Overview
  • Curriculum
  • Instructor
  • Reviews

MS Excel 2016- Basic to Advanced

Course Description

Microsoft Excel is the industry-standard spreadsheet program used for data calculations, analysis, visualization, and much more. It can be programmed to access data from external databases and is an excellent tool for data modeling, statistics, and financial calculations with built-in functions to quickly and easily perform common tasks. Proficiency in Excel is typically required for accounting, business analytics, and data analysis, and statistics jobs.

Our Excel tutorials are designed to help you use Excel to analyze data on any level. Whether you're just learning how to create spreadsheets or need to perform advanced data analysis with functions, formulas, and charts, these courses will help you unlock the maximum potential of this popular data-analysis program.

Course Highlights

  • How to be a better, faster, stronger Excel user

  • How to save yourself hours of time and boost your productivity in Excel

  • How to navigate the Excel interface

  • How to use math, statistical, logic, and text functions

  • How to find a value with VLOOKUP, HLOOKUP, INDEX, MATCH

  • How to sort and filter your data to find exactly what you are looking for

  • How to work with charts to present clear insights from your data

  • How to create and format Pivot Tables

  • How to record a basic Macro to automate repetitive tasks

  • How to use data validation to restrict data entry

  • How to customize your page setup options for printing

  • How to impress your boss and colleagues with your super-sharp Excel skills

You Will Get

  • 64 HD Videos

  • 4+ Hour of Content

  • Well precise notes

  • Course Completion Certificates

  • Practice Files

Why Get Certified?

  • Multiple Career Opportunities for certified candidates

  • Career Progression and Management

  • Industry Preferred Certificate

After successful completion of the course, students will get a "Certificate of Completion"

Intended Participants

  • Anyone using or planning to use calculators or other calculating devices

  • Graduate or Post Graduate Students from any streams

  • Working Professionals from any department especially Finance, HR, Marketing, Operations, Supply Chain

  • Business people or self-employed professionals especially CAs, Consultants, or any other stream where data is inevitable

Why Happy Learnings?

Happy Learnings is the fastest growing online education marketplace on the internet to learn accounts, business, software, technology, and creative skills to achieve personal and professional goals. We partner with companies and individuals to address their unique needs, providing training and coaching that helps working professionals achieve their career goals. In addition to helping individual learners achieve their goals, we offer flexible, cost-effective group memberships for your business, school, or government organization.

MS Excel Basic-Contents
Launching Microsoft Excel
2 min Preview
Excel Startup Screen
2 min Preview
Introduction to MS Excel
3 min Preview
Customizing Quick Access Toolbar
3 min
Microsoft on Excel Interface
3 min
Structure of an Excel Workbook
5 min
How to Save and Save As
5 min
Common Excel Shortcuts
5 min
Entering Text into MS Excel
4 min
Font Groups in MS Excel
4 min
Paragraph Options in MS Excel
6 min
Number_Currency_Date Formats
11 min
Clear Options in MS Excel
5 min
Creating Basic formulas in MS Excel
4 min
Copying formulas in MS Excel
4 min
Using Autofill in MS Excel
5 min
Basic Functions in MS Excel
9 min
Adjacent Cells error in MS Excel
3 min
Inserting & Deleting Rows and Columns
2 min
Inserting Images and Shapes
6 min
Screenshot and Screen Clipping
2 min
Insert Text box and Word Art
2 min
Excel Templates
4 min
Adding Header and Footer
4 min
Printing Excel Sheets
4 min
MS Excel Advanced-Contents
Understanding Excel List Structure
5 min Preview
Sorting a List Using Single Level Sort
3 min Preview
Using Custom Sorts In An Excel List
5 min
Auto Filter Tool in MS Excel
9 min
Multilevel Sorting In MS Excel
5 min
Sort Left To Right In MS Excel
5 min
Case Sensitive Sorting
3 min
Conditional Formatting- Introduction
2 min
Highlight Cell Rules
11 min
Manage Rules
4 min
Top or Bottom Rules
4 min
Data Bars In Conditional Formatting
6 min
Color Scale In Conditional Formatting
5 min
Icon Set In Conditional Formatting
5 min
Sort Cell Color- Icon Set- Font Color
6 min
Trace Precedents in Excel
5 min
Trace Dependents in Excel
3 min
Show Formulas in Excel
2 min
Name and Name Manager in Excel
6 min
How to Remove Duplicate Values in MS Excel
3 min
What is Pivot Table in Excel?
5 min
Different Formulas in Pivot Table
3 min
Multiple Fields in Pivot Table
4 min
Filters & Data Updations in Pivot Table
6 min
Percentage Calculations in Pivot Table
6 min
Number formats in Pivot Table
2 min
Monthly-Quarterly-Yearly Reports in Pivot
5 min
Subtotals in Pivot
2 min
Pivot Charts in Excel
3 min
Secondary Axis in Pivot Chart
5 min
Merge Datas in MS Excel
3 min
Text to Columns in MS Excel
7 min
Get External Data into Excel
4 min
Import Data from Website
3 min
Freeze Pane in MS Excel
3 min
Inspect a Workbook
2 min
Errors in MS Excel
7 min
Data Validation Part 1
5 min
Data validation -Part 2
5 min
logical function IF Part 1
5 min
Logical Functions IF Part 2
2 min
Multiple IF Conditions Part 1
4 min
Multiple IF Conditions Part 2
6 min
Tax Calculation Using IF Conditions
3 min
Sub totals & Grand Totals
5 min
Macro Programming Part-1
4 min
Macro Programming Part-2
4 min
Macro Programming Part-3
4 min
Macro Programming Part-4
6 min
Macro ProgrammingPart-5
3 min
V-Lookup & H-Lookup
8 min
Vertical Lookup -Cont..
6 min
Vertical Lookup -Cont..
5 min
Horizontal Lookup -Part-1
4 min
Horizontal Lookup -Part-2
3 min
MS Excel 2016- Basic to Advanced-Notes
Complete Notes
No Preview
MS Excel 2016-Complete Work File
Work Files
No Preview
instructor

Happy Learnings

4.7 Instructor Rating

HappyLearnings.com is one of the world’s leading certification training providers. We partner with companies and individuals to address their unique needs, providing training and coaching that helps working professionals achieve their career goals.

Course Rating

5.00 average based on 4 rating

5.00/5.00
Happy-learning-user-review-ABIN BINOY

ABIN BINOY

5.00/5.00

Awesome course to learn data visualisation. I never knew excel can do so much. Thank you for this course.

Happy-learning-user-review-ASNA A

ASNA A

5.00/5.00

It is easy to access the class. Brilliant teacher and brilliant teaching manner. Doesn’t feel any kind of difficulties while attending class

Happy-learning-user-review-MOHAMMED SHADIL KM

MOHAMMED SHADIL KM

5.00/5.00

This course was well aligned with my expectations. This was the first time in my life that I tried using excel and after this course, I am near to professionals. The course is explained with excel work files and also we have the option to download the files and practice along with the trainer. simplified explanation with real examples and covered the basic to advanced functions & features, now I became very confident to work and the life long access makes me go through the videos the moment I face any doubts in any particular. Thanks, Happy learnings for your effort, and please let me update your upcoming office package courses.

Happy-learning-user-review-Sijitha k

Sijitha K

5.00/5.00

very good learning experience.



Add Your Comments

Your email address will not be published. Required fields are marked *

Add Ratings




  • Overview
  • Curriculum
  • Instructor
  • Reviews
Questions? Let's Chat
Need Help? Chat with us
Click one of our representatives below
happy-learning
Athira
Customer Support
I'm Online