Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
12 Hour(s) 55 Minute(s)
Language
English
Taught by
Mohan Mishra
Course Overview
In Depth 80+ Lectures on Each Concept with Proper Example and Related Exercise for Better Practice
Having Working knowledge of MS Excel has become imperative for every working professional as the use of MS Excel across organization is domain and department agnostic. A strong knowledge of MS Excel would help professionals to success in their respective career paths. Microsoft excel course is for all kind of professionals those who is looking to increase their quality productivity with advanced functions, calculation, graphing tools, pivot tables, formulas and data process.
Course Objectives
To understand the Basic and advanced functions of Microsoft Excel.
To be able to use Date and Time, Logical, Statistical, and Lookup and Reference functions
To be able to create more complex formulas
To proficiently use Advanced Charting and the new charts introduced in Excel
To be able to forecast using the Forecast Sheet tool
To be able to consolidate data
To be able to gather and shape data for analysis using Get and Transform
To be able to create relationships between multiple datasheets and analyze the combined data using PivotTables and Pivot Charts
To understand how to use macros
To understand and utilize advanced data management tools like What-If Analysis
Learning Outcomes:
At the finish of this high level Excel course you will have a total comprehension of the greater elements of Excel.
You will be able to perform and analyze the most advanced excel calculations and functions, manipulate data using pivot tables and visualize advanced analysis, record macros and integrate excel with other office applications.
Highlight targets, patterns, copies and mistakes with Conditional Formatting
Course Content
- 21 section(s)
- 82 lecture(s)
- Section 1 Introduction To Excel Course
- Section 2 Navigating Excel Interface
- Section 3 Idea of Excel Data Format
- Section 4 Using Quick Commands for Better Performance
- Section 5 Copy and Paste In Excel With Ease
- Section 6 Perform Calculation Using Excel Formulas
- Section 7 Rearrange Text With TEXT Function
- Section 8 Working With Cell Reference Function
- Section 9 Conditional Formatting For Better Data Analysis
- Section 10 Working With Date Function
- Section 11 Working With Data Validation
- Section 12 Work Smarter With Excel Logical Formula
- Section 13 Perform High Level Calculation With IF & IFS Condition
- Section 14 Lookup & Reference functions
- Section 15 Chart and Graphs
- Section 16 Data Analysis in Excel
- Section 17 Data Analysis Using PIVOT Table
- Section 18 Protecting Workbook and Data Inside
- Section 19 Views and Layout
- Section 20 Printing For Final Output
- Section 21 Thank You Note
What You’ll Learn
- Get confidence in Excel even if you’re a complete beginner, Learn the essential and advanced Skill in Microsoft Excel, Understand the Basics of Microsoft Excel and be able to use this amazing application for different tasks, Learn how to format data and create easy presentable report, Learn Basic to advanced text, Numbers and other Formatting, Gain Progress from easy formula creation to Advanced Formula access, Master logical functions like IF, AND, OR, SUMIF, AVERAGEIF, NestedIF, for dynamic analysis, Learn different Search Functions like Lookup, VLOOKUP, XLOOKUP, INDEX, MATCH and other Search Function with proper Example and Practice, Learn How To Create Chart and Graphs and Manage to Create Interactive Dashboard with ease., Start Applying Advanced Excel in real world situation immediately from the day you learn
