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 []
