The iPad Pro is a great device for getting your office work done either at home or out in the field, as they are lightweight, portable and have fantastic battery life. You can also use all of your favourite Microsoft Office applications on the iPad including Excel for your spreadsheets.
HOWEVER: The native Excel iOS app does NOT support certain features, such as conditional formatting and pivot tables. In this video we show you step-by-step how to use these features using Excel Online, via the Office Portal. This gives you all the features you could possibly want, that would normally be available with Excel Desktop on a computer - what's more, Excel Online looks practically identical to the Excel Desktop version, so if you really don't like how the iOS app looks, you can use Excel Online instead.
Access the OFFICE PORTAL: https://portal.office.com
Set Up Face ID by following this tutorial: • How to Set Up FACE ID on iPad and Use...
See all our iPad tutorials in one Playlist HERE: • iPad Tutorials and Accessories
----------
Contents of this Video
0:00 Intro
0:07 What I’ll be covering in this video
0:25 ADVANCED Excel Features
0:40 Initial Preparations and Fundamentals of Files in OneDrive
1:16 How to access the Office Portal
1:40 How to access Excel in the Office Portal
1:58 How to insert conditional formatting
2:30 My two cents on Excel Online
2:45 Final thoughts
----------
To set up your Microsoft Surface Mouse for iPad, see our tutorial here: • iPad Pro ACCESSORIES: Microsoft Surfa...
To set up the Logitech Folio Touch, Logitech's trackpad keyboard case for the iPad Air and iPad Pro, see our tutorial on that model here: • iPad Pro ACCESSORIES: Logitech Folio ...
To set up the Logitech Slim Folio Pro, Logitech's keyboard case without a trackpad, see our tutorial on that model here: • iPad Pro ACCESSORIES: Logitech Slim F...
Get the Microsoft Surface Mobile Mouse HERE: https://amzn.to/3OZEVWh
Get the Logitech Slim Folio Pro for iPad Pro 11 inch HERE: https://amzn.to/3P0gYxV
Get the Logitech Slim Folio Pro for iPad Pro 12.9 inch HERE: https://amzn.to/3KLHR6d
Get the Logitech Folio Touch for iPad Air HERE: https://amzn.to/3OH4qKE
Get the Logitech Folio Touch for iPad Pro 11 inch HERE: https://amzn.to/3OLIf6a
Get the Logitech Folio Touch for iPad Pro 12.9 inch HERE: https://amzn.to/3KKCRP8
Смотрите видео Microsoft Excel on iPad [Use Case] How to Manage Advanced Spreadsheets with Conditional Formatting онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Joe Unsworth 11 Март 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 973 раз и оно понравилось 17 людям.