10 FREE Excel Add-Ins to Boost Your Productivity in 2023
-
Frank
- April 24, 2023
- Advanced Excel tricks
- Excel 2013
- Excel 2016
- Excel 2019
- Excel 365
- excel advanced formula editor
- excel calendar
- excel data picker
- Excel for analysts
- excel free add-in
- excel free data
- excel lambda
- Excel online course
- excel QR code
- Excel tips and tricks
- excel to word
- Leila Gharani
- Microsoft 365
- Microsoft Excel
- Microsoft Excel tutorials
- XelPlus
- XelplusVis
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
Can AI with ChatGPT Properly Solve Your Spreadsheet Problems?
-
Frank
- January 12, 2023
- A.I.
- Advanced Excel tricks
- AI
- chat GPT
- chat gpt excel
- chatGPT
- Excel 2013
- Excel 2016
- Excel 2019
- Excel 365
- Excel for analysts
- excel formula not working
- Excel online course
- excel returns error
- Excel tips and tricks
- get answers
- how to use chatgpt
- Leila Gharani
- Microsoft 365
- Microsoft Excel
- Microsoft Excel tutorials
- solve excel problem
- what is chatgpt
- XelPlus
- XelplusVis
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
How to Use the FILTER Function in Microsoft Excel 2021/365: OR Operator
-
Frank
- November 8, 2022
- Advanced Excel
- Advanced Excel tricks
- dynamic array
- dynamic array function in Excel
- dynamic arrays
- Excel
- excel 2021
- excel 2021 new features
- Excel 365
- Excel Advanced
- excel dynamic arrays
- excel filter function
- excel formulas
- excel functions
- Excel online course
- Excel tips and tricks
- excel tutorial
- FILTER formula
- FILTER function
- FILTER function in excel
- Microsoft Excel
- office 2021
- Office 365
- Office 365 dynamic arrays
- OR operator
- simon sez it
In this Excel 2021 Advanced tutorial video, we discuss how to use a new dynamic array function in Excel, the FILTER function, to filter data based on logic. In this specific example, we teach you how to use the + operator (OR logic).
Read More
How to Build Interactive Excel Dashboards
-
Frank
- July 7, 2022
- business dashboard
- dashboard design
- dashboard excel
- dashboard in excel
- dashboard with excel
- Data Visualization
- Excel
- excel 2021
- Excel 365
- Excel dahsboard
- excel dashboard
- excel dashboard design
- excel dashboards
- excel dashboards and reports
- excel interactive dashboard
- Excel tips and tricks
- how to build excel dashboards
- How to Build Interactive Excel Dashboards
- interactive dashboard
- interactive dashboard excel
- interactive excel dashboard
- sales dashboard
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 Excel PivotTables Explained
-
Frank
- May 17, 2022
- calculated field
- Excel
- excel 2021
- Excel 365
- excel pivot
- excel pivot table
- excel pivot table tricks
- excel pivot tables
- Excel pivottables
- Excel PivotTables Explained
- Excel tips and tricks
- excel tricks
- formatting pivot table
- Grouping PivotTable Data
- learn excel
- pivot table
- pivot table excel
- pivot table from scratch
- pivot table grouping
- pivot table in excel
- pivot table slicers
- pivot tables
- pivottable
- pivottable from scratch
- PivotTable Styles
- Spreadsheets
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
7 Things You’re Doing WRONG in Excel
-
Frank
- February 1, 2022
- Advanced Excel tricks
- Excel 2013
- Excel 2016
- Excel 2019
- Excel 365
- excel edit formula links
- Excel for analysts
- excel merge cells
- excel mistakes
- excel mistakes to avoid
- Excel online course
- Excel tips and tricks
- excel tutorial
- how to
- Leila Gharani
- Microsoft 365
- Microsoft Excel
- Microsoft Excel tutorials
- XelPlus
- XelplusVis
These are common mistakes that just about everyone makes in Microsoft Excel. This video covers things you shouldn’t do in Excel.
Read More
Should You Upgrade to Office 2021?
-
Frank
- October 18, 2021
- Advanced Excel tricks
- Excel 2013
- Excel 2016
- Excel 2019
- excel 2021
- excel 2021 new features
- Excel 365
- Excel for analysts
- excel for office 2021
- Excel online course
- Excel tips and tricks
- Leila Gharani
- Microsoft 365
- Microsoft Excel
- Microsoft Excel tutorials
- ms office 2021
- ms office upgrade
- office 2021
- office 2021 review
- office 365 or 2021
- XelPlus
- XelplusVis
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
How to Create & Use Excel Macros
-
Frank
- April 2, 2021
- Advanced Excel tricks
- Excel
- Excel 2013
- Excel 2016
- Excel 2019
- Excel 365
- Excel for analysts
- excel macros 101
- excel macros advanced
- excel macros and vba
- excel macros for dummies
- excel macros leila
- excel macros vba tutorial
- Excel online course
- Excel tips and tricks
- Excel VBA
- Leila Gharani
- macro
- macros
- Microsoft
- Microsoft 365
- Microsoft Excel
- Microsoft Excel tutorials
- VBA
- XelPlus
- XelplusVis
Leila Gharani shows you how to to enable the Developer Tab, which allows you to record and run macros.
Read More
Use Excel & Power Automate
-
Frank
- March 19, 2021
- Advanced Excel tricks
- Excel 2013
- Excel 2016
- Excel 2019
- Excel 365
- Excel for analysts
- Excel online course
- Excel tips and tricks
- Leila Gharani
- Microsoft 365
- Microsoft Excel
- Microsoft Excel tutorials
- Microsoft Flow
- power automate
- power automate date formats
- power automate excel tutorial
- power automate expressions if
- power automate tutorial
- power automate tutorial excel
- power automate ui flow
- XelPlus
- XelplusVis
Leila Gharani shows us how to combine Microsoft Excel with Power Automate to get more done
Read More
How to Use SEARCH in Outlook to Find Emails FAST!
If you’re like me and rely on the Outlook search functionality to find emails, having long since given up on organizing emails as they come in. Leila Gharani shows us how to *really* use Outlook Search to find emails fast. Search in Microsoft Outlook has improved in 2021. You can now easily find exactly what […]
Read More