Advanced Microsoft Excel

Intellisoft Training Pte. Ltd. was setup by industry leading experts from the Education industry for the sole purpose of providing quality training to companies and individuals, which lead to Best-in-Class Industry Certifications.These short training courses help companies to improve their productivity, efficiency and save time.Intellisoft Training Pte. Ltd. has partnered with ICDL Asia to highest rated International Computer Driving Test Accreditation to Singapore. We are an Approved ICDL Test Center to conduct all ICDL Core and ICDL Advanced Courses in Singapore.

Intellisoft Training

2 Days Extensive Workshop on Advanced Microsoft Excel

Lesson 1: Using Custom &amp; Conditional Formats
<ul><li> Reasons for Using Custom Format
</li><li> Understanding Conditional Formatting
</li><li> Managing the Conditional Format Rules
</li><li> Changing the Conditional Formatting Rules
</li><li> Locating Cells with Conditional Formatting
</li><li> Working with Conditional Formatting
</li></ul>
Lesson 2: Using Range Names 
<ul><li> Managing Named Range</li><li> Assigning Names to Groups of Cells
</li><li> Using Names in Formulas
</li></ul>
Lesson 3: Using Formulas &amp; Functions
<ul><li> Understanding Formulas &amp; Functions
</li><li> Quick Way to Insert a Function
</li><li> Viewing the Formulas (and not the results)
</li><li> How to Delete Values and not Formulas
</li><li> Create a Relative &amp; Absolute Reference
</li><li> Working with Logical Functions
</li><li> Using SUMIF and COUNTIF Functions
</li><li> Working with Text Functions
</li><li> Working with Date and Time Functions
</li><li> Working with Lookup Functions
</li><li> Understanding VLOOKUP Function
</li></ul>
 Lesson 4: Managing, Sorting &amp; Filtering Tables
<ul><li> Create and Modify Tables
</li><li> Sorting and Filtering Data in a Table
</li><li> Getting Summary Information in a Table
</li><li> Calculate Total Row in a Table
</li><li> Display Special Formatting for First/Last Column
</li><li> Outline a List of Data
</li><li> Validating Data During Entry
</li><li> Working with Database Functions
</li><li> Using Advanced Filters in Excel 2016
</li><li> Quick Analysis With New Features of Excel 2016
</li></ul>
Lesson 5: Working with Charts in Excel 
<ul><li> Summarizing Data Visually Using Charts
</li><li> Creating a Chart Quickly
</li><li> Changing the Chart Type
</li><li> Customizing Chart Data
</li><li> Show or Hide Chart Gridlines
</li><li> Creating a Pie Chart
</li><li> Saving the Chart as a Template
</li><li> Creating Combination Charts
</li><li> Using The New Pareto Chart Functionality
</li><li> Using Recommended Charts Effectively
</li></ul>Lesson 6: Working with Pivot Tables
<ul><li> What is a Pivot Table</li><li> Anatomy of a Pivot Table
</li><li> How does a Pivot Table Works
</li><li> Create a Basic Pivot Table Report
</li><li> Rearranging a Pivot Table Report
</li><li> Customizing a Pivot Table
</li><li> Changing Summary Calculations
</li><li> Adding and Removing Subtotals
</li><li> Sorting in a Pivot Table
</li><li> Filtering in a Pivot Table
</li><li> Create Report Filter Pages
</li><li> Using Slicers in Pivot Table
</li><li> Working with Pivot Chart
</li></ul>
Lesson 7: Working with Shared Workbooks
<ul><li> Working in a Group Environment
</li><li> Sharing Workbooks in Excel
</li><li> Commenting in Cells
</li><li> Tracking Changes in Workbooks
</li><li> Accepting or Rejecting Changes
</li><li> Keeping a Backup of your Changes
</li></ul>
Lesson 8: Working with Multiple Workbooks
<ul><li> Linking to Other Workbook
</li><li> Consolidating Multiple Sets of Data
</li><li> Consolidate Multiple Worksheets
</li></ul>
Lesson 9: Protecting Your Worksheet and Workbook
<ul><li> Protecting Your Worksheet
</li><li> Protecting Your Formulas
</li><li> Protecting Your Workbook
</li><li> Save Your Workbook with Password
</li><li> Encrypting your Workbook
</li></ul>
Lesson 10: Working with Excel Macros
<ul><li> Recording &amp; Testing a Macro
</li><li> Using the Developer Tab
</li><li> Create a Macro
</li><li> Relative and Absolute Recording
</li><li> Testing the Macro
</li><li> Running and Deleting Macros
</li><li> Using a Shortcut key
</li><li> Placing a Macro on the Quick Access Toolbar
</li><li> Short Introduction to Macro Programming in Excel 
</li></ul>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Advanced Microsoft Excel

More events from Intellisoft Training

Discover more events from Intellisoft Training, from Business to other experiences you might love.

Advanced Microsoft Excel

More events from Intellisoft Training

Discover more events from Intellisoft Training, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.