| Introduction |
|
1 | (6) |
|
|
|
1 | (1) |
|
|
|
2 | (1) |
|
Conventions Used in This Book |
|
|
3 | (2) |
|
|
|
5 | (1) |
|
|
|
5 | (1) |
|
|
|
5 | (2) |
| Book 1: Excel Basics |
|
7 | (68) |
|
Chapter 1 Excel: The 50-Cent Tour |
|
|
9 | (30) |
|
A Bird's-Eye View of Excel |
|
|
10 | (1) |
|
Checking Out Excel's Start Screen |
|
|
10 | (2) |
|
Getting Comfy with the Excel User Interface |
|
|
12 | (19) |
|
Going behind the scenes to Excel's Backstage view |
|
|
13 | (4) |
|
Ripping through the Ribbon |
|
|
17 | (5) |
|
Working with the Quick Access toolbar |
|
|
22 | (1) |
|
Fooling around with the Formula bar |
|
|
23 | (2) |
|
What's up with the Worksheet area? |
|
|
25 | (5) |
|
Taking a tour of the Status bar |
|
|
30 | (1) |
|
|
|
31 | (3) |
|
Show-and-tell help with the Search feature |
|
|
31 | (1) |
|
Getting Help from the Help tab on the Ribbon |
|
|
32 | (2) |
|
Launching and Quitting Excel |
|
|
34 | (5) |
|
Starting Excel from the Windows Start menu |
|
|
34 | (1) |
|
Starting Excel from the Windows Search text box |
|
|
35 | (1) |
|
Telling Cortana to Start Excel for you |
|
|
36 | (1) |
|
Starting Excel from the Windows Metro view in Tablet mode |
|
|
36 | (1) |
|
|
|
37 | (2) |
|
Chapter 2 Customizing Excel |
|
|
39 | (36) |
|
Tailoring the Quick Access Toolbar to Your Tastes |
|
|
40 | (3) |
|
Adding Ribbon commands to the Quick Access toolbar |
|
|
41 | (1) |
|
Adding non-Ribbon commands to the Quick Access toolbar |
|
|
42 | (1) |
|
|
|
43 | (25) |
|
Changing some of the more universal settings on the General tab |
|
|
44 | (3) |
|
Changing common calculation options on the Formulas tab |
|
|
47 | (3) |
|
Digging the options on the Data tab |
|
|
50 | (1) |
|
Changing correction options on the Proofing tab |
|
|
51 | (2) |
|
Changing save options on the Save tab |
|
|
53 | (3) |
|
Changing the Office language preferences |
|
|
56 | (1) |
|
Setting some accessibility options |
|
|
57 | (1) |
|
Changing a whole lot of other common options on the Advanced tab |
|
|
58 | (5) |
|
Customizing the Excel Ribbon |
|
|
63 | (5) |
|
|
|
68 | (2) |
|
Using Excel's Own Add-ins |
|
|
70 | (7) |
|
Managing the standard Excel Add-ins |
|
|
72 | (1) |
|
Managing Excel COM add-ins |
|
|
72 | (1) |
|
Purchasing third-party add-ins |
|
|
73 | (2) |
| Book 2: Worksheet Design |
|
75 | (216) |
|
Chapter 1 Building Worksheets |
|
|
77 | (54) |
|
|
|
78 | (8) |
|
|
|
78 | (6) |
|
Designing a workbook from scratch |
|
|
84 | (2) |
|
Getting to Know Excel's Data Types |
|
|
86 | (7) |
|
|
|
87 | (2) |
|
|
|
89 | (4) |
|
|
|
93 | (23) |
|
Data entry keyboard style |
|
|
94 | (2) |
|
Doing data entry with the Touch keyboard |
|
|
96 | (3) |
|
|
|
99 | (1) |
|
|
|
100 | (2) |
|
Constraining data entry to a cell range |
|
|
102 | (1) |
|
Getting Excel to put in the decimal point |
|
|
103 | (1) |
|
|
|
103 | (7) |
|
|
|
110 | (6) |
|
Linking to Other Documents |
|
|
116 | (7) |
|
|
|
116 | (1) |
|
|
|
117 | (3) |
|
|
|
120 | (1) |
|
|
|
120 | (1) |
|
Using the HYPERLINK Function |
|
|
121 | (2) |
|
|
|
123 | (6) |
|
Saving workbooks in other commonly used file formats |
|
|
126 | (1) |
|
Changing the default file location |
|
|
127 | (1) |
|
Saving a new workbook in the old file format |
|
|
128 | (1) |
|
Document Recovery to the Rescue |
|
|
129 | (2) |
|
Chapter 2 Formatting Worksheets |
|
|
131 | (56) |
|
Selecting Cells and Ranges |
|
|
132 | (9) |
|
Selecting cells with the mouse |
|
|
133 | (2) |
|
|
|
135 | (1) |
|
Selecting cells with the keyboard |
|
|
135 | (1) |
|
Selecting cells with AutoSelect |
|
|
136 | (2) |
|
Selecting cells with Go To |
|
|
138 | (1) |
|
|
|
139 | (2) |
|
Adjusting Columns and Rows |
|
|
141 | (4) |
|
Fitting the column to its contents automatically |
|
|
141 | (1) |
|
Adjusting columns the old-fashioned way |
|
|
142 | (1) |
|
Setting a new standard width |
|
|
143 | (1) |
|
Hiding out a column or two |
|
|
143 | (1) |
|
|
|
144 | (1) |
|
Formatting Tables from the Ribbon |
|
|
145 | (4) |
|
Formatting Tables with the Quick Analysis Tool |
|
|
149 | (1) |
|
Formatting Cells from the Ribbon |
|
|
150 | (2) |
|
Formatting Cell Ranges with the Mini-Toolbar |
|
|
152 | (2) |
|
Using the Format Cells Dialog Box |
|
|
154 | (19) |
|
|
|
154 | (8) |
|
|
|
162 | (4) |
|
|
|
166 | (3) |
|
Basic borders, fills, and patterns |
|
|
169 | (4) |
|
Hiring Out the Format Painter |
|
|
173 | (1) |
|
Easier Formatting with Cell Styles |
|
|
174 | (4) |
|
Using the Number Format cell styles |
|
|
174 | (2) |
|
Defining a custom cell style by example |
|
|
176 | (1) |
|
Creating a new cell style from scratch |
|
|
176 | (1) |
|
Merging styles into other workbooks |
|
|
177 | (1) |
|
Analyzing Data with Conditional Formatting |
|
|
178 | (9) |
|
Graphical conditional formatting |
|
|
179 | (1) |
|
Conditional formatting with the Quick Analysis tool |
|
|
180 | (1) |
|
Identifying particular values or text entries in a cell range |
|
|
181 | (3) |
|
Highlighting duplicate values in a cell range |
|
|
184 | (1) |
|
Creating your own conditional formatting rules |
|
|
184 | (2) |
|
Managing conditional formatting rules |
|
|
186 | (1) |
|
Chapter 3 Editing and Proofing Worksheets |
|
|
187 | (42) |
|
|
|
188 | (6) |
|
Using the Open screen in the Backstage view |
|
|
188 | (4) |
|
Opening more than one workbook at a time |
|
|
192 | (1) |
|
Finding misplaced workbooks |
|
|
192 | (1) |
|
Using the other Open options |
|
|
193 | (1) |
|
|
|
194 | (7) |
|
Changing your mind with Undo and Redo |
|
|
195 | (2) |
|
|
|
197 | (2) |
|
|
|
199 | (2) |
|
|
|
201 | (7) |
|
Zooming in and zooming back out again |
|
|
201 | (3) |
|
|
|
204 | (2) |
|
|
|
206 | (2) |
|
Copying and Moving Stuff Around |
|
|
208 | (10) |
|
Copying and moving with drag-and-drop |
|
|
209 | (1) |
|
Copying and moving with copy, cut, and paste |
|
|
210 | (8) |
|
Finding and Replacing Worksheet Data |
|
|
218 | (5) |
|
|
|
218 | (3) |
|
Finding and replacing data |
|
|
221 | (2) |
|
Getting It Right: Spell Checking Your Worksheets |
|
|
223 | (4) |
|
Changing the spelling options |
|
|
225 | (1) |
|
Adding words to the custom dictionary |
|
|
226 | (1) |
|
Looking Up and Translating Stuff |
|
|
227 | (1) |
|
|
|
227 | (2) |
|
Chapter 4 Managing Worksheets |
|
|
229 | (36) |
|
Reorganizing the Worksheet |
|
|
230 | (14) |
|
Being cautious when deleting and inserting columns and rows |
|
|
230 | (1) |
|
Deleting columns and rows |
|
|
231 | (1) |
|
Adding new columns and rows |
|
|
232 | (1) |
|
Splitting the worksheet into panes |
|
|
233 | (2) |
|
|
|
235 | (9) |
|
Reorganizing the Workbook |
|
|
244 | (11) |
|
|
|
245 | (1) |
|
|
|
245 | (2) |
|
|
|
247 | (1) |
|
|
|
248 | (1) |
|
|
|
248 | (1) |
|
Editing and formatting multiple worksheets as a group |
|
|
249 | (1) |
|
|
|
250 | (1) |
|
Opening windows on different sheets |
|
|
251 | (3) |
|
|
|
254 | (1) |
|
Working with Multiple Workbooks |
|
|
255 | (3) |
|
Comparing windows on different workbooks |
|
|
255 | (1) |
|
Transferring data between open windows |
|
|
256 | (1) |
|
Moving or copying sheets from one workbook to another |
|
|
256 | (2) |
|
|
|
258 | (7) |
|
Consolidating by position |
|
|
259 | (3) |
|
Consolidating by category |
|
|
262 | (1) |
|
Linking consolidated data |
|
|
263 | (2) |
|
Chapter 5 Printing Worksheets |
|
|
265 | (26) |
|
Printing from the Backstage View |
|
|
266 | (6) |
|
Selecting the printer to use |
|
|
268 | (1) |
|
|
|
269 | (3) |
|
Quick Printing the Worksheet |
|
|
272 | (1) |
|
Working with the Page Setup Options |
|
|
273 | (9) |
|
Using the buttons in the Page Setup group |
|
|
273 | (7) |
|
Using the buttons in the Scale to Fit group |
|
|
280 | (1) |
|
Using the Print options on the Sheet tab of the Page Setup dialog box |
|
|
281 | (1) |
|
|
|
282 | (6) |
|
Adding a ready-made header or footer |
|
|
282 | (2) |
|
Creating a custom header or footer |
|
|
284 | (4) |
|
Solving Page Break Problems |
|
|
288 | (2) |
|
Printing the Formulas in a Report |
|
|
290 | (1) |
| Book 3: Formulas And Functions |
|
291 | (148) |
|
Chapter 1 Building Basic Formulas |
|
|
293 | (44) |
|
Getting Started with Formulas |
|
|
294 | (11) |
|
Pointing at formula cells |
|
|
296 | (1) |
|
|
|
297 | (1) |
|
Using AutoSum to add numbers |
|
|
298 | (2) |
|
Using Quick Analysis to add numbers |
|
|
300 | (1) |
|
Building formulas with computational operators |
|
|
301 | (4) |
|
Augmenting Formulas with Worksheet Functions |
|
|
305 | (5) |
|
|
|
305 | (3) |
|
Entering function arguments |
|
|
308 | (2) |
|
|
|
310 | (6) |
|
Copying with relative cell references |
|
|
311 | (1) |
|
Copying with absolute references |
|
|
312 | (3) |
|
Copying with mixed cell references |
|
|
315 | (1) |
|
|
|
316 | (6) |
|
Creating an array formula |
|
|
318 | (2) |
|
Editing a dynamic array formula |
|
|
320 | (1) |
|
Building old-fashioned array formulas |
|
|
320 | (1) |
|
Editing an old-fashioned array formula |
|
|
321 | (1) |
|
|
|
322 | (10) |
|
Defining cell and range names |
|
|
323 | (2) |
|
Naming constants and formulas |
|
|
325 | (1) |
|
Using names in building formulas |
|
|
326 | (1) |
|
Creating names from column and row headings |
|
|
327 | (2) |
|
|
|
329 | (1) |
|
Applying names to existing formulas |
|
|
330 | (2) |
|
|
|
332 | (1) |
|
Controlling Formula Recalculation |
|
|
333 | (2) |
|
|
|
335 | (2) |
|
Chapter 2 Logical Functions and Error Trapping |
|
|
337 | (26) |
|
Understanding Error Values |
|
|
338 | (2) |
|
|
|
340 | (5) |
|
Getting to know the powerful IF function |
|
|
341 | (1) |
|
Evaluating the many talents of the IFS function |
|
|
342 | (2) |
|
Learning about the SWITCH function |
|
|
344 | (1) |
|
|
|
345 | (3) |
|
|
|
346 | (1) |
|
Upping your error-trapping game with ISERROR |
|
|
347 | (1) |
|
Whiting-Out Errors with Conditional Formatting |
|
|
348 | (1) |
|
Checking It Twice: Auditing Your Formulas |
|
|
349 | (12) |
|
|
|
351 | (3) |
|
|
|
354 | (1) |
|
|
|
355 | (2) |
|
Changing the Error Checking options |
|
|
357 | (1) |
|
|
|
358 | (2) |
|
|
|
360 | (1) |
|
Removing Errors from the Printout |
|
|
361 | (2) |
|
Chapter 3 Date and Time Formulas |
|
|
363 | (14) |
|
Understanding Dates and Times |
|
|
363 | (3) |
|
|
|
364 | (1) |
|
Building formulas that calculate elapsed dates |
|
|
364 | (1) |
|
Building formulas that calculate elapsed times |
|
|
365 | (1) |
|
|
|
366 | (8) |
|
|
|
366 | (1) |
|
|
|
367 | (1) |
|
DAY, WEEKDAY, MONTH, and YEAR |
|
|
368 | (1) |
|
|
|
369 | (1) |
|
Other useful Date functions |
|
|
370 | (4) |
|
|
|
374 | (3) |
|
|
|
374 | (1) |
|
|
|
375 | (1) |
|
|
|
376 | (1) |
|
Chapter 4 Finagling Financial Formulas |
|
|
377 | (16) |
|
Some Financial Function Basics Before You Begin |
|
|
378 | (1) |
|
The PV, NPV, and FV Functions |
|
|
379 | (3) |
|
Calculating the Present Value |
|
|
379 | (1) |
|
Calculating the Net Present Value |
|
|
380 | (1) |
|
Calculating the Future Value |
|
|
381 | (1) |
|
|
|
382 | (3) |
|
|
|
385 | (3) |
|
Excel's Advanced Financial Functions |
|
|
388 | (5) |
|
Chapter 5 Math and Statistical Formulas |
|
|
393 | (18) |
|
|
|
394 | (9) |
|
|
|
394 | (4) |
|
|
|
398 | (2) |
|
|
|
400 | (1) |
|
|
|
400 | (3) |
|
|
|
403 | (8) |
|
AVERAGE, MAX, MIN, and MEDIAN |
|
|
404 | (1) |
|
|
|
405 | (5) |
|
Using specialized statistical functions |
|
|
410 | (1) |
|
Chapter 6 Lookup, Information, and Text Formulas |
|
|
411 | (28) |
|
Looking Up Stuff with the Lookup Functions |
|
|
412 | (12) |
|
Modern lookups with XLOOKUP |
|
|
412 | (5) |
|
Old-fashioned lookups with VLOOKUP and HLOOKUP |
|
|
417 | (4) |
|
Performing an old-fashioned two-way lookup with MATCH and INDEX |
|
|
421 | (3) |
|
Getting Cell Reference Info with the Reference Functions |
|
|
424 | (3) |
|
Get the skinny on columns and rows |
|
|
425 | (1) |
|
|
|
426 | (1) |
|
|
|
427 | (5) |
|
Getting information about a cell |
|
|
427 | (3) |
|
|
|
430 | (1) |
|
|
|
431 | (1) |
|
Working with Text Functions and Formulas |
|
|
432 | (9) |
|
|
|
432 | (3) |
|
|
|
435 | (1) |
|
|
|
435 | (2) |
|
|
|
437 | (2) |
| Book 4: Worksheet Collaboration And Review |
|
439 | (62) |
|
Chapter 1 Protecting Workbooks and Worksheet Data |
|
|
441 | (20) |
|
Password-Protecting the Workbook |
|
|
442 | (5) |
|
Protecting the workbook when saving the file |
|
|
442 | (2) |
|
Assigning a password to open from the Info screen |
|
|
444 | (1) |
|
Entering the password to gain access |
|
|
445 | (1) |
|
Entering the password to make changes |
|
|
445 | (1) |
|
Changing or deleting a password |
|
|
446 | (1) |
|
Setting Up Worksheet Data Protection |
|
|
447 | (11) |
|
Changing a cell's Locked and Hidden Protection formatting |
|
|
448 | (1) |
|
|
|
449 | (3) |
|
Enabling cell range editing by certain users |
|
|
452 | (4) |
|
Doing data entry in the unlocked cells of a protected worksheet |
|
|
456 | (2) |
|
Protecting the Workbook Structure |
|
|
458 | (3) |
|
Chapter 2 Preparing a Workbook for Distribution |
|
|
461 | (14) |
|
Getting Your Workbook Ready for Review |
|
|
462 | (6) |
|
Adding properties to a workbook |
|
|
463 | (1) |
|
Digitally signing a document |
|
|
463 | (5) |
|
|
|
468 | (7) |
|
|
|
469 | (1) |
|
Displaying and hiding notes |
|
|
469 | (2) |
|
Marking up a worksheet with digital ink |
|
|
471 | (4) |
|
Chapter 3 Sharing Workbooks and Worksheet Data |
|
|
475 | (26) |
|
Sharing Your Workbooks Online |
|
|
476 | (4) |
|
Sharing a workbook saved on your OneDrive |
|
|
476 | (3) |
|
|
|
479 | (1) |
|
Sharing Your Workbooks via Email |
|
|
480 | (2) |
|
Emailing a copy of a workbook |
|
|
480 | (1) |
|
Emailing a workbook as a PDF file |
|
|
481 | (1) |
|
Sharing Excel Data with Office Programs |
|
|
482 | (7) |
|
Sharing data between Excel and Word |
|
|
483 | (5) |
|
Sharing data between Excel and PowerPoint |
|
|
488 | (1) |
|
Making Shared Workbooks Accessible |
|
|
489 | (4) |
|
Some useful accessibility guidelines and tweaks |
|
|
490 | (1) |
|
Adding alternative text to graphics |
|
|
491 | (1) |
|
Running the Accessibility Checker |
|
|
492 | (1) |
|
Exporting Workbooks to Other Usable File Formats |
|
|
493 | (5) |
|
Saving and exporting worksheets as PDF files |
|
|
494 | (1) |
|
Saving worksheets as XPS files |
|
|
495 | (1) |
|
Saving worksheets as ODS files |
|
|
496 | (1) |
|
Saving worksheets as HTML files |
|
|
496 | (2) |
|
Collaborating Conversationally with Comments |
|
|
498 | (5) |
|
|
|
498 | (1) |
|
Displaying and hiding comments |
|
|
499 | (1) |
|
|
|
499 | (1) |
|
|
|
500 | (1) |
|
|
|
500 | (1) |
| Book 5: Charts And Graphics |
|
501 | (60) |
|
Chapter 1 Charting Worksheet Data |
|
|
503 | (30) |
|
|
|
504 | (23) |
|
Embedded charts versus separate chart sheets |
|
|
505 | (1) |
|
Inserting recommended charts |
|
|
506 | (1) |
|
Inserting specific chart types from the Ribbon |
|
|
507 | (2) |
|
Inserting charts with the Quick Analysis tool |
|
|
509 | (1) |
|
Creating a chart on a separate chart sheet |
|
|
510 | (1) |
|
Refining the chart from the Chart Design tab |
|
|
511 | (4) |
|
Customizing chart elements from the Format tab |
|
|
515 | (1) |
|
Customizing the elements of a chart |
|
|
515 | (6) |
|
Formatting elements of a chart |
|
|
521 | (5) |
|
Saving a customized chart as a template |
|
|
526 | (1) |
|
Adding Sparkline Graphics to a Worksheet |
|
|
527 | (2) |
|
Adding Infographics to a Worksheet |
|
|
529 | (3) |
|
|
|
532 | (1) |
|
Chapter 2 Adding Graphic Objects |
|
|
533 | (28) |
|
Going Graphical: The Basics of Working with Graphic Objects |
|
|
534 | (8) |
|
|
|
535 | (1) |
|
Moving graphic objects to new layers |
|
|
536 | (2) |
|
|
|
538 | (1) |
|
|
|
539 | (2) |
|
Managing graphic objects in the Selection task pane |
|
|
541 | (1) |
|
Inserting Different Types of Graphics |
|
|
542 | (4) |
|
Inserting 2-D online images |
|
|
542 | (2) |
|
Inserting 3-D online images |
|
|
544 | (1) |
|
|
|
544 | (1) |
|
Inserting icons, stock images, and other ready-made graphics |
|
|
545 | (1) |
|
Making Changes to Graphics |
|
|
546 | (3) |
|
|
|
546 | (1) |
|
Formatting photos and line art pictures |
|
|
547 | (1) |
|
Formatting 3-D model images |
|
|
548 | (1) |
|
|
|
549 | (1) |
|
Drawing predefined shapes |
|
|
549 | (9) |
|
|
|
550 | (4) |
|
|
|
554 | (1) |
|
Inserting SmartArt graphics |
|
|
555 | (3) |
|
Adding Screenshots of the Windows Desktop |
|
|
558 | (1) |
|
|
|
558 | (3) |
| Book 6: Data Management |
|
561 | (56) |
|
Chapter 1 Building and Maintaining Tables |
|
|
563 | (20) |
|
|
|
564 | (10) |
|
Designing the basic table |
|
|
564 | (4) |
|
Add new records to a table |
|
|
568 | (5) |
|
Eliminating duplicate records |
|
|
573 | (1) |
|
|
|
574 | (6) |
|
Sorting records on a single field |
|
|
575 | (1) |
|
Sorting records on multiple fields |
|
|
575 | (3) |
|
Sorting a table on font and fill colors and cell icons |
|
|
578 | (2) |
|
|
|
580 | (3) |
|
Chapter 2 Filtering and Querying a Table |
|
|
583 | (34) |
|
|
|
584 | (16) |
|
|
|
584 | (9) |
|
Using the Advanced Filter |
|
|
593 | (7) |
|
Using the Database Functions |
|
|
600 | (2) |
|
|
|
602 | (17) |
|
Retrieving data from Access database tables |
|
|
605 | (3) |
|
Retrieving data from the web |
|
|
608 | (1) |
|
Retrieving data from text files |
|
|
609 | (4) |
|
Querying data from other data sources |
|
|
613 | (1) |
|
Transforming a data query in the Power Query Editor |
|
|
614 | (3) |
| Book 7: Data Analysis |
|
617 | (68) |
|
Chapter 1 Performing What-If Analysis |
|
|
619 | (22) |
|
|
|
620 | (6) |
|
Creating a one-variable data table |
|
|
621 | (3) |
|
Creating a two-variable data table |
|
|
624 | (2) |
|
Exploring Different Scenarios |
|
|
626 | (5) |
|
|
|
626 | (4) |
|
Producing a summary report |
|
|
630 | (1) |
|
|
|
631 | (2) |
|
|
|
633 | (8) |
|
Setting up and defining the problem |
|
|
634 | (2) |
|
|
|
636 | (1) |
|
|
|
637 | (2) |
|
Saving and loading a model problem |
|
|
639 | (1) |
|
|
|
640 | (1) |
|
Chapter 2 Performing Large-Scale Data Analysis |
|
|
641 | (44) |
|
|
|
642 | (9) |
|
Creating PivotTables with the Quick Analysis tool |
|
|
643 | (2) |
|
Creating recommended PivotTables |
|
|
645 | (1) |
|
Creating PivotTables manually |
|
|
646 | (5) |
|
|
|
651 | (5) |
|
Refining the PivotTable layout and style |
|
|
652 | (1) |
|
Formatting the parts of the PivotTable |
|
|
653 | (3) |
|
Sorting and Filtering the PivotTable Data |
|
|
656 | (5) |
|
|
|
656 | (1) |
|
Filtering individual Column and Row fields |
|
|
657 | (1) |
|
Slicing the PivotTable data |
|
|
658 | (1) |
|
|
|
659 | (2) |
|
|
|
661 | (1) |
|
|
|
661 | (5) |
|
Changing the summary functions |
|
|
662 | (2) |
|
|
|
664 | (1) |
|
Changing the PivotTable options |
|
|
665 | (1) |
|
|
|
666 | (3) |
|
Moving a PivotChart to its own sheet |
|
|
667 | (1) |
|
|
|
667 | (1) |
|
|
|
668 | (1) |
|
Using the Power Pivot Add-in |
|
|
669 | (7) |
|
Data modeling with Power Pivot |
|
|
670 | (2) |
|
Switching between the Data View and Diagram View |
|
|
672 | (2) |
|
Adding calculated columns courtesy of DAX |
|
|
674 | (2) |
|
Using the 3D Maps Feature |
|
|
676 | (5) |
|
Creating Forecast Worksheets |
|
|
681 | (4) |
| Book 8: Macros And VBA |
|
685 | (40) |
|
Chapter 1 Recording and Running Macros |
|
|
687 | (14) |
|
|
|
688 | (7) |
|
|
|
688 | (2) |
|
|
|
690 | (3) |
|
|
|
693 | (1) |
|
Saving your recorded macros in a macro-enabled workbook |
|
|
694 | (1) |
|
Assigning Macros to the Ribbon and the Quick Access Toolbar |
|
|
695 | (3) |
|
Adding your macros to a custom tab on the Ribbon |
|
|
695 | (2) |
|
Adding your macros to custom buttons on the Quick Access toolbar |
|
|
697 | (1) |
|
|
|
698 | (3) |
|
Chapter 2 VBA Programming |
|
|
701 | (24) |
|
Using the Visual Basic Editor |
|
|
702 | (13) |
|
|
|
704 | (9) |
|
Writing new macros in the Visual Basic Editor |
|
|
713 | (1) |
|
Running macros in the Visual Basic Editor |
|
|
714 | (1) |
|
Creating Custom Excel Functions |
|
|
715 | (10) |
|
Adding a description to a user-defined function |
|
|
717 | (1) |
|
Using a custom function in your worksheet |
|
|
718 | (1) |
|
Saving custom functions in add-in files |
|
|
719 | (6) |
| Index |
|
725 | |
Lisainfo e-raamatute kohta