Advanced Excel (Basic to Advance)
Microsoft Excel is a spread-sheet application developed by Microsoft. Its use is to do advanced calculation, graphing tools, pivot tables, and a macro programming language referred to as Visual Basic for Applications.
We are providing GLOBALLY RECOGNIZED MICROSOFT CERTIFICATION with this course.
More Functions and Formulas
- Formulas with Multiple Operators
- Inserting and Editing a Function
- Auto Calculate and Manual Calculation
- Defining Names
- Using and Managing Defined Names
- Displaying and Tracing Formulas
- Understanding Formula Errors
- Using Logical Functions (IF)
- Using Financial Functions (PMT)
- Using Lookup Functions (VLOOKUP)
- User Defined and Compatibility Functions
- Financial Functions
- Creating Model on Financial Function (Automate Loan Calculation Sheet)
- Date & Time Functions
- Lookup & Reference Functions
- Creation of model based on big data set with dynamic functionality
- Text Functions
- Logical Functions
- Information Functions
Working with Data Ranges
- Sorting by One Column
- Sorting by Colors or Icons
- Sorting by Multiple Columns
- Sorting by a Custom List
- Filtering Data
- Creating a Custom AutoFilter
- Using an Advanced Filter
Working with PivotTables
- Creating a PivotTable
- Specifying PivotTable Data
- Changing a PivotTable’s Calculation
- Filtering and Sorting a PivotTable
- Working with PivotTable Layout
- Grouping PivotTable Items
- Updating a PivotTable
- Formatting a PivotTable
- Creating a PivotChart
- Using Slicers
- Sharing Slicers Between PivotTables
- Creating a complete dashboard with the help of Pivot and charts
Analyzing and Organizing Data
- Creating Scenarios
- Creating a Scenario Report
- Working with Data Tables
- Using Goal Seek
- Using Solver
- Using Text to Columns
- Grouping and Outlining Data
- Using Subtotals
- Consolidating Data by Position or Category
- Consolidating Data Using Formulas
Working with the Web and External Data
- Inserting a Hyperlink
- Importing Data from an Access Database or Text File
- Importing Data from the Web and Other Sources
- Working with Existing Data Connections
Working with Macros & VBA
- Recording a Macro
- Playing and Deleting a Macro
- Adding a Macro to the Quick Access Toolbar
- Editing a Macro’s Visual Basic Code
Customizing Excel
- Customizing the Ribbon
- Customizing the Quick Access Toolbar
- Using and Customizing AutoCorrect
- Changing Excel’s Default Options
- Creating a Custom AutoFill List
- Creating a Custom Number Format
Working on Live Data and Dashboards
- Creating dashboards on company specific data
- Working on Live data
- Dashboards with the help of Developer Ribbon
- Working with critical & Complex formulas
Two certifications will be provided to participant:
- Microsoft Certified Technology Associate Certification certified by Microsoft.
- Institution Certification certified by DOIS Education & Technologies Private Limited
Duration of Course: 30Hrs
Course Price : 10,000 INR + GST OR 190 USD