Simon Sez IT

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

Search
MicrosoftArtificial IntelligenceWork ProductivityData AnalysisQuickBooksAdobeWeb DevelopmentSoft Skills Video ShortsSkills Targeting
View All Courses
Microsoft
Master Microsoft software today. Carefully crafted Microsoft training courses for complete beginners and advanced users.
Learn More
Artificial Intelligence
Harness the power of AI with courses on ChatGPT, Copilot, and other cutting-edge tools to boost productivity, creativity, and decision-making.
Learn More
Work Productivity
Boost efficiency with Agile, Asana, communication skills, Confluence, CRM, Google tools, Jira, Monday.com, and cybersecurity essentials.
Learn More
Data Analysis
Learn data analysis with Alteryx, Power BI, Python, SQL, Tableau, and delve into financial modeling, analytics, and business intelligence principles.
Learn More
QuickBooks
Gain the confidence you need to maximize the power of QuickBooks®. Use this popular and easy-to-use accounting program to your benefit.
Learn More
Adobe
Adobe training tutorials for beginner or advanced users. Learn Dreamweaver, InDesign, Photoshop, and Photoshop Elements with Adobe Courses.
Learn More
Web Development
Front-end web training and back-end developer training for complete beginners. Learn HTML, Dreamweaver, PHP, Java, MySQL, Python, and more.
Learn More
Soft Skills Video Shorts
Elevate your career with courses on Communication, Leadership, Personal Development, and Project Management.
Learn More
Skills Targeting
Boost your skills in Excel, PivotTables, and the Microsoft Suite to maximize productivity and efficiency.
Learn More
Pricing & Plans
Get Unlimited access to all 200+ courses on the Simon Sez IT site. That's over 11,000 videos.
Learn More
Certification
Earn a certificate each time you complete a course. Showcase your mastery of in-demand skills to employers.

Microsoft Excel

  • How to Make an Excel Bullet Chart – 2 Easy Examples

    Note: This guide on Bullet Chart in Excel is suitable for Excel 2010 and later versions including Office 365. Excel bullet charts are one of the best ways to represent performance-related data in Excel. Use it to display performance achieved in various parameters and compare it against a set target.  Related:  How To Find Duplicates…

  • Bar Graph in Excel — All 4 Types Explained Easily (Excel Sheet Included)

    Note: This guide on how to make a bar graph in Excel is suitable for all Excel versions.  Bar graphs are one of the most simple yet powerful visual tools in Excel. Bar graphs are very similar to column charts, except that the bars are aligned horizontally.   Related:  How To Find Duplicates In Excel? The…

  • How to Make a Histogram in Excel?—2 Best Methods

    Note: This tutorial on how to make a histogram in Excel is suitable for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, and Office 365 users.  In this guide, I will show you how to create a histogram in Excel, the easy way. Histograms add a power punch to your reports. They are…

  • Excel Quick Analysis Tool – The Best Guide (5 Examples)

    Note: This Guide on Excel Quick Analysis tool is suitable for Excel 2013, Excel 2016, Excel 2019 and Microsoft 365 users. The Excel quick analysis tool is a versatile feature that allows you to instantly analyze your data. Use it when you need to quickly calculate row or column totals and apply conditional formatting. You…

  • How to Use Goal Seek in Excel? (3 Simple Examples)

    Note: This tutorial on how to use goal seek in Excel is suitable for Excel 2010, Excel 2013, Excel 2016, and Office 365 users The Excel Goal Seek feature is one of the easiest ways to solve a single variable problem you are facing. Hurray! You need not use the Excel Solver feature each time,…

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

    Learn how to create a pivot table in Microsoft Excel

  • Excel Conditional Formatting — 9 Best Uses (Bonus Video)

    This Conditional Formatting in Excel tutorial is suitable for users of Excel 2010, 2013,2016,2019, and Microsoft 365.   Objective  Use Excel Conditional Formatting to highlight important data visually and identify patterns and trends.   Excel Conditional Formatting Explained  Have you ever come across beautiful-looking Excel sheets that are visually appealing to the viewer, highlighting important data…

  • The Best Excel Project Management Template in 2021

    Excel templates make everyone’s life easy, more so if you are a project manager. An Excel project management template can be a lifesaver if you have short deadlines & need a report ready in a jiffy. Let’s see why. Completing a project with minimal setbacks and hitches along the way is the ultimate goal of…

  • How to Use Excel COUNTIFS: The Best Guide

    This COUNTIFS in Excel tutorial is suitable for users of Excel 2010/2013/2016/2019 and Microsoft 365.   Table of Contents: Objective  Use the Excel COUNTIFS function to count the number of cells in a range that match one or more criteria.   Excel COUNTIFS Explained  COUNTIFS is a statistical function in Excel. It differs from its closely…

  • 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…

  • How to Protect Cells in Excel Workbooks —5 Easy Ways

    This Protect Excel Workbook tutorial is suitable for users of Excel 2010/2013/2016/2019 and Microsoft 365. Objective Protect Excel Workbook, Worksheets, and protect cells in Excel to help maintain the integrity of the spreadsheet and reduce errors. This guide covers: Table Of Contents Objective  Video Tutorial – Protect Cells in Excel How to protect cells in Excel…

  • 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: Table Of Contents Objective  Excel Dashboards Explained  VIDEO TUTORIAL – EXCEL DASHBOARD Create an Excel Dashboard in 8 Simple Steps FAQs Creating an Excel…

most popular posts

Project Management Methodologies Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
Microsoft Excel How to Count Cells with Text in Excel? 3 Different Use Cases
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)
© 2025 SimonSezIT. All rights reserved.