Excel 2013 Advanced

Master new formulas and functions with this advanced course

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

Course: On-Demand

Advanced Provider : Valerie Chau 13 chapters · 107 Lessons · 6h 36m in Arabic, English, Spanish

Course Description

This course on Microsoft's Excel 2013 software explains advanced features and does little review of basics. Start by learning to modify and customize how Excel looks and works, including using templates. Learn more advanced techniques for computation, combining functions and formulas with conditional or logical tests. Explore tables and their features, as well as learn to group data in other ways. Learn to protect the work while collaborating with others and exchanging data with other Windows programs. Also included is an introduction to scenarios and programming using macros.

What You'll Learn

Modify and customize how Excel 2013 looks and works, including the Quick Access Toolbar and Ribbon
Create and share workbooks using installed, online, and custom Office templates
Build advanced formulas by combining functions with conditional and logical tests
Apply statistical functions and connect formulas across worksheets and workbooks
Create, format, edit, sort, and filter tables, and handle duplicate data
Protect work while collaborating, exchange data with other Windows programs, and use scenarios and macros

Key Takeaways

The course focuses on advanced Excel 2013 features and does little review of basics.
It covers customizing the Excel interface, including the Start Screen, Quick Access Toolbar, and Ribbon.
It teaches advanced computation by combining functions and formulas with conditional or logical tests, plus statistical functions and formulas that connect worksheets and workbooks.
It explores tables, including creating, formatting, editing, sorting, filtering, and dealing with duplicate data.
It includes protecting work while collaborating, exchanging data with other Windows programs, and an introduction to scenarios and programming using macros.

Frequently Asked Questions

Is this course for Excel beginners?

No. The course explains advanced features of Microsoft Excel 2013 and does little review of basics, so it is aimed at learners who already know the fundamentals.

What formula and function topics does the course cover?

It covers reviewing and extending formula basics, conditional and logical functions, naming cells, formulas and constants, statistical functions, formulas that connect worksheets and workbooks, and fixing errors in formulas.

Does the course cover working with tables?

Yes. It covers creating a table with suitable data, formatting a table, freezing and unfreezing panes, editing, sorting, and filtering a table's data, and dealing with duplicate data.

Does the course teach automation or macros?

Yes. It includes an introduction to scenarios and to programming using macros.

Which Excel version does this course use?

The course is based on Microsoft's Excel 2013 software.