Tutorial on Narbonne Suite on Mac in excel

This paragraph outlines the process of managing sales data for the Narbone Suites Hotel chain. Eda Kinsman, the sales manager, uses multiple worksheets to summarize sales by state. The task involves breaking external links in worksheets so that the formulas in the specified range are replaced with static values. It also covers how to navigate between different worksheets and how to edit links to replace them with static data. The focus is on ensuring that the manager information worksheets are correctly updated and linked.

The second paragraph details the steps for creating and managing hyperlinks within a spreadsheet. It starts with removing a hyperlink from a cell while retaining the text. Then, it proceeds to instruct on creating a new hyperlink to an email address, including setting up a screen tip for clarity. Following that, another hyperlink is created, this time linking to a location listing, with specific instructions on setting the display text and screen tip. The paragraph also covers editing an existing hyperlink to the Narbone Suites website, emphasizing the importance of accurate display text and screen tips.

This section describes the process of applying consistent formatting to a group of worksheets. It starts with grouping the Idaho, Montana, and Oregon worksheets and then making several formatting updates. These include changing the font size, applying cell styles, bolding values, applying a specific number format, and resizing columns. The instructions also mention not to ungroup the worksheets after making these changes, ensuring that the formatting is uniform across the grouped sheets.

The fourth paragraph explains how to work with formulas and manage worksheets. It begins with creating a formula to total sales for a specific quarter and then copying this formula to other cells. The paragraph also covers ungrouping worksheets and verifying that the formatting and formulas are consistent across all worksheets. It proceeds with creating a copy of the Oregon worksheet for the Washington section, updating the worksheet name, and editing text and cell content as required.

This paragraph focuses on consolidating data from different regions into a single worksheet. It starts with switching to the Consolidated Sales worksheet and entering a formula that refers to a specific cell in another worksheet. The instructions include copying the formula without the formatting to other cells. It also involves using 3D references to total values from specific cells across worksheets and copying these formulas to other ranges. The paragraph concludes with creating defined names for certain ranges and applying these names to formulas in the Consolidated Sales worksheet.

The final paragraph describes the process of comparing yearly sales data and setting up external references. It begins with changing a defined name for a range to reflect 'Totals 2021'. The instructions then guide through opening a file with 2020 sales data and linking specific cells in the Consolidated Sales worksheet to cells in the 2020 data file. The process includes entering formulas to total values from the 2020 data and ensuring that the links are correctly established without breaking them. The paragraph concludes with a prompt to close the 2020 sales data file.