About the Course
INTRODCUTION:
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software.
SCOPE OF COURSE:
These skills are especially useful in the MNCs where it helps in creating MIS reports, ratio analysis, and various other reports. In India and the world, the demand for skilled MIS professionals is growing rapidly.
CAREER PROSPECTS / JOB ROLES:
Data Analyst.
Business Analyst.
Business Intelligence Specialist.
Operations Executive.
Business Intelligence Consultant.
Business Analyst.
Microsoft Excel
Price
₹ 4999
Duration
40 Hours
Syllabus for Microsoft Excel Courses in Hyderabad
Custom and Conditional Formats
Introduction
Creating Conditional Formatting using color scales
Using Icon sets
Conditional formatting using New rule
Conditional formatting using manage rules and clear rules
Data Validation
Specifying a valid range of value of a cell
Specifying a valid value for a cell
Specifying custom validation based on formula for a cell
Prevent duplicate entries
Working with Range Names
Using Range names
Creating range names
Using range names in formulas
Deleting range names
Advanced Range Options
Advanced Table Option
Creating Tables
Naming the Tables
Changing the Table style
Creating a total row
Creating a calculated column
using FIltering in Table
Removing the duplicate record
Array Functions
Array functions using CTRL+SHIFT+ENTER
One Dimensional Array
Two Dimensional Array
Single cell and Multi cell Array
Using Formulas and Functions
Text Function
Logical Functions
Date and Time Functions
Math and Trigonometry Functions
Statistical Functions
Lookup and reference functions
Working with Charts
Creating a chart
Formatting a chart
Adding Labels
Changing the chart type, Data source
Working with Pivot Tables
Creating Pivot tables
Adding Pivot table Report Fields
Refreshing Pivot table Reports
Changing the summary functions
Creating report filter page
Creating Subtotals
Multiple Level subtotals
Creating Pivot tables
Formatting and customizing Pivot tables
Using advanced options of pivot table
pivot charts
Worksheet Protection
Protecting your work sheet
Protecting range with password
Protecting your Workbook and Excel Files
Sharing a workbook
Opening and editing a shared workbook
What-IF Analysis
Goal Seek
Data Tables
Scenario Manager
Import and Export
Import a text file by opening it in excel
Import a text file by connecting to it
Export data to a text file
Changing the delimiter
Change the separator in all .CSV text file
Working with Macros and VBA
Display the developer Tab
Changing Macro security Settings
Recording and running a Macro
Delete a Macro
VBA (Visual Basic Application)
Advantages and features
VBA Message Box , Comments
InputBox using VBA
Sub and Functions using VBA
VBA Constants , variables
VBA Operators
Loops
VBA Decisions
User form in VBA
FAQs on Microsoft Excel Course
What is the best way to learn Microsoft Excel?
If you're new to Excel, an introductory course can help get you up to speed quickly on Excel basics. Online Excel courses may explore how to set up an Excel sheet, perform basic calculations, use formulas, and create data visualizations with charts and graphs.
What are the 5 basic Excel skills?
Below you have the top ten basic Excel skills to learn by anyone who is just starting out with Excel needs to learn.
Saving and Opening a Workbook. ...
Managing Worksheets. ...
Formatting Cells. ...
Printing. ...
Excel Functions (Basic) ...
Charts. ...
Sorting Data. ...
Find and Replace Option.
How much time to learn Excel?
How Much Time Does It Take To Learn Advanced Excel? This question is subjective in nature as it depends on your grasping capability, but, on an average 12-14 hours well-curated course does the trick.
What are the 4 types of Excel?
Excel data types are the four different kinds of values in Microsoft Excel. The four types of data are text, number, logical and error. You may perform different functions with each type, so it's important to know which ones to use and when to use them.
Are Excel skills in demand?
Yes, Excel skills are in demand because this application is one of the best spreadsheet applications around. It has all the function functions you’ll need to manipulate and organize data. However, keep in mind that Excel skills are usually combined with other skills such as data analysis.
Is Excel easier to use than Word?
Learning Microsoft Word is easier than learning Microsoft Excel. However, Word isn’t used for data manipulation, so it’s likely that you will need to learn both.
Your Instructor
Bhargava Krishna
Meet our experienced Data Analytics Instructor, with over 8 years of experience in the field of data analysis and visualization. They are well-versed in various tools and techniques used for data analytics such as Tableau, Power BI, SQL, and Excel. With their expertise, they have helped numerous students and professionals alike in gaining a strong understanding of data analysis and how to apply it to real-world problems. They have a passion for teaching and have a proven track record of delivering engaging and informative classes. Their industry experience, combined with their instructional skills, makes them a valuable resource for anyone looking to advance their skills in the field of data analytics.