- Class Room Training
- High Quality Training
- Ample Practical Sessions
- Industry based examples
- Course Completion Certificate
- Course Design as per MOS(Microsoft Office Specialist)
What is the course all about?
Now a days, many jobs require advanced Excel skills. That said, there are a number of functions that, in practice, require some skill in order to solve complex problems. Part of the challenge for you is knowing when and how you can apply these and how to design them for your specific purpose. Without them, Excel is just a data keeping tool. But by using formulas, you can crunch data, analyze it and get answers to most complex questions. Apart from knowing the formulas, advanced Excel users know how to debug them, audit them and how to use which formula for which occasion.
Advance Excel Course Content
Introduction to MS Excel,
Quick Review on MS Excel Options,
Ribbon, Worksheets and Toolbar,
Copy, Cut, Paste,
Hide, Unhide, Delete and Link the Data in Rows, Columns and Sheets,
Protecting & Unprotected Cells, Rows, Columns and Sheets with or without Password,
Paste Special Options,
Page Layout, Themes, Background and Printer Properties,
Inserting Pictures, Hyperlinks, Header/Footers, Shapes and Other Objects in Worksheets.
Use a Criteria Range,
Show All Records,
Use an Advanced And Condition,
Use an Advanced Or Condition,
Copy Filtered Records,
Use Database Functions,
Find Unique Records,
Remove Duplicates from a Table
Add, Remove and Format Gridlines,
Format an Axis,
Change the Axis Scale,
Format the Data Series,
Add Data – Different Worksheets,
Use a Secondary Axis,
Change Data Series Chart Types,
Create User-defined Charts, Customize, etc.
Create, Display and Edit a Scenario,
Create a Scenario Summary Report,
Use Goal Seek,
Use Data Table.
Add PivotTable Report Fields,
Select a Report Filter Field Item,
Refresh a PivotTable Report,
Change the Summary Function,
Add New Fields to a PivotTable Report,
Move PivotTable Report Fields,
Use Expand and Collapse Buttons,
Hide/Unhide PivotTable Report Items,
Delete PivotTable Report Fields,
Create Report Filter Pages,
Inserting & Using Slicers,
Format a PivotTable Report,
Create a PivotChart Report,
Publish PivotTable Reports to the Web.
Learn about creating named ranges, and the benefits of doing so.,
Use Of Cell Referencing.
Display/Remove Dependent and Precedent Arrows,
Remove Tracer Arrows,
Use Auditing Tools Buttons.
Use of Referencing,