این دوره راهنمای Microsoft Excel 2013 برای مبتدیان می باشد. این آموزش تصویری ویژگی های پیشرفته مایکروسافت اکسل 2013 و نحوه نصب و راه اندازی برنامه را به طور کامل شرح می دهد.
این دوره آموزشی محصول موسسه Udemy است.

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

  • شروع به کار اکسل
  • نحوه تغییر دادن اطلاعات
  • تنظیم سطر و ستون
  • نحوه ترازبندی گروه
  • کار با فرمت های سفارشی
  • کار با فرمول و توابع
  • سازماندهی داده
  • نحوه مرتب سازی
  • کار با سربرگ و پاورقی
  • کار با نمودارها
  • کار با تصاویر
  • و…

عنوان دوره: Udemy The Essential Guide of Microsoft Excel 2013 for Beginners
سطح: مقدماتی
مدت زمان: 5 ساعت
نویسنده: Coach Sofi

توضیحات:

Get up to speed with Excel - with plenty of sample exercises!
Excel is a universal tool which allows you to organise data in an effective and efficient manner. Excel is used in investment banks to calculate the price of complex financial products, or in homes to track household expenses.
No matter what industry you are in, no matter what stage of life you are in, having knowledge in Excel will help you in some way. This course will enable and empower you to operate on Microsoft Excel with a high level of confidence.
Confused by the plethora of Excel courses on Udemy? Here is why you should take this course.
I am a professional coach with a decade of experience in training working adults in soft skills (such as leadership & effective communication) and hard skills (such as basic computer literacy & Microsoft Word/Excel)
My students consistently give high ratings for my course. Some of the feedback given is that my courses are "easy to follow", "delivered with high level of clarity".
I believe that the best way of learning is by doing - which is why I provide lots of sample data in this course and encourage my students to practice on these data
What are the requirements?
You will need Microsoft Excel 2013 installed
What am I going to get from this course?
Over 29 lectures and 4 hours of content!
Confidently and independently operate the essential features of Microsoft Excel 2013
What is the target audience?
This course is appropriate for for people across all industries and all levels with basic computer skills. This course is probably not for you if you're looking to learn the advanced features of Microsoft Excel 2013

Section 1: Getting Started with Excel
Lecture 1	
Pin to Taskbar and Desktop
06:07
Lecture 2	
Understanding Excel Screen
08:26
Lecture 3	
Template, Difference between workbook and worksheets and saving
14:09
Lecture 4	
Create 1st Excel Workbook, Autofit and Changing Data
07:50
Section 2: Simple Formatting
Lecture 5	
Autofill, Flashfill, Font Group
16:29
Lecture 6	
Adjust Rows and Columns, Hide and Unhide, Insert and Delete Rows and
08:28
Lecture 7	
Alignment Group
06:17
Lecture 8	
Number Format
10:03
Lecture 9	
Custom Format
12:56
Section 3: Simple Calculations
Lecture 10	
Simple Formula and Functions
Preview
10:40
Section 4: Organising Data
Lecture 11	
Copy and Paste, Cut and Paste
05:18
Lecture 12	
Sorting and Filtering
07:38
Lecture 13	
Find and Replace
08:01
Section 5: Formulas and Functions
Lecture 14	
Formulas (Add, Divide, Multiply) and Errors in Formula
09:56
Lecture 15	
Absolute Cell and Reference Cell
06:00
Lecture 16	
Functions
10:06
Lecture 17	
Text Functions
08:25
Lecture 18	
Date and Time Functions
05:18
Lecture 19	
Financial Functions
11:15
Section 6: Page Layout
Lecture 20	
Header and Footer
07:27
Lecture 21	
Page Layout (Margins and Orientation)
06:35
Lecture 22	
Page Layout (Print Area and Print Titles)
06:05
Lecture 23	
Page Layout (Scale to fit and Gridlines)
05:14
Lecture 24	
Freeze Panes
04:31
Section 7: Review
Lecture 25	
Spelling
05:30
Section 8: Charts
Lecture 26	
Charts (Creating and Moving Charts)
08:51
Lecture 27	
Charts (Font Size, Change Data Series, Change Chart Type)
08:27
Lecture 28	
Charts (Changing the Chart Title, Data Lables, Data Tables and Colo
06:37
Section 9: Pictures
Lecture 29	
Pictures and Smart Art
10:40

حجم فایل: 1GB