Complete Hands-on Advanced Excel
Learn Excel from beginner to advanced level with this comprehensive course. Covering functions, formulas, data analysis, pivot tables, and more, this course is perfect for aspiring Excel Data Analysts. Gain a competitive edge in your career by mastering the powerful features of Excel. Practice resources are provided to enhance your learning experience. Start your journey to becoming a proficient Excel user today.
What you’ll learn
- Introduction of MS Excel
- Text Functions and Numerical functions
- Formatting types in Excel
- Inserting Images,Shapes, Charts and lot more things.
- Sorting and filtering of data
- IF Functions
- Pivot Tables and Charts
- Conditional and lookup functions
- IF Function
- IF Or Function Count if
- VLOOKUP
- HLOOKUP
- INDEX FUNCTION
- MATCH FUNCTION
- Precedent and dependent
- Watch Window
- Pivot charts
- Excel Power pivot
- Key Performance Indicator (KPI)
Show moreShow less
Excel is the most powerful tool to manage and analyze various types of Data. This perfectly designed Excel course will begin with an introduction to Excel and will take you through various features of Excel. If you’re an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start. Grow your career as a Data Analyst through knowing Data Analysis in Excel. Everything that is very important to know like Functions and Formulas, Data Validation, Pivot Table, Power Pivot, VLookup, HLookup, KPI and many more things are discussed in details in this course. This course will help you to make yourself one step ahead of everyone. All the resources are given that will help you to practice.
This course is designed perfectly, from introduction to advanced will be covered through various features of excel. You will get familiarized with Cell Refencing, Table formation, Customizing Cell Style, Border, Formula and Functions, Conditional Statements, Data Sorting, Filtering, Validation.
You will get notion of use Descriptive Statistics through the use of Average, Median, Count, Max, Min functions. An in-depth knowledge of using Chart and Graphs to analyse data, and presenting data through pivot table using of power pivot and KPI.
Who this course is for:
- Aspiring Excel Data Analyst
User Reviews
Be the first to review “Complete Hands-on Advanced Excel”
You must be logged in to post a review.
There are no reviews yet.