Excel for analysts

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
Microsoft

7 Things You’re Doing WRONG in Excel

These are common mistakes that just about everyone makes in Microsoft Excel. This video covers things you shouldn’t do in Excel.

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
Data

How to Create & Use Excel Macros

Leila Gharani shows you how to to enable the Developer Tab, which allows you to record and run macros.

Read More
Power Apps

Use Excel & Power Automate

Leila Gharani shows us how to combine Microsoft Excel with Power Automate to get more done

Read More
Microsoft

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
Data Microsoft

How To Import & Clean Messy Accounting Data in Excel | Use THIS to Import SAP Data

In this Excel for Accounting tutorial from Leila Gharani  you’ll learn how to use Power Query to import messy SAP data extracts into Excel. Importing data from ERP systems like SAP or Oracle into Excel can be a pain. The data is usually very messy. You need to clean and organize the data to be […]

Read More
Data Microsoft

How to Get Latest Stock Data in Excel & Create Your Own Stock Portfolio

Leila Gharani teaches us to pull live stock data in Excel with Stock data types. With Excel’s stock data feature you can get live stock information. Stock data types allows users to quickly pull stock information into Excel from various exchanges. In this tutorial I’ll show you how you can pull data related to stocks, […]

Read More
Data Developer

How to Create Loops with Zero Coding with Excel’s Recursive Lambda

Leila Gharani explores new Excel LAMBDA Function further. [The Recursive Lambda function] allows you to create your own CUSTOM FUNCTION without any coding. In this tutorial we’ll take it to the next level and I’ll show you how you can create a RECURSIVE Lambda in Excel. This is a function that’s continuously looping through your […]

Read More
Powered by WordPress | WP Travel Magazine by WP Mag Plus