Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you learn how to analyze and manage your data. You will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.
|Section 2: Using Advanced Functions|
Statistical and Math Functions
|Section 3: Formula Auditing|
Tracing Cell Precedents and DependentsPreview
Using the Formula EvaluatorPreview
|Section 4: Analyzing Data|
Using Goal Seek
Using the Scenario Manager
|Section 5: Advanced Formatting|
Understanding Custom Formats
Applying a Custom Format
Using Conditional Formatting
Adding Data Bars, Color Scales, and Icon Sets
Managing Formatting Rules
|Section 6: Managing Data|
Planning a Database and Understanding Database Terms
Formatting and Sorting Tables
Filtering a Table
Using the Advanced Filter
|Section 7: Working with PivotTables|
Creating a Simple PivotTable
Using the PivotTable Field List Pane
Working with PivotTable Options
Sorting in a PivotTable
Formatting a PivotTable
Creating a PivotChart
Formatting a PivotChart
|Section 8: Importing and Exporting Data|
Importing from Access
Importing a Text File
|Section 9: Macros|
Recording a Macro
Running a Macro
Running a Macro from a Custom Button
|Section 10: Conclusion|
At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.