Advanced Excel Course
Microsoft Excel – Basic & Advanced
Microsoft Advance Excel Course is directed towards imparting education on advanced features, functions and formulas of Microsoft Excel. It consists of tools which help the user to solve complex calculations in a jiffy. It aims at providing knowledge on how to present huge complex data in a better and systematic manner and to draw out meaningful conclusions out of it. As you will get to learn about the course, you will become a valuable asset for your firm.
About Course: Microsoft excel advance is an integrated course that starts from the very basic level of excel to the advance level. This course focuses on teaching students how to work with functions, insert tables, formulas, visualize data with charts, sort complex data and so on. At the successful completion of this course the student will be able to perform well with advanced accounting, advanced formulas, charting and other vital elements. Knowledge of advanced level of excel course imparts a lot of smart knowledge, quick techniques that makes working on advanced excel very easy.
This Microsoft Excel course combines 4 different courses.
- Microsoft Excel 101 – An Introduction to Excel
- Microsoft Excel 102 – Intermediate Level Excel
- Microsoft Excel 103 – Advanced Level Excel
- Master Microsoft Excel Macros and VBA in 6 Simple Projects
Material recorded with Excel 2013 but works in 2010, 2013, and 2016
Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor I will use my 15+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.
Target students: students having sufficient knowledge of the basic Microsoft excel must join this course. Basic knowledge does not include simple know how but practical application of simple formulas like sum, autosum and all.
Microsoft Excel Advanced Course Outlines:
For people with basic knowledge of Excel want to learn more about advanced formulas (text, math, date and time, logical, etc) and advanced tools like chart, sorting, filtering, conditional format, pivot table.
Working With Functions
- Work with Ranges name
- Use Specialized Functions
- Work with Logical Functions
- Work with Date & Time Functions
- Work with Text Functions
Working With Lists
- Sort Data
- Filter Data
- Query Data with Database Functions
- Outline and Subtotal Data
Analyzing Data
- Create and Modify Tables
- Apply Intermediate Conditional Formatting
- Apply Advanced Conditional Formatting
Visualizing Data With Charts
- Create a PivotTable
- Modify and Format Charts
- Use Advanced Chart Features
Using PivotTables And Pivot Charts
- Create and Modify Tables
- Analyze PivotTable Data
- Present Data with Pivot Charts
- Filter Data by Using Timelines and Slicers
Microsoft Excel Advanced Training Outlines:
For people who have a need to consolidate, collaborate with others when working with Excel and want to automate their simple repetitive tasks in Excel with Macro.
Working With Multiple Worksheets And Workbooks
- Use Links and External References
- Use 3-D References
- Consolidate Data
Using Lookup Functions And Formula Auditing
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
Sharing And Protecting Workbooks
- Collaborate on a Workbook
- Protect Worksheets and Workbooks
Automating Workbook Functionality
- Apply Data Validation
- Search for Invalid Data and Formulas with Errors
- Work with Macros
Creating Sparklines and Mapping Data
- Create Sparklines
- Map Data
Forecasting Data
- Determine Potential Outcomes using Data Tables
- Determine Potential Outcomes using Scenarios
- Use the Goal Seek Feature
- Forecasting Data Trends