پیشنهاد فرادرس

آموزش پیشرفته Excel 2013

دسته بندی ها: آموزش اکسل ، آموزش آفیس ، آموزش های LiveLessons

آموزش-پیشرفته-excel-2013

دوره آموزش پیشرفته Excel به درخواست کاربران برای شما آماده شده است.

این دوره محصول LiveLessons است و مباحث پیشرفته در Microsoft Excel را آموزش می دهد.

با توجه به اینکه سطح این آموزش پیشرفته است اما باز هم تمام مباحث Excel را پوشش نمی دهد و در آینده حداقل 20 دوره پیشرفته در این زمینه در سایت قرار خواهد گرفت.

سرفصل های دوره آموزشی:

  • میانبرهای صفحه کلید در Excel
  • طرح بندی صفحه نمایش
  • تبدیل کردن به Proper Case
  • جداول و فرمول های جدول
  • عملکردهای درحال مشاهده مانند PMT
  • فرمول آرایه برای محدوده تاریخ
  • تقاطع ضمنی
  • آماده سازی داده ها
  • مرتب سازی تنها با یک کلیک
  • دسته بندی بر اساس رنگ
  • دسته بندی بر اساس روز هفته
  • مرتب سازی بر اساس فرمول
  • حذف موارد تکراری
  • سقوط Subtotals
  • کپی Subtotals
  • قالب Subtotals
  • مرتب سازی Subtotals
  • ایجاد یک Pivot Table
  • تغییر Pivot Table
  • محاسبات محوری
  • استفاده از GetPivot
  • محاسبات در شبکه
  • زمینه های محاسبه
  • تاریخ دو جدول درمدل داده
  • ایجاد یک نمودار پیشنهادی
  • ابزارهای قالب بندی یک نمودار

ليست سرفصل هاي اين دوره آموزشي:

Lesson 1
Part I: Excel Interface, Downloadable Version
Part I: Excel Interface
Explore the 15 lessons in this section and in less than an hour and a half you’ll be comfortable Flash Filling and performing Quick Analysis without breaking a sweat.  Lessons include:
1 Sign-in to Office: The Account Page, Saving to the Cloud
2 Start Screen, Open Screen, Recent Documents
3 Excel on Two Screens, Window Arrange
4 Flash Fill
5 Quick Analysis
6 Apps for Office
7 Customizing Ribbon and QAT
8 Keyboard Shortcuts
9 Page Layout View
10 Customize All Future Workbooks
11 Copy Worksheets
12 Change All Worksheets
13 Saving Workbook to PDF
14 Finding Icons
15 Snow Blindness

Lesson 2 Part II: Text, Downloadable Version Part II: Text For the next 34 minutes, you will cover these eight lessons for text in spreadsheets: 16 Drag the Fill Handle to Extend a Series 17 Create Your Own Series 18 Joining Text 19 Rapid Formula Copy 20 Convert to Proper Case 21 Joining Dates 22 Converting Formulas to Values 23 Breaking Apart Text

Lesson 3 Part III: Formulas, Downloadable Version Part III: Formulas These 13 lessons are lucky for you! You’ll spend less than 90 minutes learning terrific tricks of the formula trade. Lessons include: 24 AutoSum Tricks 25 Formula Auditing 26 Three Ways of Entering Formulas 27 Relative Versus Absolute Formulas 28 Tables and Table Formulas 29 Discovering Functions such as PMT 30 Goal Seek 31 What-If with Data Table 32 IF Formulas, including IFERROR & SUMIFS 33 VLOOKUP 34 Date and Time, including time in excess of 24 hours, format as Qtr, NETWORKDAYS 35 Implicit Intersection 36 Array formula for date range

Lesson 4 Part IV: Sort & Filter, Downloadable Version Part IV: Sort & Filter These 9 lessons will cover the basics of sorting and filtering data in your spreadsheets. Just over 30 minutes for the following lessons: 37 Data Preparation 38 One-Click Sorting 39 Sorting by Color 40 Sorting by Weekday 41 Rearranging Columns 42 Sort with a Formula 43 Filter by Selection, plus ad-hoc totals 44 Other ways to Filter 45 Remove Duplicates

Lesson 5 Part V: Subtotals, Downloadable Version Part V: Subtotals Who knew there was so much to learn about subtotals! In less than 30 minutes, these eight lessons will show you what you’ve been missing! 46 Subtotals 47 Collapsing Subtotals 48 Copy Subtotals 49 Formatting Subtotals 50 Sorting Subtotals 51 Changing Sum to Count in 1 column 52 Manual Grouping 53 Data Consolidate

Lesson 6 Part VI: Pivot Tables, Downloadable Version Part VI: Pivot Tables Probably the single most important feature of Excel covered in these 17 lessons. In less than two hours you’ll learn sweet skills that will make you the go-to person for cool spreadsheets! 54 Creating a Pivot Table 55 Changing a Pivot Table 56 Pivot Gotchas 57 Pivot Formatting, including Tabular & Repeat Item Labels 58 Drill Down 59 Pivot Calculations, Including % of Parent Row 60 Summarizing Dates, add Year-over-Year 61 Pivot Sorting 62 Filtering Row Fields 63 Top 10 Report, 4 Ways, including AutoFilter and Data Model 64 Filtering a Pivot Table with Slicers and Timelines 65 Pivot Tables - Slicers on Two Pivot Tables 66 50 Reports in 5 Seconds 67 Base on a table, force a new cache 68 Frequency Chart 69 Matching Two Lists 70 Using GetPivot Data

Lesson 7 Part VII: Power Pivot, Downloadable Version Part VII: Power Pivot These six super cool lessons explore the power behind Power Pivot, the data mashup tool. Take 40 minutes and check it out! 71 Join two tables in the data model 72 Join two tables in PowerPivot 73 Calculations in the Grid 74 Date Table in PowerPivot 75 Calculated Fields 76 Power View

Lesson 8 Part VIII: Charting, Downloadable Version Part VIII: Charting Visualize the data hidden in those rows and columns with Charts that look stunning! In under an hour you’ll master the tricks of the Excel master with these 11 lessons: 77 Creating a Recommended Chart 78 Tools for Formatting a Chart 79 Chart Data Labels 80 New Combo Chart to Chart Different Orders of Magnitude 81 Scatter Charts and Paste Special 82 Saving Favorite Chart Settings 83 Add : Sparklines 1 84 Add: Labeling Sparklines 85 Color Scales, Icon Sets, Data Bars 86 Creating SmartArt 87 Smart Art Formulas

Lesson 9 Part IX: Tips & Tricks, Downloadable Version Part IX: Tips & Tricks Five of the absolute coolest tips and tricks out there! See what you have been missing in just 15 minutes: 88 Turn Data 89 Choose from a List 90 ToolTips for a Cell 91 Mail Merge 92 Have a Talk with Excel

Lesson 10 Part X: Excel Web App, Downloadable Version Part X: Excel Web App In less than 20 minutes you’ll get the swing of the Excel Web App thing! The five lessons include: 93 Web Data Functions (EncodeURL, Webservice, FilterXML) 94 Saving Workbook to Excel Web App, Share Via Twitter 95 Embedding in a web page or blog 96 Excel Button 97 Surveys

حجم فايل: 1.70GB

آیا این نوشته را دوست داشتید؟
LiveLessons Power Excel 2013 with MrExcel

پیشنهاد فرادرس