Step By Step Excel
What You Will 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
Basic knowledge about Excel, Workbooks Worksheets and working with data.
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
Lookup and Reference Functions
Time and Date Functions
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.
Who this course is for:
- Learn the advanced features in Microsoft Excel
- Textual, Logical and Mathematical, Date and Time, Lookup and Reference Functions in Excel
- Learn to Combine multiple Workbooks and link the data in the workbooks
- Learn to Analyze Data by using data solver and data analysis
Be Function Friendly Using Textual, Mathematical and Logical Functions Together
Textual, Mathematical and Logical Functions
Be Function Friendly Using Time and Date Functions Together
Reordering and Sorting with Lookup and Reference
Sorting and Lookup with reference
Combining Data From Multiple Workbooks
Combining Multiple Workbooks
Analyzing Data Sets, Solver and Scenarios
Analyzing Data Sets , Solver and Scenarios
Project Part II