Slide 501 [Counting the number of rows in a range (the month columns) that have no values in any cells, and that have a value in all cells.]

Slide 502 [Showing the INDIRECT function to use cell values that refer to worksheet tab names.]

Slide 503 [Using a Worksheet_Change event to force a negative number entry into specified ranges.]

Slide 504 [Summing incremental ranges that are comprised of several rows and columns.]

Slide 505 [Summing positive times only, and alternate methods for calculating and summing negative times only.]

Slide 506 [Using VLOOKUP to return sequential results from multiple lookup values.]

Slide 507 [Using a Worksheet_Change event to bypass a Data Validation Error Alert while accepting a specific value that is not allowed in the Source list.]

Slide 508 [Minimizing all Excel, and/or all open application windows, except for the subject Excel workbook.]

Slide 509 [Calculating Father's Day dates for future years, in America for this example.]

Slide 510 []

Slide 511 []

Slide 512 []

Slide 513 []

Slide 514 []

Slide 515 []

Slide 516 []

Slide 517 []

Slide 518 []

Slide 519 []

Slide 520 []

Slide 521 []

Slide 522 []

Slide 523 []

Slide 524 []

Slide 525 []

Slide 526 []

Slide 527 []

Slide 528 []

Slide 529 []

Slide 530 []

Slide 531 []

Slide 532 []

Slide 533 []

Slide 534 []

Slide 535 []

Slide 536 []

Slide 537 []

Slide 538 []

Slide 539 []

Slide 540 []

Slide 541 []

Slide 542 []

Slide 543 []

Slide 544 []

Slide 545 []

Slide 546 []

Slide 547 []

Slide 548 []

Slide 549 []

Slide 550 []

Slide 551 []

Slide 552 []

Slide 553 []

Slide 554 []

Slide 555 []

Slide 556 []

Slide 557 []

Slide 558 []

Slide 559 []

Slide 560 []

Slide 561 []

Slide 562 []

Slide 563 []

Slide 564 []

Slide 565 []

Slide 566 []

Slide 567 []

Slide 568 []

Slide 569 []

Slide 570 []

Slide 571 []

Slide 572 []

Slide 573 []

Slide 574 []

Slide 575 []

Slide 576 []

Slide 577 []

Slide 578 []

Slide 579 []

Slide 580 []

Slide 581 []

Slide 582 []

Slide 583 []

Slide 584 []

Slide 585 []

Slide 586 []

Slide 587 []

Slide 588 []

Slide 589 []

Slide 590 []

Slide 591 []

Slide 592 []

Slide 593 []

Slide 594 []

Slide 595 []

Slide 596 []

Slide 597 []

Slide 598 []

Slide 599 []

Slide 600 []