Excel for Intermediate Users - The Complete Course

This paragraph introduces the viewer to an intermediate-level Excel course, emphasizing the importance of building upon beginner skills. It references a previous beginner course and encourages the viewer to watch it for foundational knowledge. The speaker then transitions into discussing how to manage large worksheets in Excel, highlighting the challenges of understanding and digesting data as the spreadsheet grows.

The speaker explains various zoom options in Excel, such as percentage zoom, custom zoom, and the 'Fit to Selection' feature. They demonstrate how to use the zoom slider in the status bar and the 'Zoom to Selection' button for a focused view of specific data ranges. The paragraph also introduces the 'Split' feature, which allows users to divide the worksheet into separate viewing areas, enhancing the ability to compare and analyze data effectively.

This section discusses the 'Freeze Panes' feature, which keeps specific rows or columns visible while scrolling through a large spreadsheet. The speaker shows how to freeze the top row or the first column, and also how to freeze multiple rows or columns simultaneously. They emphasize the importance of this feature for maintaining visibility of key data points, such as headers or employee IDs, while working with extensive datasets.

The speaker covers how to add, rename, and reorder worksheets within a workbook. They demonstrate the process of inserting new sheets, renaming existing ones, and adjusting their order. The paragraph also touches on the usefulness of naming sheets for better organization and understanding of the data they contain. Additionally, the speaker reviews how to name cells, ranges, formulas, and constants for easier data manipulation and reference.

In this part, the speaker teaches how to quickly insert the current date and time into a worksheet using keyboard shortcuts. They explain the process of entering today's date by pressing Ctrl + ; and the time by pressing Ctrl + Shift + ;. The speaker also discusses the importance of recording when a spreadsheet was last edited, especially when collaborating with others.

The speaker delves into techniques for working with multiple worksheets and workbooks simultaneously. They demonstrate how to switch between sheets using keyboard shortcuts and how to edit the same cell across multiple sheets at once. The paragraph also covers opening and arranging multiple windows of an Excel workbook, allowing for side-by-side comparison and data transfer between similar spreadsheets.

This section focuses on linking data between different workbooks. The speaker shows how to copy data from one workbook to another and how to establish a link between two workbooks to pull data from one into another. They also discuss the implications of linking, such as the automatic update of links and the security warning that appears when opening a workbook with linked data.

The speaker reviews the process of creating charts in Excel, including selecting data, choosing chart types, and customizing chart elements. They discuss the 'Recommended Charts' feature and the ability to switch between different chart styles. The paragraph also covers how to edit chart titles, adjust axis settings, and format various elements of the chart for clarity and visual appeal.

This paragraph introduces the use of SmartArt, text boxes, and shapes to enhance spreadsheets. The speaker demonstrates how to insert and customize organization charts, lists, and other graphical elements. They also show how to insert images, text boxes, and word art directly onto a chart or worksheet, adding a layer of interactivity and visual interest to the data presentation.

The speaker explains how to use data forms for adding, finding, and editing records in a list. They show how to access the data form feature, add new records, and use criteria to search for specific entries. The paragraph also covers sorting data by different levels, such as sorting by employee name and then by hours worked, and filtering data using various criteria.

This section focuses on using comments, notes, and Excel's auditing tools. The speaker demonstrates how to add comments and notes to cells for communication and reminders. They also discuss the watch window feature for monitoring changes in specific cells or ranges, and how to use formula auditing tools like tracing precedence and dependents to identify errors and understand the impact of changes.

The speaker concludes the course by discussing advanced printing options, such as setting margins, changing paper orientation, and specifying the print area. They also cover page break options, including inserting, removing, and previewing page breaks. The paragraph ends with a mention of printing formulas instead of their results, providing a comprehensive overview of Excel's printing capabilities.