Working With Advanced Excel
Course Curriculum
Calculating data with advanced formulas
You will learn about using advanced formulas in MS-Excel for calculating data.
Organizing Worksheet and Table data
This module will teach you how to organize worksheet and table data in MS-Excel
Presenting Data Using Charts
This section will introduce you to Data Presentation and how to present your data using charts.
Analysing Data using pivot tables and pivot charts
You will learn about data analysis using Pivot tables and charts in MS-Excel.
Inserting graphic Objects
This module will teach you about inserting graphical objects in MS-Excel.
Customizing and Enhancing workbooks and the Excel environment
You will learn how to customize and enhance workbooks and Excel environment.
Streamlining workflow
This module will guide on how to streamline your workflow in MS-Excel by identifying and prioritizing tasks.
Collaborating with others
You will learn about working in collaboration with others in MS-Excel.
Auditing worksheets
This module will cover everything related to the audit process. You will learn how to audit worksheets in MS-Excel.
Analyzing data
This module will be all about data analysis; you will learn the procedures and steps involved in data analysis.
Working with multiple workbooks
This module will throw light on working with multiple workbooks at a time in MS-Excel.
Importing and Exporting data
You will learn about how to import and export your data in an MS-Excel environment.
Using Excel with the web
This module will guide you to use excel with the web. You can import and export data directly from the web.
Structuring workbooks with XML
This module will cover everything about structuring workbooks, and You will learn how to use XML for structuring your workbooks.
Automating business operations
You can also automate business operations using MS-Excel. This module will cover everything about business operations automation
Manipulating the Excel environment
In the last module, You will learn about Excel environment manipulation for efficient data analysis.
Basics of computer :Ms office
Course Curriculum
- Word processors.
- Spreadsheets.
- Database systems.
- Presentation software.
- E-mail tools.