As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365. #Office365Challenge
Choose a job you love, and you will never have to work a day in your life. – Confucius
Below you’ll find the Index to all the posts related to this challenge or go to the Home Page.
February 2017
- Day 365 – Communication Tools in Office 365 – Teams
- Day 364 – Communication Tools in Office 365 – Groups
- Day 363 – Communication Tools in Office 365 – Planner
- Day 362 – Communication Tools in Office 365 – Yammer
- Day 361 – Communication Tools in Office 365 – Stream
- Day 360 – It’s the Simple things that matter in SharePoint
- Day 359 – Expiry dates on Announcement Lists in SharePoint
- Day 358 – Quick Shape Formatting with Preset Theme Styles in PowerPoint
- Day 357 – Take a Screenshot in Microsoft Office
- Day 356 – What’s new and Improved in Office 365?
- Day 355 – Office 365 Recent used list across devices
- Day 354 – Do NOT miss out on these 4 Office 365 SuperPowers
- Day 353 – Connect to Outlook in SharePoint
- Day 352 – Send e-mail when ownership is assigned in SharePoint Task Lists
- Day 351 – Focus on Content on SharePoint Pages
- Day 350 – Using Gantt Charts in SharePoint Task Lists
- Day 349 – Specify List Experience in SharePoint
- Day 348 – Disable Folder Creation in SharePoint Document Libraries
- Day 347 – Use approvals on lists and libraries in SharePoint
- Day 346 – Save parts or entire Excel workbooks as Web Pages
- Day 345 – Saving Microsoft Office Files as PDF
- Day 344 – Weekly digest: Office 365 changes
- Day 343 – How do I give feedback on Microsoft Office?
- Day 342 – Using the Selection Pane in Microsoft PowerPoint
- Day 341 – View Colour and Grayscale in PowerPoint
- Day 340 – Using the Ruler, Gridlines and Guides in Microsoft PowerPoint
- Day 339 – Hide and show slides in PowerPoint
- Day 338 – View and restore historical versions of Office files
January 2017
- Day 337 – See files others have shared with you
- Day 336 – Creating Map Charts in Excel
- Day 335 – 7 Ways to Promote your SharePoint Blog
- Day 334 – Manage your SharePoint blog and categories
- Day 333 – Create and Use SharePoint Blog Sites
- Day 332 – Using the Effect Options in PowerPoint Morph Transitions
- Day 331 – Create and edit permission levels in SharePoint
- Day 330 – Manage and Discard Checked out files in SharePoint
- Day 329 – Use @mentions to get someone’s attention in Microsoft Outlook
- Day 328 – Open and Edit SVG files in Microsoft Office
- Day 327 – Using CONCAT and TEXTJOIN in Microsoft Excel
- Day 326 – Using the Learning Tools in Microsoft Word
- Day 325 – Getting those bullets to work in Design Ideas – Microsoft PowerPoint
- Day 324 – Using PowerPoint Designer to make your slides ‘POP’!
- Day 323 – Convert Ink to shapes with the Draw Tab In Office 2016
- Day 322 – Share a copy or PDF your document by email in Microsoft Word
- Day 321 – Insert Icons in Microsoft Office
- Day 320 – Tell me what you want to do…
- Day 319 – Woohoo to the new Zoom Feature in Microsoft PowerPoint
- Day 318 – Get Insights with Smart Lookup in Microsoft Word
- Day 317 – Using the new Researcher in Microsoft Word
- Day 316 – Email Signatures in Outlook
- Day 315 – How to Train your Inbox Dragon
- Day 314 – Edit Email Subjects and Add Notes
- Day 313 – Saving PowerPoint files as Videos
- Day 312 – Skype for Business Settings
- Day 311 – Schedule Meetings with Skype for Business
- Day 310 – Audio and Video Calls with Skype for Business
- Day 309 – Instant Messaging with Skype for Business
- Day 308 – Finding and Adding Contacts in Skype for Business
- Day 307 – Skype for Business User Interface
December 2016
- Day 306 – 7 New Year’s Resolutions with Office 365
- Day 305 – Design and Remix in Microsoft Sway
- Day 304 – How to use Layouts in Microsoft Sway
- Day 303 – Using Media in Microsoft Sway
- Day 302 – Working with Images in your Microsoft Sway
- Day 301 – Creating your first Microsoft Sway Presentation
- Day 300 – Restricting People picker to a specific SharePoint Group
- Day 299 – Citations, Bibliographies & References in Word
- Day 298 – Tap for Word and Outlook
- Day 297 – Setting your Out of Office in Office 365 Outlook
- Day 296 – Office 365 Update your version of Office
- Day 295 – Restore permanently deleted items in Outlook
- Day 294 – SharePoint Permissions Difference between Edit and Contribute
- Day 293 – SharePoint Permissions Difference between Read and View Only
- Day 292 – SharePoint List Validations on Dates
- Day 291 – SharePoint Column Validations on Email Addresses
- Day 290 – SharePoint Column Validations on ID Numbers
- Day 289 – SharePoint Column Validations on Telephone Numbers
- Day 288 – 15 Crazy GREAT ideas with Promoted Links in SharePoint
- Day 287 – SharePoint List Validations – Minimum Length of Characters
- Day 286 – SharePoint List Validations – Force completion of one of two columns
- Day 285 – SharePoint List Validations – Force field completion
- Day 284 – SharePoint Calculated Column Limitations
- Day 283 – SharePoint Lookup Column Limitations
- Day 282 – Data Cleanup Formulas for SharePoint
- Day 281 – ROUNDUP, ODD, or EVEN functions in SharePoint
- Day 280 – Calculate the Average of numbers SharePoint
- Day 279 – SharePoint Show dates as days of the week
- Day 278 – SharePoint Using ABS Function
- Day 277 – SharePoint Calculate difference between two dates
- Day 276 – SharePoint Calculated Field Formulas – add days to dates
November 2016
- Day 275 – SharePoint: Hide error values in calculated columns
- Day 274 – Share a document by sending or posting an anonymous guest link
- Day 273 – Change the Theme in Microsoft Office
- Day 272 – Download multiple documents in SharePoint as zip
- Day 271 – Outlook: Forgotten Attachment Reminder
- Day 270 – Outlook on my Android phone
- Day 269 – SharePoint: Dragging files into libraries and folders
- Day 268 – Pin folders or documents in SharePoint
- Day 267 – SharePoint: Changing the column width in Lists / Libraries
- Day 266 – SharePoint: Updating Metadata by dragging into groups
- Day 265 – SharePoint: Easily create views in new Modern Libraries
- Day 264 – SharePoint: Choose when to send alerts
- Day 263 – PowerApps: Different layouts on Screens
- Day 262 – PowerApps: Using slider fields
- Day 261 – PowerApps: Adding Tooltips to your fields
- Day 260 – PowerApps: Create an icon for your App
- Day 259 – PowerApps: Basic Form Edit
- Day 258 – PowerApps Pricing and Availability
- Day 257 – What is Microsoft PowerApps?
- Day 256 – Flow: Get daily reminders in Email
- Day 255 – Flow: Send approval email when a new item is added
- Day 254 – Flow: Copy new files in Dropbox to a specific folder on OneDrive
- Day 253 – Flow: Save new email attachment to OneDrive for Business
- Day 252 – Flow – Block out my Office 365 calendar for an hour
- Day 251 – Flow: Manage Existing Flows
- Day 250 – Flow – Save Photos from Instagram to OneDrive
- Day 249 – Flow – Get a push notification when a new file is added in SharePoint
- Day 248 – Flow – Log the latest tweets about your product in Excel
- Day 247 – Flow: Save my email attachments to a SharePoint document library
- Day 246 – Flow – Save updates from Facebook to a SharePoint List
October 2016
- Day 245 – Flow – Save tweets that include a specific hashtag to a SharePoint list
- Day 244 – What is Microsoft Flow?
- Day 243 – Using Notes Pages in PowerPoint
- Day 242 – Email page from OneNote
- Day 241 – Convert OneNote Tasks to Outlook Tasks
- Day 240 – Using OneDrive for Business
- Day 239 – Getting started with OneDrive for Business
- Day 238 – SharePoint Online New Site Pages
- Day 237 – Paragraph text alignment in Office 365
- Day 236 – Changing Hyperlink Colours on PowerPoint Slide
- Day 235 – Open a SharePoint Online site on an Android device
- Day 234 – Sorting and Collapsed Views in Outlook
- Day 233 – Microsoft MyAnalytics Outlook add-in
- Day 232 – Using Animations in your PowerPoint Presentations
- Day 231 – Transitions between PowerPoint Slides
- Day 230 – Using Morph Transitions in PowerPoint
- Day 229 – Add Sections to PowerPoint Slides
- Day 228 – Searching entire workbook in Excel
- Day 227 – Change Portrait to Landscape in PowerPoint
- Day 226 – Drop Cap in Microsoft Word
- Day 225 – Filtered Alerts on Document Types
- Day 224 – ShareBingo
- Day 223 – PowerPoint Slide Masters
- Day 222 – Blank Layout in PowerPoint
- Day 221 – Keep documents offline
- Day 220 – Open PDF in Word
- Day 219 – 200 Things I didn’t know Word could do
- Day 218 – Check Permissions for a person on a SharePoint Site
- Day 217 – Check Unique Permissions on SharePoint Sites
- Day 216 – SharePoint Groups for Permissions
- Day 215 – How to change permissions on items in SharePoint
September 2016
- Day 214 – How to change permissions on a list or library in SharePoint
- Day 213 – SharePoint Permissions – what’s your strategy? Part 2
- Day 212 – SharePoint Permissions – what’s your strategy? Part 1
- Day 211 – How are Permission levels made up?
- Day 210 – Default permission levels in SharePoint
- Day 209 – Solution Register in SharePoint Part 2
- Day 208 – Solutions Registers in SharePoint
- Day 207 – Check In and Out of Documents in SharePoint
- Day 206 – Use SharePoint to track Stock Levels
- Day 205 – Description on SharePoint Apps
- Day 204 – Mailto URL for buttons on SharePoint Pages
- Day 203 – Reroute Submissions on SharePoint Forms
- Day 202 – Open list on New Form
- Around the Office in 365 Days – The Starfish Story (not part of challenge)
- Day 201 – Target Audience on Navigation Links
- Day 200 – Target Audience on Lists or Libraries
- Day 199 – Target Audience on Web Parts
- Day 198 – Chrome State and Type of Web Parts
- Day 197 – SharePoint Web Parts – Script Editors
- Day 196 – SharePoint Web Parts – Picture Library Slideshow Webpart
- Day 195 – SharePoint Web Parts – Page Viewers
- Day 194 – SharePoint Web Parts – Media Web Part
- Day 193 – SharePoint Web Parts – Image Viewers
- Day 192 – SharePoint Web Parts – Content Editors
- Day 191 – SharePoint Web Parts – Content Rollup
- Day 190 – SharePoint Web Parts – Blog Category
- Day 189 – SharePoint Web Parts Available
- Day 188 – SharePoint Web Parts – Appearance
- Day 187 – SharePoint Web Parts – Views
- Day 186 – Web Part Pages in SharePoint
August 2016
- Day 185 – Publishing Sites in SharePoint
- Day 184 – Publishing features in SharePoint
- Day 183 – Reference Wiki Pages
- Day 182 – Shapes with Hyperlinks on Wiki Pages
- Day 181 – SharePoint Wiki Pages
- Day 180 – SharePoint Pages Basics
- Day 179 – Drawing and Adding content to your OneNote
- Day 178 – OneNote and Outlook
- Day 177 – Online Notebook vs OneNote
- Day 176 – Formatting and applying Tags in OneNote
- Day 175 – What is OneNote?
- Day 174 – SharePoint Online New Modern vs Classic Experience Part 2
- Day 173 – SharePoint – SharePoint Online New Modern vs Classic Experience Part 1
- Day 172 – Office 365 Managed Metadata Navigation
- Day 171 – Summary Links in SharePoint – link to a person
- Day 170 – Summary Links in SharePoint
- Day 169 – Modern Lists in SharePoint – Views
- Day 168 – Where’s my List Settings in SharePoint?!
- Day 167 – Modern Lists in SharePoint
- Day 166 – Excel AutoRecover File Location
- Day 165 – Hidden Treasures in Excel
- Day 164 – HLOOKUP Formula in Excel
- Day 163 – VLOOKUP Formula in Excel
- Day 162 – Data Clean-up in Excel – TRIM formula
- Day 161 – Data Clean-up in Excel – Left Mid and Right + Search & LEN
- Day 160 – Data Clean-up in Excel – Left Mid and Right
- Day 159 – Data Clean-up in Excel – Concatenate
- Day 158 – Set default font in Word
- Day 157 – Open Blank Template as default in Microsoft Office
- Day 156 – Set Default Views for your File Explorer
- Day 155 – Always expand Window
- Day 154 – Outlook – Clutter
July 2016
- Day 153 – Quick Steps in Outlook – Reply and Delete
- Day 152 – Quick Steps in Outlook – Team Email
- Day 151 – Quick Steps in Outlook
- Day 150 – Search Tools in Outlook
- Day 149 – Manage emails in Outlook
- Day 148 – Create a Distribution Group in Outlook
- Day 147 – Create a Calendar View on non-Calendar Apps in SharePoint
- Day 146 – Change the case of text in Excel
- Day 145 – Configure Rules in Outlook
- Day 144 – Recall Messages in Outlook
- Day 143 – BCC and CC in Outlook
- Day 142 – Speak Cells in Excel
- Day 141 – Word Shortcut Keys
- Day 140 – Excel Shortcut Keys
- Day 139 – Using Data Filters in Excel
- Day 138 – Find and Replace in Office
- Day 137 – Hide Tabs in Excel
- Day 136 – Track Changes in Excel
- Day 135 – Content Types in SharePoint Part 8
- Day 134 – Content Types in SharePoint Part 7
- Day 133 – Content Types in SharePoint Part 6
- Day 132 – Content Types in SharePoint Part 5
- Day 131 – Content Types in SharePoint Part 4
- Day 130 – Content Types in SharePoint Part 3
- Day 129 – Content Types in SharePoint Part 2
- Day 128 – Content Types in SharePoint Part 1
- Day 127 – Snipping Tool Delay Function
- Day 126 – Insert Screenshots in Office
- Day 125 – Microsoft FastTrack – Adoption Activities
- Day 124 – Microsoft FastTrack – Onboarding
- Day 123 – Microsoft FastTrack – Service Readiness
June 2016
- Day 122 – Microsoft FastTrack – Business Case
- Day 121 – Microsoft FastTrack – Success Plans
- Day 120 – Adoption Methodology Resources
- Day 119 – Discover SharePoint
- Day 118 – Be an Office Insider
- Day 117 – Office 365 Help and Support
- Day 116 – Office 365 Plans
- Day 115 – Office 365 scenario-based training
- Day 114 – Office Training Centre
- Day 113 – Office 365 Changes to Document Libraries Part 2
- Day 112 – Office 365 Changes to Document Libraries
- Day 111 – Office 365 Changes to Site Contents Layout
- Day 110 – Office 365 Changes to App Launcher and Sites
- Day 109 – Creating Scatter and Bubble Charts in Excel
- Day 108 – Creating Combo Charts in Excel
- Day 107 – Windows Magnifier
- Day 106 – Area Charts in Excel
- Day 105 – Pie and Doughnut Charts in Excel
- Day 104 – Line Charts in Excel
- Day 103 – Add a Bar Chart in Excel
- Day 102 – Add a column chart in Excel
- Day 101 – Term Store Management in Office 365 Part 6 Using Synonyms for Terms
- Day 100 – Term Store Management in Office 365 Part 5 Using Managed Metadata
- Day 99 – Term Store Management in Office 365 Part 4 Building
- Day 98 – Term Store Management in Office 365 Part 3 Planning
- Day 97 – Term Store Management in Office 365 Part 2 Permissions
- Day 96 – Term Store Management in Office 365 Part 1 Terminology
- Day 95 – Creating [Me] Views in SharePoint
- Day 94 – Descriptions on Apps in SharePoint
- Day 93 – Reusable Metadata in SharePoint – Site Columns
May 2016:
- Day 92 – Reusable Metadata in SharePoint – Lookups
- Day 91 – Column Settings in SharePoint
- Day 90 – Considerations before creating Document Libraries in SharePoint
- Day 89 – Delve and User Profiles in Office 365
- Day 88 – Version Histories in SharePoint
- Day 87 – Open behaviour for documents in SharePoint
- Day 86 – Sorting and Filtering Data in SharePoint
- Day 85 – Creating Datasheet Views in SharePoint
- Day 84 – Creating Grouped Views in SharePoint
- Day 83 – Adding metadata / categories to SharePoint Document Libraries
- Day 82 – Create a document Library in SharePoint
- Day 81 – Importing spreadsheets to SharePoint
- Day 80 – Creating Picture Libraries in SharePoint
- Day 79 – Creating an Announcement List in SharePoint
- Day 78 – Creating Links Lists in SharePoint
- Day 77 – Creating Discussion Boards in SharePoint
- Day 76 – SharePoint Apps – Building a Calendar
- Day 75 – SharePoint Apps – Building a Task List
- Day 74 – Adding Apps in SharePoint Online
- Day 73 – Office365 Admin App Managing your Release Preferences
- Day 72 – Office 365 Admin Mobile App
- Day 71 – Trim videos in PowerPoint
- Day 70 – Drag and Drop Files into SharePoint
- Day 69 – Using the Thesaurus in Microsoft Office
- Day 68 – Outlook Calendar Copy to Excel
- Day 67 – The Future of SharePoint
- Day 66 – O365 App Launcher – How to resize your apps (tiles)
- Day 65 – Text Case conversion in Word
- Day 64 – Insert Table of Figures in Word
- Day 63 – Configure Paste Options in Microsoft Word
- Day 62 – Inserting tables in Word
April 2016:
- Day 61 – Notes in Outlook
- Day 60 – Templates available in Word
- Day 59 – Single Page Orientation in Word
- Day 58 – Headers and Footers in Word
- Day 57 – Inserting Comments in Word
- Day 56 – Comparing Documents in Word
- Day 55 – Using Spike to cut and paste in Word
- Day 54 – Inserting a Table of Contents in Word
- Day 53 – SharePoint Saving Sites as Templates
- Day 52 – Removing Backgrounds in PowerPoint
- Day 51 – SmartArt in Microsoft Office
- Day 50 – SharePoint Custom Send To Locations
- Day 49 – PowerPoint Office Mix Slide Recordings
- Day 48 – PowerPoint Office Mix Quizzes
- Day 47 – PowerPoint Mix Screen Recording
- Day 46 – Office Mix
- Day 45 – The AMAZING Windows Button
- Day 44 – Excel / SharePoint Formulas using Commas or Semicolons
- Day 43 – Auto Fill in Excel
- Day 42 – Navigation elements in SharePoint
- Day 41 – SharePoint site Logo and Description
- Day 40 – Changing the Look in SharePoint #Office365Challenge
- Day 39 – Outlook Email Hyperlinks
- Day 38 – Ratings in SharePoint
- Day 37 – Pin or Unpin the Office Ribbon
- Day 36 – Data Bars, Colours Scales and Icon Sets in Excel
- Day 35 – Excel Top to Bottom Rules
- Day 34 – Highlight Cell Rules in Excel
- Day 33 – Removing duplicates in Excel
- Day 32 – Data Validation in Excel
March 2016:
- Day 31 – SharePoint Surveys Part 6
- Day 30 – SharePoint Surveys Part 5
- Day 29 – SharePoint Surveys Part 4
- Day 28 – SharePoint Surveys Part 3
- Day 27 – SharePoint Surveys Part 2
- Day 26 – SharePoint Surveys
- Day 25 – Image Maps in SharePoint 2013
- Day 24 – Promoted Links Images for SharePoint Idea 3
- Day 23 – Promoted Links Images for SharePoint Idea 2
- Day 22 – Promoted Links Images for SharePoint Idea 1
- Day 21 – Promoted Links in SharePoint
- Day 20 – Adding Apps in SharePoint
- Day 19 – Transpose Excel Data using Paste Special
- Day 18 – Format Painter in Office
- Day 17 – Disabling Quick Edit in SharePoint
- Day 16 – Quick Edit in SharePoint
- Day 15 – Exclude Items from Search Results In SharePoint
- Day 14 – Alignment of Shapes in PowerPoint
- Day 13 – Transparency on Shapes in PowerPoint
- Day 12 – Eyedropper in PowerPoint
- Day 11 – RSS Feeds in Outlook
- Day 10 – Inserting Shapes in PowerPoint
- Day 9 – Item limits on lists and libraries in SharePoint
- Day 8 – Customizing the Office Ribbon
- Day 7 – Quick Access Toolbar in Office
- Day 6 – Filtered Alerts in SharePoint
- Day 5 – Creating Filtered Views in SharePoint
- Day 4 – SharePoint 2013 Sign in as different user
- Day 3 – Relevant Documents Web Parts in SharePoint
- Day 2 – Item-Level Permissions in SharePoint
- Day 1 – How to replace the ID Hashtags from Managed Metadata