About this Course

Target Audience: Course designed for business analysts, finance and accounting audiences, management, and general audiences. Pre-requisite: EX01-100 Course Outline • Working with Charts ? Creating a Chart ? Styling Charts with the Design Tab ? Modifying Charts with the Layout Tab ? Additional Styling with the Format Tab ? Manipulating a Chart ? Changing the Type of Chart ? Changing the Source Data ? Working with the Chart Axes and Data Series ? Saving a Chart as a Template • Time Saving Templates ? About Excel File Types • Adding Sparklines ? What are Sparklines? ? Adding Sparklines ? About the Sparkline Tools Tab ? Removing Sparklines ? Editing Sparklines ? Setting Sparkline Options • Excel Protection ? Protecting an Entire Workbook ? Protecting the Current Sheet • Using Paste Special • Exploring Scenarios ? What is a Scenario? ? Creating a Scenario ? Saving Multiple Scenarios ? Merging Scenarios ? Creating a Scenario Summary Report • Using a One or Two Input Data Table • Using Goal Seek • Using Solver ? Understanding Solver ? Generating Reports and Scenarios with Solver ? Managing Solver Constraints ? Choosing a Solving Method ? Using Solver as a Goal Seek Tool • Using Excel as a Database ? Filtering with Wildcard Characters ? Get External Data Commands ? Connections Commands ? Validating your Data ? Using Database Functions Consolidating Workbooks ? Combining Worksheets ? Consolidating Workbooks ? Combining Worksheets • Conditional Formatting • Macros ? Recording a Relative Reference Macro ? Running a Relative Reference Macro ? Assigning a Keystroke to a Macro ? Copying a Macro from a Workbook or Template • Visual Basic and Macros ? Opening the Visual Basic Editor

Rate this course:

Log in to submit

Comments