SaraDaddy

Main » 2022 » December » 26 » Live Lessons Power Excel 2013 with Mr Excel

---

11:15:38 Live Lessons Power Excel 2013 with Mr Excel

Live Lessons Power Excel 2013 with Mr Excel Publisher : Live Lessons Language : English Duration : 8 Hours Release Date : 6 Mar. 2013 Size : 1,49 Gb You got Microsoft Excel 2013…now get these video lessons and master it faster and more easily than ever before! In 97 quick video lessons, Power Excel 2013 with MrExcel shows how to maximize your productivity Excel's best tools and shortcuts. Expert Bill Jelen simplifies powerful features including PivotTables, PowerPivot, Charting, Flash Fill, VLOOKUP, Combo Chart, Mail Merge, SmartArt, and more! Get more done faster with Excel Web App, the Quick Access Toolbar, and keyboard shortcuts…control and analyze data more effectively…communicate more visually with charting tools…and plenty more! Just watch: You’ll master high-powered Excel 2013 skills at your own pace–and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Excel 2013 fast–from novices to experienced power users. Table of Contents Introduction Introduction to Power Excel 2013 with MrExcel LiveLessons 00:02:19 Excel Interface Learning objectives 00:00:32 Sign in to Office 00:04:19 Start Screen 00:03:25 Dual Monitors 00:05:07 Flash Fill 00:06:14 Quick Analysis 00:04:07 Apps for Office 00:04:54 Ribbon Customizing 00:08:28 Keyboard Shortcuts 00:10:58 Page Layout View 00:06:13 Customize Future Workbooks 00:07:06 Copy Worksheets 00:03:59 Change All Worksheets 00:03:48 Create PDF 00:03:57 Finding Icons 00:04:11 Snow Blindness 00:06:19 Text Learning objectives 00:00:33 Fill Handle 00:09:10 Custom List 00:03:35 Joining Text 00:02:15 Rapid Formula Copy 00:03:00 Proper Case 00:02:12 Joining Dates 00:05:22 Formulas to Values 00:04:03 Breaking Apart Text 00:05:10 Formulas Learning objectives 00:00:39 AutoSum Tricks 00:03:55 Formula Auditing 00:07:11 Entering Formulas 00:04:12 Absolute Reference 00:04:43 Tables 00:04:39 Loan Calculations 00:04:34 Goal Seek 00:02:43 What-If Table 00:06:47 IF Formulas 00:10:10 VLOOKUP 00:10:48 Date & Time 00:11:28 Intersection 00:03:26 Coerce an Array 00:06:28 Sort & Filter Learning objectives 00:00:40 Data Preparation 00:03:35 One-Click Sorting 00:03:10 Sort by Color 00:02:50 Sort by Weekday 00:03:04 Rearranging Columns 00:02:39 Sort with a Formula 00:05:25 Filter by Selection 00:04:11 Filtering 00:03:55 Remove Duplicates 00:05:13 Subtotals Learning objectives 00:00:36 Subtotals 00:03:13 Collapsing Subtotals 00:01:26 Copy Subtotals 00:03:44 Formatting Subtotals 00:02:16 Sorting Subtotals 00:02:30 Count, Last 00:07:12 Grouping 00:02:03 Data Consolidate 00:03:51 Pivot Learning objectives 00:00:44 Creating a Pivot Table 00:05:12 Changing a Pivot Table 00:03:39 Pivot Gotchas 00:07:46 Pivot Formatting 00:06:12 Drill Down 00:04:06 Pivot Calculations 00:11:02 Summarizing Dates 00:05:17 Pivot Sorting 00:03:41 Filtering Row Fields 00:02:08 Top 10 Report 00:05:21 Filtering with Slicers 00:07:41 Multiple Pivots, One Slicer 00:05:48 50 Reports in 5 Seconds 00:03:01 New Cache 00:02:52 Frequency Chart 00:02:45 Compare 2 Lists 00:03:42 Perfect Formatting 00:06:14 PowerPivot Learning objectives 00:00:48 Data Model 00:04:51 PowerPivot 00:06:32 Grid Calculations 00:05:42 Calendar Table 00:05:02 Calculated Fields 00:08:15 Power View 00:09:53 Charting Learning objectives 00:00:57 Recommended Charts 00:05:55 Formatting Chart 00:08:18 Data Labels 00:05:32 Combo Charts 00:02:16 Scatter Charts 00:04:07 Saving Template 00:02:26 Sparklines 00:04:15 Labeling Sparklines 00:05:45 Color Scales, Icon Sets, Data Bars 00:06:55 Creating SmartArt 00:04:15 SmartArt Formulas 00:04:09 Tips & Tricks Learning objectives 00:00:36 Turn Data 00:03:09 Choose from List 00:02:22 Cell Tooltips 00:03:00 Mail Merge 00:02:10 Talk with Excel 00:03:10 Excel Web App Learning objectives 00:01:13 Web Data 00:04:31 Publish to Web 00:05:13 Embed in Webpage 00:02:47 Excel Button 00:03:05 Surveys 00:04:23 Introduction Summary of Power Excel 2013 with MrExcel LiveLessons 00:01:07 https://www.filefactory.com/file/74oksqtuie0v/

1 2 3 4 5 Category: VIDEO TUTORIALS | Views: 67 | Added by: saradaddy | Rating: 5.0/1

Total comments: 0