Simon Sez IT

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

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Forecasting and Modeling
      • Alteryx
        • Introduction to Alteryx
      • Power BI
        • Power BI – Beyond the Basics
        • Power BI
      • Qlik Sense
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop
      • Python
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Sign Up

Microsoft Excel

  • How to Make a Pie Chart in Excel? A Step by Step Guide

    (Note: This guide on how to make a pie chart in Excel is suitable for all Excel versions including Office 365) Visual representations like graphs and charts are an amazing and innovative way to educate people on very intricate details. They help denote details in a simpler and easily understandable manner, which would be confusing using…

  • HLOOKUP vs VLOOKUP – 5 Key Differences

    The  LOOKUP function works like an index page in a book where we look at the topic to locate its page number. You’ll find the LOOKUP functions like HLOOKUP, VLOOKUP, and XLOOKUP in Excel categorized under Lookup and Reference functions. The LOOKUP function finds a match by comparing cells in a row or column and…

  • How to Count Unique Values in Excel? 3 Easy Ways to Count Unique and Distinct Values

    (Note: This guide on how to freeze rows in Excel is suitable for all Excel versions including Office 365) Working with large amounts of data in Excel can be quite difficult. Some values may be repeated more than once. You might have to take into account multiple entries of data while performing any function to upgrade…

  • How to Freeze Rows in Excel? 4 Easy Steps

    (Note: This guide on how to freeze rows in Excel is suitable for all Excel versions including Office 365) Avoiding clutter in your Excel spreadsheet is a separate skill in itself. They tend to get quickly overcrowded if not managed properly. Fortunately for us, Excel has built-in features to easily handle such situations.  The Excel…

  • How to Sort Dates in Excel? 6 Easy Methods

    Excel offers a variety of built-in tools to easily sort data in the spreadsheet. However, when it comes to sorting dates, things may get a bit confusing if you are not exactly sure on which basis to sort (weekdays, months or years). Let us say, for example, you want to arrange your co-workers’ birthdays in…

  • XLOOKUP vs VLOOKUP – 5 Key Differences

    The Lookup functions are one of the most very popular formulas in Excel. They are used to search for one value in a column and return the corresponding value from another column. Over the years, the VLOOKUP function has become one of the most frequently used and must know lookup formulas. But, Microsoft Excel had…

  • How to Remove Spaces in Excel? 3 Easy Methods

    (Note: This guide on how to remove spaces in Excel is suitable for all Excel versions including Office 365) Dealing with large data in Excel can be quite difficult. Especially, when you copy or import huge data from any database, dealing with them can be a bit complicated. Sometimes, various functions and formulae might be…

  • previous
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Interim pages omitted …
  • Go to page 29
  • next

most popular posts

Microsoft Excel How to Insert a Checkbox in Excel? 3 EASY Examples
Microsoft Excel How to Autofit Excel Cells? 3 Best Methods
Microsoft Excel XLOOKUP Google Sheets – 4 Best Alternatives!
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

Course Categories

  • Web Development
  • QuickBooks
  • Microsoft
  • Adobe
  • Data Analysis

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebook
© 2022 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)