این دوره مهارت های ضروری اکسل را در ۱ ساعت به شما آموزش می دهد. این آموزش تصویری به معرفی ابزارها و ویژگی های کار با اکسل می پردازد.

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

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

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

عنوان دوره: Udemy Become a Microsoft Excel Wizard in 1 Hour
مدت زمان: 1 ساعت
نویسنده: Cody Baldwin


توضیحات:

Udemy Become a Microsoft Excel Wizard in 1 Hour

Cody Baldwin
1 Hour
All Levels

This tutorial can be used with Excel 2010, Excel 2013, and Excel 2016
Don't waste your time on long, boring course that you may never finish. Learn essential Microsoft Excel skills in 1 hour that will help you to:
Boost earning potential
Impress your boss
This course will help those with a basic understanding of Excel to turbocharge their skills (and become the office superhero). It covers critical features which provide the most immediate value. Each is clearly explained in video tutorials, which you can follow along with using the sample file. A quick reference guide is also included that can be taken to the office so you will know what feature to use and when to use them.
This course will work with Excel 2010, Excel 2013, and Excel 2016.
What are the requirements?
A very basic understanding of Excel.
What am I going to get from this course?
Sample file to follow along.
Quick reference guide to take to the office.
What is the target audience?
Anyone looking to turbocharge their Excel skills -- fast.

Section 1: Course Materials
Lecture 1
Course Introduction
01:01
An overview of the course outcomes and content.
Lecture 2
Quick Reference Guide
1 page
An overview and example of each of the essential skills below.
Lecture 3
Excel Sample File
1 page
This file can be used to accompany the tutorial in each lecture.
Section 2: Essential Skills
Lecture 4
02:14
Allows you to copy patterns from one cell to another.
Lecture 5
Autofilter
05:03
Allows you to explore your data by filtering and sorting.
Lecture 6
Data Validation
06:47
Allows you to control the input you receive from others and keep your spreadsheets clean.
Lecture 7
Transpose
02:32
Flips a table so the columns become rows (and vice versa).
Lecture 8
Vlookup
07:44
Allows you to search for related information in your spreadsheet or other spreadsheets.
Lecture 9
CHECKPOINT
00:13
You are halfway there!
Lecture 10
If Statements
04:03
Performs an action if certain conditions are met.
Lecture 11
Pivot Tables
06:21
Automatically summarizes your data. You can slide-and-dice in a million ways.
Lecture 12
Conditional Formatting
05:10
Changes the format of a cell when it meets certain conditions.
Lecture 13
Charts
06:45
Some people may never look at your detailed data. A great chart helps them understand it.
Lecture 14
Data Cleaning
06:35
Sometimes data looks messy or weird. This will help you fix it.
Section 3: Bonus Material
Lecture 15
Adding Value
02:07
How to add additional value with you spreadsheets.