Excel 365

AI

How to Use ChatGPT with Excel for Macros & Formulas!

In this Excel tutorial, Simon Sez IT dives into leveraging ChatGPT to streamline Excel tasks like creating macros, VB, and formulas. Learn the distinction between macros and VBA and how to generate efficient solutions. Discover how to separate first and last names effortlessly using ChatGPT’s formulas. Explore the power of macros by automating tasks like […]

Read More
Microsoft

Excel’s NEW Checkboxes Are Incredibly Cool! Here’s why

In this video, Leila Gharani. will introduce you to the brand-new checkboxes in Excel. They’re simple and much better than the old ways we used to do things. I’ll take you through different ways to use these checkboxes, not just for keeping track of your to-do list.

Read More
Microsoft

10 FREE Excel Add-Ins to Boost Your Productivity in 2023

In this video Leila Gharani covers the 10 best, free add-ins for Microsoft Excel. Tools to easily embed mind maps or shopfloor layouts, an Excel calendar date picker, a free Excel add-in to get free data, translate Excel function names, create your custom Lambda function, add QR codes to Excel, automate Excel to Word file […]

Read More
AI

Can AI with ChatGPT Properly Solve Your Spreadsheet Problems?

Leila Gharani  sees if Chat GPT can solve complex Microsoft Excel spreadsheet problems. Chat GPT, the new, viral AI chatbot by Openai is a type of artificial intelligence that can understand and generate natural language text.

Read More
Data Microsoft

Top 8 New Features in Microsoft Excel | Updates in MS Excel 365 Desktop and Web

Here’s a Microsoft Excel tutorial will show you the top 8 new features in Microsoft Excel in 2022. These new MS Excel tips and tricks include the IMAGE function, Import picture from Camera, improved Pivot Table recommendations and lots more. Updates cover Desktop and web. These time-saving new features in Microsoft Excel are rolling out […]

Read More
Data

How to Build Interactive Excel Dashboards

In this Microsoft Excel 2021/Excel 365 training tutorial video, learn how to create an Excel Interactive Dashboard. We’ll go over what a dashboard is and discuss in-depth how to assemble an interactive dashboard for your data visualization including adding calculations, charts and graphs, formatting, and more! We finish off with an exercise to test what […]

Read More
Microsoft

Microsoft Excel PivotTables Explained

In this Microsoft Excel 2021/Excel 365 training tutorial video, learn all about Excel PivotTables. We’ll go over creating a PivotTable from scratch and discuss the different elements of a PivotTable! Learn how to pivot a field, add totals, format numbers and errors, choose a report layout, apply formatting styles, and more! We finish off with […]

Read More
Data Microsoft

Should You Upgrade to Office 2021?

Microsoft just released Office 2021 which is available for both macOS and Windows. It’s made for those who do not want to enroll in the subscription model of Microsoft 365. For Excel users this is a huge jump from Excel 2016 or Excel 2019. At least 9 new functions were introduced which will change the […]

Read More