Ms Office – Advanced Excel – International Student

Ms Office – Advanced Excel – International Student

Size
Price:

Read more

  1Month/10 Hours                                                  Price:17,000

                                                                                      16,000

 Ms Office – Advanced Excel  International Student 



Microsoft Excel is a leading and very high-demand office automation tool used all across industries for example Banks, Insurance, Telecom, Public Sector and many Small and Medium size Organization to perform Complex calculations, Data Analysis, Reporting and Dashboards creation, understanding financial modeling, learning Advanced Excel is a highly valuable career Asset, a must-have criteria to qualify for many jobs!

Course participants will learn all the key Excel functions and features using Advanced Microsoft Excel tools from basic to mastery level of excel expertise, after completing the course participants would be able to perform their day-to-day job in more productive and professional way to improve organizational performance. A best and most affordable advanced excel training @ Omni Academy. Online classes with flexible timing available for international students.


Advanced Excel Course

Course Content:

Module-I – Excel Foundation 

Getting Started with Excel
Data Entry, Data Editing, and Number Formatting
Data Formatting
Working with Cells and Ranges in Excel
Managing Worksheets
Save Your Worksheets

Module-II – Formula | Data | Charts Concepts

Formula Basics & Cell References
Auto Fills & Custom Lists
Working with Basic Excel Functions
Using Smart Tables
Sorting & Filtering Data
Working with Conditional Formats
Working with Charts

Module-III –  Using Advanced Functions

Working with Named Ranges
Using Complex Excel Functions
Using Multi-sheet Formulas
Using Advanced Filters
Data Validation & Protection
Consolidation & List Management
Automating with Macros

Module-III – Reporting & Dashboards 

Business Reporting with Excel Dashboards
Advanced Charting & Visualizations
Using Sparkline Charts
Creating Interactive Dashboard Reports

Module-IV – Working with Macros & Custom Functions 

Writing Customized Macros
Using What-If-Analysis
Working with Financial Functions
Creating Custom Excel Functions


International Student Fee : 120 USD




0 Reviews

Contact form

Name

Email *

Message *