3: Structuring and Referencing Data for Analysis within Excel
Learning objectives
3: Structuring and Referencing Data for Analysis within Excel
Learning objectives - Video Tutorials & Practice Problems
Video duration:
1m
Play a video:
<v ->Before we start preparing data for analysis and reports,</v> it is important to review some relevant Excel concepts related to structuring and referencing our data within Excel. These skills will enhance our productivity within Excel and will assist in developing more efficient reliable, sustainable, and reusable Excel models. During this lesson, we will review the two cell reference styles for Excel, discuss the importance of absolute and relative cell reference types, learn how to better manage cell references using named ranges, review Excel tables and the use of structure references to access their data within formulas. We will highlight the difference between formulas and functions and discuss options to check function compatibility across various Excel versions. Next, we will examine the newly introduced dynamic array capability within Excel for Microsoft 365, and the use of implicit intersection behavior. With dynamic arrays. Finally, we will incorporate the concepts learned in this lesson into a relatively simple data analysis solution. For your convenience, these topics are listed as individual sub-lessons so you can easily navigate or skip as per your comfort level. So let's begin.