- 83
- 225 491
Premier Training Hub
Приєднався 19 лип 2022
Premier Training Hub is started by Ankur Gupta, who is a CFA Charterholder (USA) and an MBA from one of the prestigious colleges in India. Ankur has a corporate experience of 13+ years as a Financial Strategist and a Data Expert and has a stronghold over a lot of Academic & Professional Tools, Microsoft Excel being his favourite tool. He believes a lot of what you can achieve with Excel is never taught in college or ever understood in professional working environement, and the channel aims to cover all such things in every minute detail, with its videos. So stay tuned, discover your inquisitive side and be a part of this insightful journey with him.
Top Latest & Exciting New Feature Additions to Microsoft Excel (2023)
With every feature update, Excel is becoming better than ever. There is so much today, that we can do in excel which at one time seemed impossible. This video will cover the latest excel features that Microsoft added in the previous few months and how they have been a game change for excel users.
Contents:
0:00 Whats inside!
0:19 The new search box for Excel Menu
1:22 Copy arithmetic data from status bar
2:44 Check formulas with value tooltip
3:40 New Keyboard Shortcut to paste values
4:32 Load dynamic arrays to power query
7:48 New keyboard shortcut for power query
8:14 Create your own nested data types
11:31 The best AI Tool / Analyse tab
12:54 Share a section of the workbook
Watch the best excel tricks and techniques here:
Top Excel Tricks (Part 1):
ua-cam.com/users/videoohURr7RwFBQ
Top Excel Tricks (Part 2):
ua-cam.com/video/-6Rv4klc4uw/v-deo.html
Best Wishes
Ankur Gupta
Contents:
0:00 Whats inside!
0:19 The new search box for Excel Menu
1:22 Copy arithmetic data from status bar
2:44 Check formulas with value tooltip
3:40 New Keyboard Shortcut to paste values
4:32 Load dynamic arrays to power query
7:48 New keyboard shortcut for power query
8:14 Create your own nested data types
11:31 The best AI Tool / Analyse tab
12:54 Share a section of the workbook
Watch the best excel tricks and techniques here:
Top Excel Tricks (Part 1):
ua-cam.com/users/videoohURr7RwFBQ
Top Excel Tricks (Part 2):
ua-cam.com/video/-6Rv4klc4uw/v-deo.html
Best Wishes
Ankur Gupta
Переглядів: 594
Відео
Excel’s Watch Window: A Must know feature for Large Files & Complex Financial Models
Переглядів 484Рік тому
If you are working on a large file containing several sheets, and some of those sheets contain various inputs, while some sheets contain formulas or output values and you want to track all outputs together at one single place, then you have to use Excel Watch window. Its super easy to apply and you can see all changes to your cells and sheets, dynamically in a single window that can be accessed...
Create NLOOKUP () function to find n'th occurrence of lookup value (something even XLOOKUP cant do)
Переглядів 1,4 тис.Рік тому
We now have the Xlookup function in Excel 365 which is great replacement for Vlookup. But there is one thing which I believe should have been added to the Xlookup function i.e. return output for the nth occurrence of a lookup value. But thanks to excel, this can still be done using the new lambda function. So lets create our own Nlookup function to take care of this problem. Timestamps: 0:00 Wh...
Learn to create and manipulate ‘3D Named Ranges’ in Excel (Includes a Bonus VBA Code)
Переглядів 415Рік тому
A named range usually takes input from one single sheet, but excel provides you the option to create a 3D Named Range as well, which takes input from multiple sheets and perform required operations on the collected data. A 3D Named Range is particularly useful in scenarios where you have multiple data points for a single item, in multiple sheets, and you want to add all data points. For ex, you...
Learn the best methods to create 3 types of Waffle Charts in Excel
Переглядів 188Рік тому
Bored of using the same charts again and again in excel? Me too. That’s why I am sharing my analysis on how to create a waffle chart using 3 innovative excel techniques. With this video, you will learn all 3 techniques in detail and understand the pros and cons of each technique, and also when to use either of these techniques. This video will also provide a VBA technique to create this chart, ...
10 Practical Uses of Excel’s Unique () Function
Переглядів 420Рік тому
Unique function works quite well with the data cleaning functions like TRIM () & CLEAN () in excel. It is also a great match for FILTER () & SORT () functions. In this video, we are going to practice 10 different examples, where we will cover the basics and advanced uses of this function and also we will see how to combine UNIQUE function along with several other important functions in excel, a...
Powerful Pivot Trick: Join multiple sheets with Excel Query Connections & create unique pivot table
Переглядів 724Рік тому
Lets learn another useful and advanced pivot table trick in this video. Combining data from several files into one file is not the same as combining data from several sheets, all of which are in a single file. To create a pivot table from multiple sheets in a single file, you have to create query connections in Power Query. Now this is very easy to do and involves just 2 steps. Even if you don’...
The underrated Hyperlink Function in Excel: Combine with a simple VBA code to unleash its full power
Переглядів 719Рік тому
Do you use Hyperlink Function in Excel? Well, I use it quite often in my reports because it enables me to present data in a very simple and easy to read manner. Also, it does something which no other formula in excel can do. It can detect your mouse location, and perform operation without clicking on any cell or pressing enter. Confused? Well don’t be, just watch the video and learn . Download ...
Excel Flash Fill Automation Trick: Create Appraisal Letters for entire company in 1 minute
Переглядів 260Рік тому
There are a lot of inbuilt Artificial Intelligence / AI Tools in Excel. Flash Fill is one of these tools and this video will tell you how can you automate a lengthy, boring and routine office task and get it done quickly. We will learn how to write, customise and print letters for every employee of a company (size of the company does not matter) and achieve the same with lightening speed.
Sequence Function: Create Sequential List of Dates, Weekdays & Months in Excel with Best Examples
Переглядів 2,7 тис.Рік тому
There are 3 ways to create sequential lists in excel (Control Drag, Fill Series & Sequence Function). All of them are great but Sequence function provides the added advantage of being more user friendly and makes it easier to edit your list, if needed. Also, its a latest function and you must learn it. Lets cover two examples, where we will learn how to combine Sequence Function with other func...
TAKE () Function in Excel (Learn its real use & how to combine it with other functions in excel)
Переглядів 576Рік тому
Why did excel create TAKE function in Microsoft 365 ! Lets figure out the exact need of this function and its real use with an example. In the process, we will learn how to combine it with other functions in excel like SORT (), FILTER () to achieve desired analysis output.
Correct Wrong Totals for Filtered Items in Pivot Tables (Use Filtered Items with Excel Data Model)
Переглядів 2,9 тис.Рік тому
Lets get rid of one more pivot table related issue in this video. The default calculations in pivot tables ignore all those items which are filtered out from the Row Labels. If you filter out one item, the result for other items can get modified incorrectly without your consent. If left unnoticed, this can create wrong results. Lets have a look at this problem in detail in this video and find a...
DGET () & DSUM () Function: Overcome limitations of VLOOKUP & SUMIFS with database function in Excel
Переглядів 1,2 тис.Рік тому
Its been more than 15 years since Excel introduced the Database Functions. Then why don’t we use them? Some of the frequent problems faced with commonly used functions like Vlookup & Sumifs can be solved easily with the help of database functions. In this video, we will explore those frequent problem scenarios and how we can replace other functions with database functions to find easy solutions...
The Least Known Excel Trick: Use Hash sign (#) to create Unique & Dynamic Drop Down Lists
Переглядів 552Рік тому
Its 2023 and you have to keep yourself updated with all new functions, formulas and techniques Excel is offering you. Lets learn a must know, but at the same time very little known, data validation hack in this short video.
Build Stock Management Tool with Fully Automated Sales, Purchase and Stock Register (in Excel)
Переглядів 350Рік тому
Today is the world of automation and there are a lot of analytical softwares available in the market. But still Microsoft Excel remains the most used analytical tool across the world. Its important that we know everything that can be done in the field of automation using Excel. Lets focus on one such example and create a fully automated stock management tool in excel by utilising excel’s unique...
Create Attractive Doughnut / Pie Charts for Presentations & Dashboards
Переглядів 150Рік тому
Create Attractive Doughnut / Pie Charts for Presentations & Dashboards
The Latest Pivot Table Advanced Trick (Create 2 timelines on a single pivot table)
Переглядів 1,2 тис.Рік тому
The Latest Pivot Table Advanced Trick (Create 2 timelines on a single pivot table)
10 Cool Chart Tricks in Excel to build creative Dashboards & Presentations
Переглядів 667Рік тому
10 Cool Chart Tricks in Excel to build creative Dashboards & Presentations
The New ‘Expand’ Function in Excel | Create Datasets Quickly with Expand Function | Best Explanation
Переглядів 4,5 тис.Рік тому
The New ‘Expand’ Function in Excel | Create Datasets Quickly with Expand Function | Best Explanation
Exclusive Charts in Google Sheets: Organisational Chart & Gauge Chart/ Speedometer Chart
Переглядів 304Рік тому
Exclusive Charts in Google Sheets: Organisational Chart & Gauge Chart/ Speedometer Chart
Pivot Table Printing Hack: Organise & Print Large Data Systematically using ‘Item wise Page Breaks’
Переглядів 3,1 тис.Рік тому
Pivot Table Printing Hack: Organise & Print Large Data Systematically using ‘Item wise Page Breaks’
The Inbuilt Data Consolidation Tool in Excel: Combine Multiple Reports into One Single Report
Переглядів 1,2 тис.Рік тому
The Inbuilt Data Consolidation Tool in Excel: Combine Multiple Reports into One Single Report
Learn all 3 methods of Recording Macros in Excel (Absolute, Relative, By Selection) with Examples.
Переглядів 2 тис.Рік тому
Learn all 3 methods of Recording Macros in Excel (Absolute, Relative, By Selection) with Examples.
10 Essential Time Saving Tips for Microsoft Excel
Переглядів 1 тис.Рік тому
10 Essential Time Saving Tips for Microsoft Excel
Dynamic Excel Charts Trick: Add Automated Data Labels to any Chart
Переглядів 3,2 тис.Рік тому
Dynamic Excel Charts Trick: Add Automated Data Labels to any Chart
Learn these Hidden Features to filter Dates in Excel Pivot Tables
Переглядів 1,3 тис.Рік тому
Learn these Hidden Features to filter Dates in Excel Pivot Tables
Learn to use 'Solve Order' to correct unwanted mistakes in Pivot Table Calculated Fields
Переглядів 1,3 тис.Рік тому
Learn to use 'Solve Order' to correct unwanted mistakes in Pivot Table Calculated Fields
Use ChatGPT to create a Gauge Chart / Speedometer Chart in Excel
Переглядів 1,4 тис.Рік тому
Use ChatGPT to create a Gauge Chart / Speedometer Chart in Excel
Learn how to manipulate dates with the important date functions in Excel
Переглядів 686Рік тому
Learn how to manipulate dates with the important date functions in Excel
Best way to create the Sales & Margin Growth Chart in Excel (4 charts combined into 1 chart)
Переглядів 30 тис.Рік тому
Best way to create the Sales & Margin Growth Chart in Excel (4 charts combined into 1 chart)