Working With Formulas in Excel

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.