Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

Microsoft Office

  • What’s New in Windows 11 – Recorded Webinar

    In this Windows 11 tutorial, we explore all the new features introduced with the Windows 11 operating system. Specifically, we look at: Downloading and installing Windows 11 Task Bar and Start Menu Pinning items to the Task Bar Personalizing the desktop Using search Multiple desktops Widgets Snap layouts Quick Settings Microsoft Store Inbuilt applications This…

  • Getting Started in Power BI – Parts 1 & 2 (Recorded Webinars)

    Part 1 In this Introduction to Power BI recorded webinar, we look at importing data into Power BI Desktop and how to start to prepare it for Power BI visualizations. Power BI is (as the name implies!), a very powerful business intelligence tool. If Excel isn’t cutting it for your data analysis and modeling, then…

  • How to Create a Pivot Table in Excel? — The Easiest guide

    Learn how to create a pivot table in Microsoft Excel

  • Excel SUMIF vs SUMIFS – The Complete Guide

    This article deals with the Excel SUMIF and SUMIFS functions. You’ll learn how to use them along with their key differences. In this article, I’ll cover: Difference Between Excel SUMIF and  Excel SUMIFS Functions In your Excel journey, you’ll probably come across situations where you need to find the SUM for certain values only.  Located…

  • Create an Excel Dashboard in 5 Minutes – The Best Guide

    This Excel Dashboard tutorial is suitable for users of Excel 2013/2016/2019 and Microsoft 365.   Objective  Create a simple interactive Excel dashboard to display critical metrics in 5 minutes.   This Guide Covers: Excel Dashboards Explained  Have you ever wondered how all those dynamic dashboards with eye-catching graphs and pie-charts that turn heads and receive applause…

  • How to Make An Excel Forecast Sheet in 3 Steps – The Best Guide

    This Excel Forecast Sheet tutorial is suitable for users of Excel 2016/2019 and Microsoft 365.   Objective  Create an Excel forecast sheet to analyze and predict future sales. Display the historical and predicted values in a line chart using the Excel forecast sheet.   This Guide Covers: Excel Forecast Sheet Explained  Imagine this, you have been…

  • Excel Dynamic Array: 8 Must-Know Formulas

    This Excel Dynamic Array tutorial is suitable for users of Excel for Microsoft 365.   Objective  Explore Microsoft’s NEW Excel Dynamic Array Functions and use them effectively to solve problems.   This guide covers: Excel Dynamic Array Explained  Dealing with an Excel array is quite complicated in itself, don’t you think?  What if there is a…

most popular posts

Microsoft How To Use Microsoft To Do: Microsoft To Do Tutorial
Microsoft Office Microsoft Teams Tutorial – Getting Started.
Microsoft Excel HLOOKUP in Excel
Live Classes Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
Microsoft Project Free Microsoft Project Training Course
Microsoft Access Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
Adobe Photoshop How to Use Blending Mode With Layers in Adobe Photoshop Elements 15
Microsoft Excel How to Create Charts and Graphs in Microsoft Excel 2016
© 2022 Simon Sez IT, Inc.
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)

Privacy settings

Decide which cookies you want to allow. You can change these settings at any time. However, this can result in some functions no longer being available. For information on deleting the cookies, please consult your browser’s help function. Learn more about the cookies we use.

With the slider, you can enable or disable different types of cookies:

This website will:

  • Essential: Remember your cookie permission setting
  • Essential: Allow session cookies
  • Essential: Gather information you input into a contact forms, newsletter and other forms across all pages
  • Essential: Keep track of what you input in a shopping cart
  • Essential: Authenticate that you are logged into your user account
  • Essential: Remember language version you selected

This website won't:

  • Remember your login details
  • Functionality: Remember social media settings
  • Functionality: Remember selected region and country
  • Analytics: Keep track of your visited pages and interaction taken
  • Analytics: Keep track about your location and region based on your IP number
  • Analytics: Keep track of the time spent on each page
  • Analytics: Increase the data quality of the statistics functions
  • Advertising: Tailor information and advertising to your interests based on e.g. the content you have visited before. (Currently we do not use targeting or targeting cookies.
  • Advertising: Gather personally identifiable information such as name and location

This website will:

  • Essential: Remember your cookie permission setting
  • Essential: Allow session cookies
  • Essential: Gather information you input into a contact forms, newsletter and other forms across all pages
  • Essential: Keep track of what you input in a shopping cart
  • Essential: Authenticate that you are logged into your user account
  • Essential: Remember language version you selected
  • Functionality: Remember social media settings
  • Functionality: Remember selected region and country

This website won't:

  • Remember your login details
  • Analytics: Keep track of your visited pages and interaction taken
  • Analytics: Keep track about your location and region based on your IP number
  • Analytics: Keep track of the time spent on each page
  • Analytics: Increase the data quality of the statistics functions
  • Advertising: Tailor information and advertising to your interests based on e.g. the content you have visited before. (Currently we do not use targeting or targeting cookies.
  • Advertising: Gather personally identifiable information such as name and location

This website will:

  • Essential: Remember your cookie permission setting
  • Essential: Allow session cookies
  • Essential: Gather information you input into a contact forms, newsletter and other forms across all pages
  • Essential: Keep track of what you input in a shopping cart
  • Essential: Authenticate that you are logged into your user account
  • Essential: Remember language version you selected
  • Functionality: Remember social media settingsl Functionality: Remember selected region and country
  • Analytics: Keep track of your visited pages and interaction taken
  • Analytics: Keep track about your location and region based on your IP number
  • Analytics: Keep track of the time spent on each page
  • Analytics: Increase the data quality of the statistics functions

This website won't:

  • Remember your login details
  • Advertising: Use information for tailored advertising with third parties
  • Advertising: Allow you to connect to social sites
  • Advertising: Identify device you are using
  • Advertising: Gather personally identifiable information such as name and location

This website will:

  • Essential: Remember your cookie permission setting
  • Essential: Allow session cookies
  • Essential: Gather information you input into a contact forms, newsletter and other forms across all pages
  • Essential: Keep track of what you input in a shopping cart
  • Essential: Authenticate that you are logged into your user account
  • Essential: Remember language version you selected
  • Functionality: Remember social media settingsl Functionality: Remember selected region and country
  • Analytics: Keep track of your visited pages and interaction taken
  • Analytics: Keep track about your location and region based on your IP number
  • Analytics: Keep track of the time spent on each page
  • Analytics: Increase the data quality of the statistics functions
  • Advertising: Use information for tailored advertising with third parties
  • Advertising: Allow you to connect to social sitesl Advertising: Identify device you are using
  • Advertising: Gather personally identifiable information such as name and location

This website won't:

  • Remember your login details
Save & Close