Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

Search results

"excel"

#Microsoft365 Day 257: How to use Data Validation in #Microsoft Excel

Data Validation in Excel: As much as I love #SharePoint or #MicrosoftForms, some things still need to happen in Excel. Should you require users to complete certain fields – then Data Validation is for you. This allows you to validate the data users enter into certain fields on your spreadsheet. We all know the saying “Garbage in – garbage out” – so your output is based on the quality of the input.

Purpose of this blog challenge:  I will write 365 blogs in 365 days around Microsoft 365. I did a similar challenge with Office 365, blogs can be found  https://tracyvanderschyff.com/microsoft-365/ . I won’t just be talking about the new Microsoft 365 subscription model. I will be sharing any news, tips and tricks around Office / Office 365 / Windows / Mobility and Security. And let’s not forget all the great new Apps & services available.  A lot of what I’ll share on Office and SharePoint will also be applicable to none “Office 365” versions.

“You can also find me contributing to REgarding 365. I’m a member of a group of enthusiasts, sharing their stories, thoughts and opinions about Microsoft 365. Catch us at https://regarding365.com | @regarding365 on Twitter and regarding365 on YouTube https://www.youtube.com/regarding365

Disclaimer:  I create content about Office / Microsoft 365. Content is accurate at time of publication, however updates and new additions happen daily which could change the accuracy or relevance. Please keep this in mind when using my blogs as guidelines.

#Microsoft365 Day 252: Creating Pivot Tables in #Microsoft Excel

There’s always a first time for everything…. I’ve written over 700 blogs about Microsoft and guess what I’ve never written about – Yup! Pivot Tables. Simply can’t believe it. Anyhooo – Pivot tables are a GREAT way to summarize and filter your data. Change the layout from Rows to Columns and do different calculations on the numbers. And it’s much easier than you think!

Purpose of this blog challenge:  I will write 365 blogs in 365 days around Microsoft 365. I did a similar challenge with Office 365, blogs can be found  https://tracyvanderschyff.com/microsoft-365/ . I won’t just be talking about the new Microsoft 365 subscription model. I will be sharing any news, tips and tricks around Office / Office 365 / Windows / Mobility and Security. And let’s not forget all the great new Apps & services available.  A lot of what I’ll share on Office and SharePoint will also be applicable to none “Office 365” versions.

“You can also find me contributing to REgarding 365. I’m a member of a group of enthusiasts, sharing their stories, thoughts and opinions about Microsoft 365. Catch us at https://regarding365.com | @regarding365 on Twitter and regarding365 on YouTube https://www.youtube.com/regarding365

Disclaimer:  I create content about Office / Microsoft 365. Content is accurate at time of publication, however updates and new additions happen daily which could change the accuracy or relevance. Please keep this in mind when using my blogs as guidelines.

#Microsoft365 Day 251: Make informed decisions with Insights in #Microsoft Excel

With the help of Insights in Excel, you can get fast, automated, insightful analysis about your data. Simply click a cell in a data range, and then click the Insights button on the Insert tab. Insights in Excel will analyze your data and return interesting visuals about it in a task pane. (Thanks for the description Microsoft)

Purpose of this blog challenge:  I will write 365 blogs in 365 days around Microsoft 365. I did a similar challenge with Office 365, blogs can be found  https://tracyvanderschyff.com/microsoft-365/ . I won’t just be talking about the new Microsoft 365 subscription model. I will be sharing any news, tips and tricks around Office / Office 365 / Windows / Mobility and Security. And let’s not forget all the great new Apps & services available.  A lot of what I’ll share on Office and SharePoint will also be applicable to none “Office 365” versions.

“You can also find me contributing to REgarding 365. I’m a member of a group of enthusiasts, sharing their stories, thoughts and opinions about Microsoft 365. Catch us at https://regarding365.com | @regarding365 on Twitter and regarding365 on YouTube https://www.youtube.com/regarding365

Disclaimer:  I create content about Office / Microsoft 365. Content is accurate at time of publication, however updates and new additions happen daily which could change the accuracy or relevance. Please keep this in mind when using my blogs as guidelines.

#Microsoft365 Day 250: Save time with custom formatting styles in #Microsoft Excel

The formatting possibilities in Excel are endless, and I have to admit, I most probably spend too much time trying to format cells. There are specific styles I use, so the fact that we can setup custom formatting to always use really helps a lot. Setup the font, alignment, borders, shading, number, protection etc. and save it as a style.

Purpose of this blog challenge:  I will write 365 blogs in 365 days around Microsoft 365. I did a similar challenge with Office 365, blogs can be found  https://tracyvanderschyff.com/microsoft-365/ . I won’t just be talking about the new Microsoft 365 subscription model. I will be sharing any news, tips and tricks around Office / Office 365 / Windows / Mobility and Security. And let’s not forget all the great new Apps & services available.  A lot of what I’ll share on Office and SharePoint will also be applicable to none “Office 365” versions.

“You can also find me contributing to REgarding 365. I’m a member of a group of enthusiasts, sharing their stories, thoughts and opinions about Microsoft 365. Catch us at https://regarding365.com | @regarding365 on Twitter and regarding365 on YouTube https://www.youtube.com/regarding365

Disclaimer:  I create content about Office / Microsoft 365. Content is accurate at time of publication, however updates and new additions happen daily which could change the accuracy or relevance. Please keep this in mind when using my blogs as guidelines.

#Microsoft365 Day 181: How to use Text to Columns in #Microsoft Excel

Quite often I receive CSV files which ends up looking like crazy data in Excel – without columns. CSV is Comma Separated Values which means all the text is in one column, separated by commas. In Excel we use Text to Columns to split this text up into different columns (as it should be). It’s easier than you think – let me show you how and hopefully save you some time.

Purpose of this blog challenge:  I will write 365 blogs in 365 days around Microsoft 365. I did a similar challenge with Office 365, blogs can be found  https://tracyvanderschyff.com/microsoft-365/ . I won’t just be talking about the new Microsoft 365 subscription model. I will be sharing any news, tips and tricks around Office / Office 365 / Windows / Mobility and Security. And let’s not forget all the great new Apps & services available.  A lot of what I’ll share on Office and SharePoint will also be applicable to none “Office 365” versions.

“You can also find me contributing to REgarding 365. I’m a member of a group of enthusiasts, sharing their stories, thoughts and opinions about Microsoft 365. Catch us at https://regarding365.com | @regarding365 on Twitter and regarding365 on YouTube https://www.youtube.com/regarding365

Disclaimer:  I create content about Office / Microsoft 365. Content is accurate at time of publication, however updates and new additions happen daily which could change the accuracy or relevance. Please keep this in mind when using my blogs as guidelines.

#Microsoft365 Day 148: Highlight data with Icon Sets in Excel

“Use an icon set to present data in three to five categories that are distinguished by a threshold value. Each icon represents a range of values and each cell is annotated with the icon that represents that range.

For example, a three-icon set uses one icon to highlight all values that are greater than or equal to 67 percent, another icon for values that are less than 67 percent and greater than or equal to 33 percent, and another icon for values that are less than 33 percent.” (Thanks for the cool explanation Microsoft!)

Purpose of this blog challenge:  I will write 365 blogs in 365 days around Microsoft 365. I did a similar challenge with Office 365, blogs can be found  https://tracyvanderschyff.com/microsoft-365/ . I won’t just be talking about the new Microsoft 365 subscription model. I will be sharing any news, tips and tricks around Office / Office 365 / Windows / Mobility and Security. And let’s not forget all the great new Apps & services available.  A lot of what I’ll share on Office and SharePoint will also be applicable to none “Office 365” versions.

“You can also find me contributing to REgarding 365. I’m a member of a group of enthusiasts, sharing their stories, thoughts and opinions about Microsoft 365. Catch us at https://regarding365.com | @regarding365 on Twitter and regarding365 on YouTube https://www.youtube.com/regarding365

Disclaimer:  I create content about Office / Microsoft 365. Content is accurate at time of publication, however updates and new additions happen daily which could change the accuracy or relevance. Please keep this in mind when using my blogs as guidelines.

Up ↑

:)