PC World - USA (2020-03)

MARCH 2020 PCWorld 121 E xcel macros are like mini- programs that perform repetitive tasks, saving you a lot of time and typing. ...

122 PCWorld MARCH 2020 HERE’S HOW HOW TO CREATE EXCEL MACROS Use the directional keys to navigate: Up, Down, Right, Left, End, ...

MARCH 2020 PCWorld 123 Enter this date formula in cell A1: =Today(). Now this cell always displays today’s date. Be sure; howev ...

124 PCWorld MARCH 2020 HERE’S HOW HOW TO CREATE EXCEL MACROS pcworld.com/pivt). Normally, the Product Description resides in co ...

MARCH 2020 PCWorld 125 F4: =SUM(E410%), the current discount percentage in your store, then copy from F4 down to F5:E500 G4: =SU ...

126 PCWorld MARCH 2020 HERE’S HOW HOW TO CREATE EXCEL MACROS the Master. The Master is the spreadsheet for the combined totals o ...

MARCH 2020 PCWorld 127 arrow beside the To Books field box. Select “MasterDB.xlsx” from the list. In the second dialog: Before ...

128 PCWorld MARCH 2020 HERE’S HOW HOW TO CREATE EXCEL MACROS T+ M+ R. Save the Master file, then save the BostonDB file. Go bac ...

MARCH 2020 PCWorld 129 do it manually. Excel actually provides a way to modify all your spreadsheets at once, but this task is u ...

130 PCWorld MARCH 2020 HERE’S HOW HOW TO CREATE EXCEL MACROS course, because you are calculating all the values in cell C2 from ...

MARCH 2020 PCWorld 131 displaying all the macros saved to the “All Open Workbooks” area. Locate your macro, click to select, th ...

132 PCWorld MARCH 2020 HERE’S HOW HOW TO CREATE EXCEL MACROS Select Range E13 With Selection (format as follows) .HorizontalAlig ...

MARCH 2020 PCWorld 133 I n Microsoft Word, templates are pre-designed documents that you or someone else (such as Microsoft) cre ...

134 PCWorld MARCH 2020 HERE’S HOW HOW TO USE TEMPLATES IN WORD number, and email address. Others, such as business reports or br ...

MARCH 2020 PCWorld 135 Save the document as a template. MODIFY A MICROSOFT WORD TEMPLATE You can change the colors, font, photos ...

136 PCWorld MARCH 2020 HERE’S HOW HOW TO USE TEMPLATES IN WORD Ctrl+ S. It will save in the same location. Next, fill in all th ...

MARCH 2020 PCWorld 137 photos from your Pictures Library. Adding images gives you an opportunity to eyeball image sizes and colu ...

138 PCWorld MARCH 2020 HERE’S HOW HOW TO USE TEMPLATES IN WORD originators of a large banking institution have a meeting at one ...

MARCH 2020 PCWorld 139 TEMPLATE TIPS: CREATE CUSTOM STYLESHEETS The default stylesheet in MS Word is called normal.dotx. It’s no ...

140 PCWorld MARCH 2020 HERE’S HOW HOW TO USE TEMPLATES IN WORD Brown, Alignment such as Justify, Spacing such as 1.15, and Inden ...