- Introduction
- Be Function Friendly Using Textual, Mathematical and Logical Functions Together
- Textual, Mathematical and Logical Functions
- Be Function Friendly Using Time and Date Functions Together
- Combining Data From Multiple Workbooks
- Combining Multiple Workbooks
- Analyzing Data Sets, Solver and Scenarios
- Analyzing Data Sets , Solver and Scenarios
- Project Part II
What you'll learn
- Learn to use complex functions like VLookup, XLookup and HLookup,
- Combining Data from multiple resources and Using Pivot Tables
- Analayzing the data sets, Charts and Graphics, Setting Prints, Macros
- creating Templates
Description
This Course is designed for people with Basic knowledge about Excel. It covers Functions and Analyzing the Data and even Creating Templates.
It has various Exercises which are downloadable and contains very complex topics, that are suitable to be used in organizations in work as well as in home administration.
One who has done the course Part I will be very comfortable with the exercises and will find it easier to complete the exercises throughout the course.
The functions taught in the course are very popular and frequently used for ease in calculations and working on data. It is very important to move ahead and learn more about Excel.
I have covered Topics like
Textual Functions
Mathematical Functions
Logical Functions
Lookup and Reference Functions
Time and Date Functions
Complex Calculations
Error Tracing in Calculations
Analysing the data by using Data Analysis and Solver
Creating Scenarios and Saving Scenarios
Combining Multiple Workbooks and Doing Consolidation of Data
Creating Templates and Inserting Templates in Microsoft Excel
The course has quiz after every session and project at the end of the Course.
When you understand Excel at a more advanced level, you will have the ability to use its more sophisticated tools, which will allow you to complete your tasks and analyze your data more quickly. It will also allow you to keep team members up-to-date on data, which can streamline the workflow process
It can boost your employability and career prospects, whilst also being a useful tool to analyze data in everyday life, such as when managing personal finances. Excel is easily accessible software that is a valuable tool in all aspects of life and should be considered critical for personal development.
Excel means possessing the ability to use spreadsheets, graphing, tables, calculations, and automation efficiently to process large quantities of data relevant to business tasks.
With a vast program full of formulae, it can add, subtract, multiply and divide hundreds of numbers altogether, and can easily re-do it if a value is changed or added. This feature can be used to easily make a company's yearly sales and other spreadsheets.
Other Courses
書道LEVEL1: Mindful Japanese Calligraphy for Beginners 1-2/30
SHODO by Nohoh-Method: The Complete KAISHO Style! Basic Srokes & KANJIs. WITHOUT Japanese Knowledge! Creative & Relaxed
WordPress Multi Vendor Marketplace eCommerce Website
Learn How To Create a Professional Multi Vendor Commerce Website like Amazon & Flipkart With Wordpress - Dokan Plugin
Oracle Applications Multi Org Access Control (MOAC)
Oracle Applications Multi Org Access Control (MOAC)
So, you want to be a social worker?
A guide to what is involved in becoming a social worker
About the instructors
- 4.15 Calificación
- 16011 Estudiantes
- 16 Cursos
Meenal Hadavale
A Sales Professional and Engineer with Passion of Learning
Engineer by profession and have a desire to develop a career in sales. I have a passion to learn and keep learning new updates in IT and Management Studies. I am a keen learner and now would like to share my knowledge in both the fields. I have bountiful experience in some of the applications and even managing, in my work experience.
Student feedback
Course Rating
Reviews
the teacher is very humble and well informative. include more functions and more complex practical sheets.