Formulas - Lesson 81 Date and Time скачать в хорошем качестве

Formulas - Lesson 81 Date and Time

Power Excel Lessons Table of Contents: Part 1: Excel 2007 Interface • Lesson 1: Introducing the Ribbon • Lesson 2: Quick Access Toolbar • Lesson 3: Finding Icons • Lesson 4: Keyboard Shortcuts • Lesson 5: Mini Toolbar and Live Preview • Lesson 6: Zoom Slider and Page Layout • Lesson 7: Recent Documents • Lesson 8: Save as PDF • Lesson 9: Excel Options • Lesson 10: Opening Templates, Closing Excel Part 2: Excel 2007 New Features • Lesson 11: Unlocking the Big Grid • Lesson 12: Cell Styles and Document Themes • Lesson 13: Data Visualizations • Lesson 14: Tables and Table Formulas • Lesson 15: Sort and Filter by Color • Lesson 16: Duplicates • Lesson 17: Picture Tools and WordArt • Lesson 18: Other New Features Part 3: Text • Lesson 19: Drag the Fill Handle to Extend a Series • Lesson 20: Create Your Own Series • Lesson 21: Joining Text • Lesson 22: Rapid Formula Copy • Lesson 23: Convert to Proper Case • Lesson 24: Joining Dates • Lesson 25: Converting Formulas to Values • Lesson 26: Breaking Apart Text • Lesson 27: Parsing Fixed Width Part 4: Excel Customizations • Lesson 28: Data Entry Tricks • Lesson 29: Customize All Future Workbooks • Lesson 30: Copy Worksheets • Lesson 31: Change All Worksheets • Lesson 32: Arranging Windows Part 5: Sorting & Subtotals • Lesson 33: Data Preparation • Lesson 34: Sorting Basics • Lesson 35: Random Sort • Lesson 36: Sorting by Weekday • Lesson 37: Rearranging Columns • Lesson 38: Subtotals • Lesson 39: Collapsing Subtotals • Lesson 40: Copy Subtotals • Lesson 41: Formatting Subtotals • Lesson 42: Multiple Subtotals • Lesson 43: Filling in Data on Subtotal Rows • Lesson 44: Subtotal Tricks Part 6: Pivot Tables • Lesson 45: Creating a Pivot Table • Lesson 46: Changing a Pivot Table • Lesson 47: Pivot Gotchas • Lesson 48: Pivot Sorting • Lesson 49: Drill Down • Lesson 50: Summarizing Dates • Lesson 51: Top 10 Report • Lesson 52: Pivot Calculations • Lesson 53: Pivot Formatting • Lesson 54: Unique List • Lesson 55: Ad-Hoc Queries • Lesson 56: New Filtering Options • Lesson 57: 50 Reports in 5 Seconds • Lesson 58: Pivot Compatibility with 2003 • Lesson 59: Making Reports Pivotable Part 7: Charting and SmartArt • Lesson 60: Creating and Formatting a Chart • Lesson 61: Adding or Removing Chart Data • Lesson 62: Interactive Chart • Lesson 63: Charting Differing Orders of Magnitude • Lesson 64: Pie Chart Tricks • Lesson 65: XY and Bubble Charts • Lesson 66: Saving Favorite Chart Settings • Lesson 67: Creating SmartArt • Lesson 68: Smart Art Formulas Part 8: Formulas • Lesson 69: AutoSum Tricks • Lesson 70: Formula Auditing • Lesson 71: Three Ways of Entering Formulas • Lesson 72: Relative Versus Absolute Formulas • Lesson 73: Discovering Functions • Lesson 74: Goal Seek • Lesson 75: Unusual Functions • Lesson 76: IF Formulas • Lesson 77: VLOOKUP • Lesson 78: IFERROR • Lesson 79: SUMIFS • Lesson 80: Super Formulas • Lesson 81: Date and Time Part 9: Macros • Lesson 82: Recording a Macro • Lesson 83: Recording Navigation • Lesson 84: How Many Rows • Lesson 85: Event Macros Part: 10 Tips & Tricks • Lesson 86: Finding Records with Filter • Lesson 87: Web Queries • Lesson 88: Copying Column Widths • Lesson 89: Page Numbering • Lesson 90: Turn Data • Lesson 91: & in Header • Lesson 92: Choose from a List • Lesson 93: ToolTips for a Cell • Lesson 94: Word Processing in Excel • Lesson 95: Have a Talk with Excel