Excel Managing Sheets & Summaries

In this course, we will explore the essential skills needed to effectively manage multiple worksheets and workbooks in Microsoft Excel. As your data grows and becomes more complex, it's crucial to have the knowledge to organize and link information across various sheets and workbooks. We will delve into techniques for working with multiple worksheets, allowing you to navigate, rearrange, and consolidate data effortlessly. You will learn how to create linked formulas that dynamically update data across sheets and workbooks, ensuring accuracy and efficiency in your calculations. Additionally, we will explore Macros, empowering you to automate repetitive tasks and enhance your productivity. Furthermore, we will dive into the world of hyperlinks, enabling you to create interactive spreadsheets that facilitate easy navigation and quick access to relevant information. By the end of this class, you will have the skills to efficiently manage and summarize data across multiple sheets and workbooks, saving you time and increasing your efficiency in Excel. Get ready to master the art of managing sheets and creating powerful summaries that will elevate your data management and analysis capabilities to new heights.

Working with Multiple Worksheets and Workbooks

• Renaming and Color-coding Worksheets
  
• Grouping Spreadsheets
  
• Moving or Copying sheets
  
• Viewing Multiple Worksheets
  
• Viewing Worksheets in Different Workbooks
  

Creating Linked Formulas

• Creating Linked Formulas between Workbooks
  
• Using 3-D References
  

Macros

• Recording and running
  
• Creating a macro button
  
• Adding custom menu to a toolbar
  
• Assign a macro to a custom menu
  

Hyperlinks

Combine Multiple Sheets into One Master Sheet