Microsoft Excel for iPad Tutorial

Microsoft Excel for iPad Tutorial

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