Workshop: Excel Part 2

Now that you have a the fundamentals down in Excel, it is time to push it further.

Target Student: This course builds upon the foundational knowledge presented in the Part 1 workshop and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence.

Learning Objectives: At the end of this workshop, the learner will be able to work with 3D formulas to use information from multiple sheets and/or workbooks, create range names to simplify identifying ranges and using in formulas, apply conditional formatting and styles to locate outliers, use paste special to selectively paste only specific aspects of copied data, share workbooks with others to collaborate, audit worksheets to assist with troubleshooting, organize large datasets using outlines and consolidate to combine data from multiple worksheets or workbooks into a single, summarized view.

Prerequisites: Familiarity using a personal computer including a mouse and keyboard, comfort working in the Windows environment, and Microsoft Excel Part 1, or equivalent knowledge.