Excel 2013 Tips & Tricks: Time Saving Questions Answered Год выпуска: 2015 Производитель: Udemy Сайт производителя: udemy.com Автор: IsaBel Harrison Продолжительность: 4:32 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: 1. Would you like to increase your productivity in Excel without committing a great deal of time? 2. Would you like to improve your skills, workbooks, and lessen the time you spend in front of your computer? 3. Do you have a feeling that there is a faster way to use Excel, you just need to know how? If you answered "yes" to at least one of these questions then this course is for you! This course is designed to save you time, and help you become more productive in Excel 2013. Научитесь работать в Экселе более продуктивно.
Содержание
Section 1: Welcome So many questions Section 2: Navigation, Workbook Environment, & Worksheet Tips Customizing the Ribbon Customizing the Quick Access Toolbar Selecting Cells & Ranges Moving & Copying Cells Copying Multiple Items to Office Clipboard Quickly Navigate to Worksheets Named Ranges for Navigation Fill Series Freeze Panes Splitting Data Into Multiple Columns Tracking Changes Grouping Worksheets to Quickly Add Data Copying and Renaming a Worksheet Changing a Worksheet Tab Color Entering the Current Date and Time Useful Keyboard Shortcuts: Function Keys - 2 pages Useful Keyboard Shortcuts: CTRL + - 2 pages Useful Keyboard Shortcuts: ALT keys - KeyTips AutoCorrect Creating Forms Using the Form Command The Camera Changing the Shapes of Comments Section 3: Useful Tips on Formulas & Functions 3D Formulas Absolute Reference Named Ranges in Formulas SumIf SumIfs DSum VLookup IfError Left, Right, Mid Find Rank Showing and Printing Formulas Section 4: Using Data Validation for Data Entry Creating Drop-Down Lists Dependent Drop-Down Lists Character Limits for Cells Creating Custom Input Messages and Error Alerts Section 5: Special, Custom, and Conditional Formatting Midway Check-In Special Number Formats: Phone Numbers, Social Security Numbers, and Zip Codes Custom Number Formatting: Explained Custom Number Formatting: Examples Conditional Formatting Conditional Formatting with Quick Analysis Conditional Formatting to Just Show Icons or Bars Find & Replace with Formatting Section 6: Tables & Lists Creating Tables Filtering with Slicers Sorting by Custom Lists Transposing Data Subtotals Section 7: Charts Keyboard Shortcut & Quick Analysis Quick Formatting Exploding Pie Charts Sparklines Combination Charts – Secondary Axis Copy a Chart to Word or PowerPoint Section 8: PivotTables & PivotCharts PivotTables & PivotCharts Overview Creating PivotTables Creating PivotCharts Slicers Timelines Section 9: Printing Print Titles: Repeat Headings on Each Page Setting a Print Area Fitting Everything On One Page Page Breaks Hiding Errors Watermarks Section 10: Protecting Files Protecting Formula and Function Cells Allowing Users to Edit Only Portions of the Spreadsheet Protect a Workbook’s Structure Password Protecting a Workbook Section 11: Macros Creating a macro Assigning the macro to a button Assigning the Macro to the Quick Access Toolbar Macro Example: Creating Buttons to Navigate Between Worksheets Simple Macro Maintenance Section 12: Wrap Up! Thank you
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
