Details
Microsoft Excel has many time saving tools that will help you become even more productive. This advanced Excel course covers a wide range of topics that will help you take full advantage of Excel's powerful features.
- Work with named ranges
- Use advanced functions
- Resolve formula errors
- Consolidate and manipulate data
- Analyze data using the Analysis Toolpak
- Work with PivotTables
- Use Macros
Who Should Attend:
Anyone who wants to use Microsoft Excel to create spreadsheets and automate data processing. Basic Excel knowledge at the level of Course 131 is expected.
Outline
- Understanding Relative and Absolute Cell References
- Using Multiple Cell References
- Using 3D References
- Using Array Formulas
- Understanding Named Ranges
- Defining Named Ranges
- Editing Named Ranges
- Deleting Named Ranges
- Using Named Ranges in Formulas
- Using the PMT Function
- Using the FV Function
- Using VLOOKUP and HLOOKUP Functions
- Using IF, AND, OR Functions
- Using TODAY, NOW, DATE, and TIME Functions
- Using the TRIM Function
- Using LEN and SUBSTITUTE Functions
- Using LEFT, RIGHT, and MID Functions
- Using the CONCATENATE Function
- Using SUMIF, COUNTIF, and AVERAGEIF Functions
- Tracing Formula Precedents and Dependents
- Showing Formulas
- Evaluating Formulas
- Setting Error Checking Options
- Using Error Option Buttons
- Running an Error Check
- Consolidating Information
- Removing Duplicates
- Configuring Data Validation
- Transposing Data
- Converting Text to Columns
- Outlining Data
- Showing and Hiding Outline Details
- Grouping Data
- Creating Subtotals
- Removing Outlining and Grouping
- Creating Scenarios
- Loading Scenarios
- Merging Scenarios
- Editing Scenarios
- Creating a Scenario Summary Report
- Deleting Scenarios
- Introducing Goal Seek
- Using Goal Seek
- Introducing Data Tables
- Using Data Tables
- Creating a Basic PivotTable
- Creating a Basic PivotChart
- Using the PivotTable Fields Pane
- Adding Calculated Fields
- Sorting Pivoted Data
- Filtering Pivoted Data
- Recording a Macro
- Editing a Macro
- Running a Macro
(Note: Macro Programming is not covered)
- Co-authoring
- Sharing a Workbook
- Protecting a Worksheet
- Protecting Cells
- Protecting a Workbook
- Introducing the Camera Tool
- Adding the Camera Tool
- Using the Camera Tool
ActiveLearning, Inc. is the Philippines' leading provider of Information Technology and Project Management education, where thousands of students take courses from Application Development to Project Management to Network Security, and much more. Our courses are taught by expert instructors, and learning is enhanced through a blend of in-depth lectures, workshops, and hands-on exercises.
Expert Instructors
Learn from expert instructors who practice what they teach. Our instructors are involved in constant research and development, who constantly apply the lessons they teach, and who know the same technical issues you face every day.
Superior Courseware
Our courseware go through rigorous evaluation before they are released for instruction. By constantly monitoring industry developments, we make sure that you get course materials that are up to date.
Interactivity
More than just classroom lectures, practical, hands-on exercises are carefully developed for you to immediately put in to practice what you learn. By being immersed in a classroom setting, you get to participate, inquire, and be involved - all essential in expediting the learning process. Aspects you won't find in Computer-Based-Training and self-study. ...