Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Microsoft Excel for iPad Tutorial

Matt Keil
36.9K subscribers
504K views 5 years ago
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:   / bitbytehd   Instagram:   / bitbytehd   Twitter:   / 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, Underlin …...more
...more
"What's a Computer?" Classic Crew Neck T-Shirt
$24.99
Spring
Remember computers? Nor do we! Achieve peak Gen-Z with these awesome accessories. Custom designed graphic is printed in vivid color and high resolution using state of the art color transfer technology. Shirts are made from super soft 100% combed ringspun cotton. Printed in the USA.
Shop
Spring
"What's a Computer?" Unisex Premium Pullover Hoodie
$47.99
Spring
Remember computers? Nor do we! Achieve peak Gen-Z with these awesome accessories. Custom designed graphic is printed in vivid color and high resolution using state of the art color transfer technology. Hoodies & Sweatshirts are made from super soft 50% cotton, 50% polyester. Printed in the USA. Guaranteed to last through hundreds of washes.
Shop
Spring
Game Audio Unisex Classic Pullover Hoodie
$41.99
Spring
Involved in the sound design or composing for video games community? Check out our range or clothes and accessories. Custom designed graphic is printed in vivid color and high resolution using state of the art color transfer technology. Hoodies & Sweatshirts are made from super soft 50% cotton, 50% polyester. Printed in the USA. Guaranteed to last through hundreds of washes.
Shop
Spring
Beyond the Stars Comfort Tee
$23.99
Spring
Show off your space exploration credentials with this space explorer branded merch! Custom designed graphic is printed in vivid color and high resolution using state of the art color transfer technology. Shirts are made from super soft 100% combed ringspun cotton. Printed in the USA.
Shop
Spring

Intro

0:00

App Settings/Cloud Services/Apple Pencil

1:07

Open Files/Shared Files/Recent Files/Cloud Services/Pinning Files/Sharing/Rename and Delete Files

2:45

Template Browsing/Blank Document

4:42

Interface Overview/Navigating/Zooming

5:03

File Menu: Save/Autosave, Sharing, Export as ODS or PDF, Printing/Print Settings, File Properties

5:46

Adding New Sheets/Renaming Sheets/Duplicating Sheets/Moving Sheets

6:49

Data Entry

7:40

Undo/Redo

7:53

Resizing Rows and Columns

8:27

Context Menu: Cut/Copy/Paste/Edit/Comment/Clear Cell

9:17

Selecting Multiple Cells

9:45

Changing Font and Font Size, Bold, Italic, Underline, Font Colour

10:14

Editing Cell Borders, Colour, Alignment, Cell Styles

11:34

Merge Cells, Word Wrapping

13:11

Number Format (Decimal Places, Number, Currency, Accounting, Date/Time, Percentage, Fraction, Text etc)

14:01

Insert Cells, Insert Rows and Columns, Deleting Cells, Deleting Rows and Columns

14:43

Cell Size (Height, Width, Auto-fit)

15:19

Clearing (Content and Formatting)

15:43

AutoSum (Sum, Average, Count Numbers, Maximum, Minimum)

16:08

Sorting and Filtering (Including Data Menu)

16:47

Inserting and Editing Tables

17:32

Insert Data from Picture

18:54

Insert and Editing Photos

19:16

Inserting and Editing Shapes

21:52

Inserting and Editing Text Boxes

23:10

Inserting and Editing Icons

23:32

Inserting and Editing Charts/Graphs

24:06

Adding Comments and Hyperlinks, Add-Ins(Review Menu)

26:25

Drawing (Apple Pencil or Finger)

26:51

Financial/Logical/Text Formula Templates, Date & Time, Finding Lookup & Reference, Maths and Trig, Statistics, Engineering, Information, Database, Compatibility

28:42

Sorting and Filtering (Data Menu)

29:42

Adding and Viewing Comments (Review Menu)

30:03

View Menu: Formula Bar, Gridlines, Headings, Sheet Tabs, Sheet Right-to-Left, Zooming in and Out, Freeze Panes

30:14

Search, Find and Replace, Sharing and Help

31:18

End

32:27
Microsoft Excel for iPad Tutorial
3.5KLikes
504,548Views
2020Apr 13
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:   / bitbytehd   Instagram:   / bitbytehd   Twitter:   / 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

Follow along using the transcript.

Matt Keil

36.9K subscribers