What You will Learn
What You will Learn
Language-English & Hindi
Use On Desktop,Tablet & Mobile
Live Classes On Google meet & Zoom
Certificate Of Completion
2 Months Course Duration
Learn at Your Own Pace
Work comfortably with Microsoft Excel 2016 and many of its advanced features
You will understand the basic fundamentals of Microsoft Office Excel.
Customizing Excel as per your needs
Formatting, selecting and navigating techniques in Excel.
Working with Rows, Columns, Cells, Sheets and Workbook.
Shortcut keys, tips and tricks to do speedy work.
Performing Calculations and creating your own formulas.
Performing Calculations and creating your own formulas.
What are the freelancing sites to work on?
Text functions and data cleaning.
Sorting and filtering your data.
Increasing productivity in excel.
All about IF function and logical operators.
Count Function and its usage.
Practical level examples with real live cases
Statistical functions for data analytics
Conditional formatting of data to make it logically more appealing.
All Lookup functions with detailed working.
Where to get free and paid templates and make money using them?
What are the freelancing opportunities for you?
Microsoft Office Excel is the most popular spreadsheet tools available in the market. Excel Professionals are in high demand and learning excel is one of the best decisions you will make as it is a highly paid skill. It is a must know tool if you want to work in a corporate, or you are looking to develop a freelancer profile and earn sitting at home. It opens up many freelancing opportunities in many sectors such as finance, accounting, marketing, project management, data analysis and many more fields. No matter which industry it is excel is a must. It's employed for budgeting, financial management, project planning, inventory management, supply chain management and reporting etc. With charting and statistical functions, Excel aids data exploration and offers basic database capabilities. Even if you are not a professional, Microsoft Office Excel can help you in data organization, data manipulation, data cleaning, calculations, analysis, and visualization.
This course is organized in such an easy to learn way, that even if you are a complete beginner who just knows how to switch on a computer and use a mouse. You will be able to learn all the essential skills and apply for a job or as a freelancer and earn your way in this digital age.
The course is focused on fundamentals, as well developing a real-life skillset, using the practical hands on. I have provided some course material in pdf form. Also, I have provided in the course all you need to know for becoming a freelancer, where you can get the free and paid templates and make money out of it and where you can avail all these opportunities as a pdf file to help you start your own freelancing business.
Opening Excel
Performing Cell, Row, Column And Sheet Operations
Entering Data Into Excel
Navigating Through The Excel Sheet
Making Selections In Excel
More Formatting Options In Excel
Data Types In Excel
More Cell Operations
Performing Basic Calculations In Excel
Cell Addressing And Referencing
Find, Replace And Goto
Understanding The Clipboards Group
Customizing The Ribbon
Customizing The Qat
Sorting & Filtering
Logical Functions
Text Functions
Count Functions
Statistical Functions
Lookup Functions
Conditional Formatting
Where To Get Free Template
Make Money Using Paid Templates
Where To Go From Here
Navigating Through The Excel Sheet
Cell Addressing And Referencing
Logical Functions
.
.
.
.
.
.