Excel 2010 Advanced

Analyze, manage, visualize, and share your data.

Preview the first lesson free — get full access to all 108 lessons.

Course: On-Demand

Advanced Provider : Valerie Chau 13 chapters · 108 Lessons · 7h 4m in Arabic, English, Spanish

Course Description

Learn advanced features, starting with how to customize both the Quick Access Toolbar and the Ribbon by adding new buttons and tabs, removing buttons and/or tabs and more. Make complex by adding conditions, testing conditions and naming cells in formulas. Learn advanced ways to use tables and templates, collaboration, and macros.

What You'll Learn

Customize the Quick Access Toolbar by adding buttons and saving favorites for specific workbooks
Customize the Ribbon by changing existing tabs, adding new tabs, and reusing customized ribbons on another computer
Build conditional formulas using IF(), COUNTIF(), and SUMIF(), and fix errors in formulas
Name cells, formulas, and constants, and work with named ranges and variable data tables
Create, format, edit, sort, and filter tables, and handle duplicate data
Perform calculations in tables using the Total Row, SUBTOTAL(), and table database functions, and create and nest groups to summarize data

Key Takeaways

The course covers advanced Excel 2010 features including customizing the Quick Access Toolbar and the Ribbon by adding and removing buttons and tabs.
It teaches how to build complex formulas by adding and testing conditions and by naming cells, formulas, and constants used in formulas.
Learners work with advanced table features such as formatting, editing, sorting, filtering, handling duplicate data, calculations, and table database functions.
The course addresses collaboration, templates, and macros as advanced ways to work in Excel.
Grouping topics cover creating a group, nesting groups, and summarizing data.

Frequently Asked Questions

What does this course cover?

Excel 2010 Advanced covers customizing the Quick Access Toolbar and the Ribbon, building complex formulas with conditions and named cells, advanced use of tables and templates, collaboration, and macros.

What skills will I gain from this course?

The course is associated with skills in Microsoft Excel, Advanced Function Presentation, Excel Formulas, Excel Macros, Microsoft Office Specialist (MOS) - Excel, and SAS Certified Professional: Advanced Programming.

Will I learn how to work with conditional formulas?

Yes. The course teaches conditions in formulas using IF() and more, conditions using COUNTIF() and SUMIF(), and how to fix errors in formulas.

Does the course teach how to work with tables?

Yes. It covers creating, formatting, editing, sorting, and filtering tables, dealing with duplicate data, calculations in tables, table and column names, using the Total Row and SUBTOTAL(), and table database functions.

Can I reuse my customized Ribbon on a different computer?

Yes. The course includes a lesson on saving and reusing customized ribbons on another computer.