در این آموزش تصویری با نحوه کار با Excel 2013 آشنا می شوید.

این دوره می تواند کاربران مبتدی اکسل را به سمت حرفه ای شدن راهنمایی کند.

این دوره آموزشی محصول موسسه Udemy است.

سرفصل های دوره:

  • کار با توابع متنی
  • نحوه ویرایش فایل ها
  • استفاده از تابع TRIM
  • نحوه تغییر متن
  • کار با تابع MID
  • کار با تابع CONCATENATE
  • کار با توابع شرطی
  • کار با دستور IF
  • کار با تابع IFERROR
  • کار با تابع COUNTIF
  • کار با تابع SUMIF
  • استفاده از INDEX و MATCH
  • کار با توابع تاریخ و زمان
  • نحوه وارد کردن تاریخ
  • کار با تابع NETWORKDAYS
  • نحوه قالب بندی پیشرفته برنامه
  • نحوه چیدمان متنی
  • نحوه قالب بندی شرطی
  • کار با نمودارها
  • ساخت جدول در اکسل
  • ایجاد یک نمودار ستونی
  • ایجاد یک نمودار خطی
  • ایجاد یک نمودار دایره ای
  • نحوه ایجاد sparklines
  • کار با فرمول ها
  • کار با جداول
  • مزایای استفاده از جداول
  • وارد کردن داده ها به جدول
  • ساخت نمودار های پویا
  • نحوه مرتب سازی داده ها
  • مرتب سازی بر اساس ستون
  • مرتب سازی داده ها به صورت تصادفی
  • استفاده از فیلتر متنی
  • استفاده از فیلتر تاریخ
  • کار با داده های چند سطحی
  • ایجاد یک جدول محوری
  • گروه بندی داده های جدول
  • و…

عنوان دوره: Udemy Excel 2013 Intermediate
سطح: متوسط
مدت زمان: 5 ساعت و 5 دقیقه
نویسنده: Grant Gamble


توضیحات:

Udemy Excel 2013 Intermediate

Grant Gamble
5.5 Hours
Intermediate Level

An accessible course for people who know Excel basics and wish to extend their skills and become more confident users.
Course Description
This is a practical, hands-on course for Excel middleweights looking to gain more confidence in using the program. It provides step-by-step practice in building formulas with useful text functions like LEFT, RIGHT, MID, PROPER and CONCATENATE; conditional functions like IF, IFERROR, SUMIF AND COUNTIF; lookup functions like VLOOKUP, INDEX and MATCH; and date functions like NETWORKDAYS. The course also covers charts, sparklines, conditional formating, and graphics. It then moves on to look at all of Excel's key facilities for working with tabular data: customized sorting and filtering, subtotalling and the use of Excel tables and pivot tables. All of the worksheets used by the trainer are available to students, enabling them to follow along and practice all of the techniques being demonstrated.
What are the requirements?
To complete this course, students will need to have a copy of Microsoft Excel 2013 installed on their PC. If you do not own a copy, why not download the 30 day trial version of Excel 2016 from Microsoft's website. (The differences are not significant.)
What am I going to get from this course?
Over 64 lectures and 5.5 hours of content!
Use Microsoft Excel 2013 more confidently and effectively, gain a deeper insight into functions, formulas, charts and pivot tables.
What is the target audience?
This course is suitable for those with a basic knowledge of Excel, who have perhaps had some basic training in using the program, or those who are self-taught

Section 1: Getting started
Lecture 1
Welcome
04:34
Lecture 2
2. Downloading the course files
01:59
Section 2: GCS/01: Text functions
Lecture 3
GCS/01-1: Flash Fill Revision
02:46
Lecture 4
GCS/01-2: Using the TRIM function
03:06
Lecture 5
GCS/01-3: Changing the case of text
04:24
Lecture 6
GCS/01-4: The LEFT and RIGHT functions
03:16
Lecture 7
GCS/01-5: The MID function
02:41
Lecture 8
GCS/01-6: The CONCATENATE function
06:38
Section 3: GCS/02: Conditional functions
Lecture 9
GCS/02-1: The IF function
05:19
Lecture 10
GCS/02-2: The IFERROR function
03:05
Lecture 11
GCS/02-3: Nested IF statements
06:43
Lecture 12
GCS/02-4: The OR function
06:51
Lecture 13
GCS/02-5: The AND function
05:25
Section 4: GCS/03: Conditional number crunching functions
Lecture 14
GCS/03-1: The COUNTIF function
06:01
Lecture 15
GCS/03-2: The SUMIF function
03:19
Section 5: GCS/04: LOOKUP functions
Lecture 16
GCS/04-1: VLOOKUP exact match
07:14
Lecture 17
GCS/04-2: VLOOKUP approximate match
02:49
Lecture 18
GCS/04-3: Using INDEX and MATCH
05:46
Section 6: GCS/05: Date and time functions
Lecture 19
GCS/05-1: The TODAY and NOW functions
04:03
Lecture 20
GCS/05-2: Inserting dates using AutoFill
03:45
Lecture 21
GCS/05-3: The NETWORKDAYS function
05:52
Section 7: GCS/06: Advanced formatting
Lecture 22
GCS/06-1: Text alignment
02:48
Lecture 23
GCS/06-2: Text wrap
03:29
When you want to enter several words, a sentence or paragraph in a cell, Excel gives you the option of using text wrap.
Lecture 24
GCS/06-3: Using the Format Painter
04:04
Lecture 25
GCS/06-4: Conditional formatting
09:43
Lecture 26
GCS/06-5: Creating cell styles
08:22
Section 8: GCS/07: Managing multiple workbooks and worksheets
Lecture 27
GCS/07-1: Setting the number of sheets in new workbooks
02:42
Lecture 28
GCS/07-2: Working in group mode
05:20
Lecture 29
GCS/07-3: Viewing multiple workbooks
04:54
Lecture 30
GCS/07-4: Moving and duplicating sheets
06:56
Section 9: GCS/08: Working with charts
Lecture 31
GCS/08-1: Anatomy of an Excel chart
05:47
Lecture 32
GCS/08-2: Creating a column chart
06:46
Lecture 33
GCS/08-3: Creating a line chart.
06:13
Lecture 34
GCS/08-4: Creating a pie chart
08:52
Lecture 35
GCS/08-5: Creating a pie of pie chart
05:19
Lecture 36
GCS/08-6: Creating a doughnut chart
08:33
Lecture 37
GCS/08-7: Creating a bar chart
05:36
Section 10: GCS/09: Sparklines and graphics
Lecture 38
GCS/09-1: Creating sparklines
04:05
Lecture 39
GCS/09-2: Using formulas with graphics
10:07
Section 11: GCS/10: Working with Excel tables
Lecture 40
GCS/10-1: Benefits of using Excel tables
06:57
Lecture 41
GCS/10-2: Creating an Excel table
05:17
Lecture 42
GCS/10-3: Entering data into a table
03:36
Lecture 43
GCS/10-4: Using a total row
03:54
Lecture 44
GCS/10-5: Entering formulas in a table
02:50
Lecture 45
GCS/10-6: Creating dynamic charts from table data
08:51
Section 12: GCS/11: Sorting data
Lecture 46
GCS/11-1: Sorting by a single column
03:13
Lecture 47
GCS/11-2: Sorting by multiple columns
04:00
Lecture 48
GCS/11-3: Using a custom list for sorting
04:29
Lecture 49
GCS/11-4: Sorting columns instead of rows
03:24
Lecture 50
GCS/11-5: Sorting data in a random order
03:18
Section 13: GCS/12: Filtering data
Lecture 51
GCS/12-1: Filtering specific values
05:17
Lecture 52
GCS/12-2: Using the search box
04:01
Lecture 53
GCS/12-3: Using text filters
03:42
Lecture 54
GCS/12-4: Using number filters
04:10
Lecture 55
GCS/12-5: Using date filters
03:53
Section 14: GCS/13: Outlining and subtotalling
Lecture 56
GCS/13-1: Manually outlining data
06:27
Lecture 57
GCS/13-2: Creating an automatic outline
04:38
Lecture 58
GCS/13-3: Showing and hiding outline symbols
01:43
Lecture 59
GCS/13-4: Creating single level subtotals
07:12
Lecture 60
GCS/13-5: Creating multilevel subtotals
04:51
Section 15: GCS/14: Introduction to pivot tables
Lecture 61
GCS/14-1: Pivot tables and subtotalling compared
05:59
Lecture 62
GCS/14-2: Creating a pivot table - part 1 of 2
06:07
Lecture 63
GCS/14-2: Creating a pivot table - part 2 of 2
06:23
Lecture 64
GCS/14-3: Grouping pivot table data
10:52