Microsoft Excel for iPad Tutorial

Channel:

Matt Keil

Subscribers:

36,900

Published on April 13, 2020 11:16:12 AM ● Video Link: https://www.youtube.com/watch?v=lerdWXt6gUg

Category:

Tutorial

Duration: 33:30

405,101 views

2,946

This video is a tutorial on how to use Microsoft Excel on the iPad. This app is very capable and has many features of the desktop version.

Support Bit By Byte and follow:
Facebook: http://www.facebook.com/BitByteHD
Instagram: http://instagram.com/BitByteHD
Twitter: http://twitter.com/BitByteHD

Video Contents:

0:00-1:07 Intro
1:07-2:45 App Settings/Cloud Services/Apple Pencil
2:45-4:42 Open Files/Shared Files/Recent Files/Cloud Services/Pinning Files/Sharing/Rename and Delete Files
4:42-5:03 Template Browsing/Blank Document
5:03-5:46 Interface Overview/Navigating/Zooming
5:46-6:49 File Menu: Save/Autosave, Sharing, Export as ODS or PDF, Printing/Print Settings, File Properties
6:49-7:40 Adding New Sheets/Renaming Sheets/Duplicating Sheets/Moving Sheets
7:40-7:53 Data Entry
7:53-8:27 Undo/Redo
8:27-9:17 Resizing Rows and Columns
9:17-9:45 Context Menu: Cut/Copy/Paste/Edit/Comment/Clear Cell
9:45-10:14 Selecting Multiple Cells
10:14-11:34 Changing Font and Font Size, Bold, Italic, Underline, Font Colour
11:34-13:11 Editing Cell Borders, Colour, Alignment, Cell Styles
13:11-14:01 Merge Cells, Word Wrapping
14:01-14:43 Number Format (Decimal Places, Number, Currency, Accounting, Date/Time, Percentage, Fraction, Text etc)
14:43-15:19 Insert Cells, Insert Rows and Columns, Deleting Cells, Deleting Rows and Columns
15:19-15:43 Cell Size (Height, Width, Auto-fit)
15:43-16:08 Clearing (Content and Formatting)
16:08-16:47 AutoSum (Sum, Average, Count Numbers, Maximum, Minimum)
16:47-17:32 Sorting and Filtering (Including Data Menu)
17:32-18:54 Inserting and Editing Tables
18:54-19:16 Insert Data from Picture
19:16-21:52 Insert and Editing Photos
21:52-23:10 Inserting and Editing Shapes
23:10-23:32 Inserting and Editing Text Boxes
23:32-24:06 Inserting and Editing Icons
24:06-26:25 Inserting and Editing Charts/Graphs
26:25-26:51 Adding Comments and Hyperlinks, Add-Ins(Review Menu)
26:51-28:42 Drawing (Apple Pencil or Finger)
28:42-29:42 Financial/Logical/Text Formula Templates, Date & Time, Finding Lookup & Reference, Maths and Trig, Statistics, Engineering, Information, Database, Compatibility
29:42-30:03 Sorting and Filtering (Data Menu)
30:03-30:14 Adding and Viewing Comments (Review Menu)
30:14-31:18 View Menu: Formula Bar, Gridlines, Headings, Sheet Tabs, Sheet Right-to-Left, Zooming in and Out, Freeze Panes
31:18-32:27 Search, Find and Replace, Sharing and Help
32:27-33:29 End