Pluralsight_Working_with_Excel_on_the_iPad

در این آموزش تصویری کار با اکسل در iPad را فرامیگیرید.
این دوره آموزشی محصول موسسه Pluralsight است.

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

  • مقدمه ای بر Excel
  • کار با Workbooks
  • کار با عناصر برنامه
  • نحوه ذخیره سازی داده ها
  • نحوه چاپ اطلاعات
  • نحوه ویرایش داده ها
  • قالب بندی داده ها
  • نحوه تغییر اندازه ستون و ردیف
  • نحوه حذف ستون ها و ردیف ها
  • نحوه قالب بندی سلول ها
  • حذف و اضافه سطر و ستون
  • نحوه ایجاد فرمول
  • استفاده از توابع
  • نحوه ساخت فرمول
  • نحوه کار با لیست
  • نحوه مرتب سازی داده ها
  • استفاده از جدول
  • ساخت نمودار ستونی
  • اتصال اکسل به Dropbox
  • نحوه اتصال به اینترنت
  • کار با iOS9
  • و…

عنوان دوره: Pluralsight Working with Excel on the iPad
سطح: مقدماتی
مدت زمان: 2 ساعت و 7 دقیقه
نویسنده: Mike Thomas


توضیحات:

Pluralsight Working with Excel on the iPad

Mike Thomas
Beginner
2h 7m

This course provides a solid introduction to using Excel on an iPad and is aimed at anyone who is either completely new to Excel or has used it at a very basic level.
Learn how to use Excel on an iPad! You'll learn how to set up a spreadsheet from scratch, update an existing spreadsheet, and improve the appearance of a spreadsheet to make it easy to read and understand. You'll also learn how to create simple calculations, use some of Excel's functions, work with list based data, print your spreadsheet, represent your data in a visual way, and manage your documents on a mobile device.

Introduction to Excel on an iPad
14m 57s
Introduction to the Course
2m 58s
Working with Workbooks
2m 23s
Screen Interface Elements
3m 14s
Saving and Closing a Workbook
3m 0s
Printing Your Data
2m 49s
Summary
0m 30s
Entering and Editing Data
14m 53s
Introduction
0m 38s
Working with Cell Entries
4m 39s
Cell Comments
1m 51s
Cut, Copy, and Paste
3m 24s
Auto Fill
3m 45s
Summary
0m 35s
Formatting Your Data
20m 21s
Introduction
0m 54s
Resizing Columns and Rows
4m 3s
Inserting and Deleting Columns and Rows
2m 10s
Applying Formatting to a Cell
8m 52s
Hiding and Unhiding Columns and Rows
2m 17s
Using Cell Styles
1m 29s
Summary
0m 34s
Creating Formulas and Using Functions
30m 21s
Introduction
1m 2s
Creating Basic Calculations
10m 16s
Copying a Formula
11m 18s
Using a Named Cell in a Formula
3m 6s
Introduction to Functions
4m 1s
Summary
0m 35s
Working with Lists
20m 19s
Introduction
1m 8s
Sorting a List of Items into Order
3m 59s
Fixing Issues that Prevent Sorting
6m 41s
Filtering a List
3m 9s
Prevent List Headings Disappearing as You Scroll
2m 26s
Creating and Using a Table
2m 14s
Summary
0m 38s
Visualize Your Data
11m 46s
Introduction
0m 31s
Creating a Column Chart
6m 26s
The People Graph
4m 18s
Summary
0m 29s
iPad-specific Features
14m 41s
Introduction
0m 40s
Connecting Excel to Dropbox
2m 30s
Connecting Excel to Box
2m 20s
Working with no Internet Connection
2m 33s
Multi-tasking in iOS9
2m 8s
Limitations of Excel for iPad
3m 33s
Module Summary
0m 21s
Course Summary
0m 32s