Learn Skill Future Approved Advance Excel Training at ExcelTrainings!
Details
Advanced Excel Course in Singapore to learn advanced functions and formulas to accelarate and automate your work. This course will help you to learn charts, file and data protection, Macros function, automate regular tasks and many more.
For More Details Visit: https://exceltraining.com.sg/advanced-excel-course-singapore/
#AdvancedExcelCourse #ExcelTraining #PivotTable #VLookup #FilteringData
Outline
- Creation & Formatting a Chart
- Adding Labels
- Playing the Chart Type & Data Source
- Updating Data Source
- Changing the Chart Location
- 1. How to protect your Worksheets
- 2. Using Consolidated Worksheets
- 3. Consolidating by Category
- 4. Consolidating by Position
- 5. Practice – Consolidating Worksheets
- 6. Protecting range with password
- 7. How to protect your Workbook
- 8. How to protect your Excel Files
- Recording a Macro
- Display the Developers Tab
- Changing Macro Security Setting
- Using a Macro Button
- Creating a Macro Button
- Copying a Macro Button
- Formatting a Macro Button
- Moving/Sizing a Macro Button
- Deleting a Macro Button
- Running a Macro
- Deleting a Macro
- Opening and Editing a Shared Workbook
- Tracking Changes
- Resolving Conflicts in a Shared Workbook
- Managing Conflicting Changes
- Resolving Conflicting Changes
- Setting Change History Options
- Adding a History Worksheet
- Reviewing Tracked Changes
- Creating a PivotTable & Filter Pages Report
- Adding PivotTable Report Fields
- Updating a PivotTable Report
- Selecting a Report Filter Field Item
- Changing the Summary Function
- Publishing PivotTable Reports to the Web
- Moving PivotTable Report Fields
- Using Expand and Collapse Buttons
- Hiding/Unhiding PivotTable Report Items
- Practice – Creating/Revising PivotTables
- Introducing Slicers
- Using Slicers to Filter Data
- Deleting PivotTable Report Fields
- Formatting a PivotTable Report
Excel Training is intended for current Microsoft Excel users who wish to deal with workbook and productivity features. It includes areas such as creating Complex Charts, Pivot Table, worksheet consolidation and linking with external data file, data analysis tools, and automating workbook operations using macros.
We have massive length of Excel courses to develop and improve your skills: Some are:
Microsoft Excel Course, Master Excel, Basic Excel, Intermediate & Advanced Excel and Many More..
Visit us - http://exceltraining.com.sg/