This posting was contains fundamentals, shortcuts, tips, and techniques that are essential when working with Formulas & Functions. It includes the following sections:
Inserting, Editing, & Copying Formulas, : This section covers easy techniques on inserting, editing, and copying formulas, understanding the correct use of relative/absolute references, and creating power formulas.
Selecting, Displaying, Printing & Pasting Formulas, : In this section you will find techniques on displaying formula syntax, displaying formulas and values, selecting cells containing formulas, pasting values, adding comments to formulas, and printing formula syntax.
Array Formulas, : This section provides an explanation of the concept of an Array and how Excel uses Arrays in formulas, You will also learn how to create an Array formula.
Using Range Names in Formulas, : In this section, learn about range name rules, how to define range names, and how to use range Names in formulas.
Auditing Formulas, : In this section, find essential shortcuts and techniques on tracing and moving between precedent and dependent cells, stepping into formulas, and tracing errors in a formula.
Protecting Formulas, : In this section, you will learn how to protect formulas in both protected and unprotected sheets.
Inserting, Editing, & Copying Formulas, : This section covers easy techniques on inserting, editing, and copying formulas, understanding the correct use of relative/absolute references, and creating power formulas.
Selecting, Displaying, Printing & Pasting Formulas, : In this section you will find techniques on displaying formula syntax, displaying formulas and values, selecting cells containing formulas, pasting values, adding comments to formulas, and printing formula syntax.
Array Formulas, : This section provides an explanation of the concept of an Array and how Excel uses Arrays in formulas, You will also learn how to create an Array formula.
Using Range Names in Formulas, : In this section, learn about range name rules, how to define range names, and how to use range Names in formulas.
Auditing Formulas, : In this section, find essential shortcuts and techniques on tracing and moving between precedent and dependent cells, stepping into formulas, and tracing errors in a formula.
Protecting Formulas, : In this section, you will learn how to protect formulas in both protected and unprotected sheets.
EmoticonEmoticon