Advanced formulas in Excel 2013 Overview

This section discusses the skill of creating Advanced formulas in Excel 2013, which is an mandatory skill needed to pass the Microsoft Office Specialist Expert exams for Microsoft Excel 2013. It is related with creation of sophisticated formulas. This chapter guides you in studying methods for these other operations, such as calculating dates and times, performing statistical or financial analysis, working with text strings, and looking up values. Excel 2013 includes a number of new functions designed to help you work more efficiently. Few of them are DAYS(), IFNA(), SHEETS(), SHEET(), XOR() etc.

These are the topics discuss in this chapter:

Look up data by using functions

Lookup functions are #data-mining minions. You use them to address tables of data, searching for a particular value to display ...
Read More

Apply advanced date and time functions

Date and time arithmetic has its own rules and syntax. In Excel (and in most modern computers), date and time ...
Read More

This chapter is a part of 77-427 Excel 2013 Expert Part One Prep course. More chapters in this course are

Excel 2013 Workbooks Management

Excel 2013 Workbooks Management Overview The skills tested in this section Excel 2013 Workbooks Management of the Microsoft Office Specialist Expert exams ...
Read More

Apply custom formats and layouts in Excel 2013

Apply custom formats and layouts in Excel 2013 Overview The skills tested in this section Apply custom formats and layouts in ...
Read More

Advanced formulas in Excel 2013

Advanced formulas in Excel 2013 Overview This section discusses the skill of creating Advanced formulas in Excel 2013, which is an ...
Read More

Create advanced charts and tables

Create advanced charts and tables Overview The skills tested in this section Create advanced charts and tables of the Microsoft Office ...
Read More

The Practice tests included in this course are:

No posts found.