MS Excel Advanced

Course Content:

Perform Calculations with Functions

Understand Functions, Understand the Components of a Function, Enter Functions in Worksheets, Type a Function Directly into a Cell, Use the AutoSum Drop-Down Menu Use the Insert Function Dialog Box, Nest One Function Inside Another Function, Date and Time Functions, Financial Functions, Logical Functions, Lookup and Reference Functions Mathematical Functions, Statistical Functions, Text Functions., Refer to Cells and Ranges in Formulas, Refer to Other Worksheets and Other Workbooks in Formulas, Use Range Names and Labels in Formulas, Troubleshoot Formulas, Understand and Fix Basic Errors in Formulas

Sort and Filter Data with Excel

Sort, Perform a Quick Sort by a Single Field, Perform a Multifield Sort for Finer Sorting Sort by a Custom Sort Order, Filter a to Find Records That Match Criteria .,Perform Quick Filtering with AutoFilter Create Custom Filters

Create Effective Charts to Present Data Visually

Understand the Basics of Excel Charts, Create a Chart with the Chart Wizard, Choose the Right Type of Chart for Your Data,Edit Charts to Produce the Best Effect,Use the Chart Toolbar, Select Objects in a Chart, Configure Chart Options, Change the Chart Type, Change a Chart's Source Data,Change the Plotting Order of the Data Series, Configure and Change the Scale of an Axis, Format Charts, Resize a Chart, Format the Chart Area, Liven Up Charts with Patterns, Fills, and Pictures, Format Individual Chart Elements, Print Charts

Analyze Data Using Pivot Tables and Pivot Charts

Understand PivotTables, Create a PivotTable Framework Using the PivotTable and PivotChart Wizard, Create the PivotTable on the Framework,Choose PivotTable Options to Configure a PivotTable,Create PivotCharts from PivotTables, Create a Conventional Chart from PivotTable Data

Protecting and Sharing the work book

Restrict Data and Protect Workbooks,Check Data Entry for Invalid Entries,Protect Cells, a Worksheet, or a Workbook, Protect a Workbook with Passwords,Work with Comments Add a Comment to a Cell,Display and Hide the Comments in a Worksheet,Edit and Format Comments, Delete a Comment, Insert Excel Objects in Word Documents, Insert a Chart in a Word Document, Insert Excel Objects in PowerPoint Presentations, Insert a Chart in a PowerPoint Slide, Insert Word Objects in Worksheets, Insert PowerPoint Objects in Worksheets .

Use Macros to Automate Tasks

Record a Macro Using the Macro Recorder, Test and Run a Macro,Run a Macro from the Macro Dialog Box, Create a Toolbar Button or Menu Item to Run a Macro, Assigning a Macro to an Object, Delete a Macro