Skip to content
FAST TRACK TO POWER BI Course is NOW AVAILABLE. SIGN UP NOW.
Xelplus – Leila Gharani Logo
  • Tutorials
  • Online Courses
  • For Business
  • Resources
  • About Me
  • Log in
  • Tutorials
  • Online Courses
  • For Business
  • Resources
  • About Me
  • Log in

Excel What If Analysis Data Table

Excel's What-if Analysis Data Table allows you to quickly create simulations. This tutorial takes you through a simple example of how you can create a Data Table from scratch. If you've never used this feature, you need to check it out. It's like magic.

December 2nd, 2022|Categories: Features|Tags: Data Table, Emoji, Excel, Matrix, Table, What-If|

4 Excel Settings

Excel comes with default settings and options. You can easily change these by going to File / Options. Why should you? To support your workflow and be more productive. This post has my list of options you need to review.

August 25th, 2022|Categories: Features|Tags: AutoCorrect, Custom Lists, Excel, Getting Started, Leading Zeroes, Navigation, Settings, Startup|

Excel Organizational Data Types

Organizational data types allow you to create your own rich custom data types in the Excel Ribbon. Technically you‘d create them in Power BI and have them show up in the Excel Menu of your team members. This tutorial show you what organizational data types are and you can set them up from scratch.

June 3rd, 2022|Categories: Features, Other Apps, Uncategorized|Tags: Data Connector, Data Types, Gateway, Power BI|

Excel VSTACK Function

This is a real-life example of Excel's VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.

May 27th, 2022|Categories: Dynamic Arrays, Features|Tags: 3D Formula, 3D Range, Dynamic Arrays, Filter, Sort, VBA, VSTACK|

Excel Pivot Table Date Grouping

Handling dates in Excel Pivot Tables can get tricky. How can you quickly ungroup the dates? Or get your own custom grouping for fiscal periods? How can you show all the dates including the ones with no values? This tutorial covers it all!

May 19th, 2022|Categories: Features|Tags: Calendar, Calendar Table, Data Model, Date, Date Group, Group, pivot table, PivotTable, Relationship|

Lock and Unlock Cells in Excel

Lock & Unlock Cells in Microsoft Excel If you create spreadsheets for other people to use, you may have some experience with those people deleting or changing your formulas or other aspects of your workbook. Not only is it frustrating to have

April 21st, 2022|Categories: Features|Tags: Find, Find All, Format Cells, Lock, Protect, Protection, Unlock|

Excel Advanced Formula Editor Lambda

The new Microsoft Excel Advanced Formula Add-in makes it easy to write and manage LAMBDAs in Excel. It's a "new" version of Name Manager and hopefully it could replace Name Manager in the future.

March 4th, 2022|Categories: Features, Formulas|Tags: Advanced Formula Editor, Advanced Formula Environment, Editor, LAMBDA, Name Manager|

Searchable Drop-Down Lists in Excel

It takes ZERO effort to now get searchable drop-down lists in Excel. Excel's data validation list now offers autocomplete by default. Empty cells are skipped too! This is all for desktop and online version. Check out this post to find out more.

January 27th, 2022|Categories: Features|Tags: data validation, Drop-down, Dropdown, Exce;|

Excel tips & tricks – stop doing these 7 things in Excel

Don't merge cells in Excel - Don't Copy Excel sheets without updating links - Don't hide rows and columns! There are better ways of doing these things. Find out 7 things you're doing wrong in Excel and how to do it correctly.

January 27th, 2022|Categories: Accounting, Charts, Dashboards, Features, Formulas, Uncategorized|

How to Use Power BI

Get started with Power BI now by creating your first dashboard. Download the free files, follow along and in 20 minutes you'll have setup your interactive dashboard which you've published to the web!

December 16th, 2021|Categories: Dashboards, Features, Other Apps, Power Query & Power Pivot|
12Next
Subscribe to my Newsletter | Copyright 2020 XelPlus.com | All Rights Reserved | Impressum | Privacy Policy
LinkedInYouTubeTwitter