A2 Excel, Stats and Finance
A2 Excel, Stats and Finance
  • 35
  • 502 665
The Full Guide to Pivot Tables, Charts and Dashboards in Excel - Part 1
Get the File here: a2excel.com/webinar-class-1-pivot-tables-in-excel.html
In this video we're going to learn, step by step, how to do pivot tables, charts and Dashboards in Excel.
This complete guide will take you through all of the essential elements that are necessary for you to become an absolute master of pivot tables and charts.
At the end of the video, you'll be able to combine slicers, pivot tables, excel tables, charts, and formulas to create an amazing interactive excel dashboard that will wow your friends and coworkers.
Переглядів: 7 464

Відео

Part 2 The Full Guide to Pivot Tables, Charts and Dashboards in Excel - Part 2
Переглядів 2,6 тис.5 років тому
Get the File here: a2excel.com/webinar-class-1-pivot-tables-in-excel.html In this video we're going to learn, step by step, how to do pivot tables, charts and Dashboards in Excel. This complete guide will take you through all of the essential elements that are necessary for you to become an absolute master of pivot tables and charts. At the end of the video, you'll be able to combine slicers, p...
Full Excel Tutorial - 11/12 - Excel Macros and VBA - Automate your job away!
Переглядів 4845 років тому
Macros are a fundamental part of an advanced Excel User’s toolbox. They are an entire topic unto themselves and thus, we’ll only cover the basics here. Macros will let you automate away any bothersome Excel tasks that are repetitive and don’t require much cognitive ability. Macros can be either recorded or programmed in VBA. It is precisely because of the programming part that Macros become an ...
Full Excel Tutorial - 5/12 - Pivot Charts: Make Awesome presentations
Переглядів 4545 років тому
Pivot Charts are the complement of Pivot Tables in Excel. With Pivot Charts you can whip up incredible charts in a matter of seconds as long as the data is properly prepared. They’ll allow you to create Bar, Pie and Line charts. In this video we’ll cover how to create an elemental chart with the Pivot Chart tool, add the formatting and even insert a slicer to filter out the data. By the end of ...
Full Excel Tutorial - 1/12 - Excel for Absolute Beginners
Переглядів 2,9 тис.5 років тому
Excel is really simple to use! In this video we’ll learn the very very very basics of Excel: what is a cell? A column? A row? And more in Excel. We’ll start off with basic navigation and selection, along with the essential Excel menus. We’ll progress to creating a very simple budget and elemental formulas. At the end of the video you should be able to navigate confidently with Microsoft Excel, ...
Full Excel Tutorial - 2/12 -Formula References in Excel - Absolute and Relative
Переглядів 1,2 тис.5 років тому
Excel was created with one purpose in mind: to perform massive amounts of operations. In order to perform every calculation, you want, you have master the art of cell references in Excel. There are two types of cell references in Excel: relative references and absolute references. These references behave differently when operations are copied and filled down to to ther cells. The Relative refer...
Full Excel Tutorial - 6/12 - Excel Tables: Excel’s most underrated tool
Переглядів 4465 років тому
Excel tables are probably Excel’s best kept secret. They are an essential part of working with pivot tables, pivot charts and even power pivot. Excel tables will allow you to define an area as a Table Object in Excel, complete with it’s own name and reference system. From here, when you add extra data to the table, the Table Object will expand to accommodate these new items. This means than whe...
Full Excel Tutorial - 9/12 - Sumif And Sumifs: Formulas for true advanced
Переглядів 4595 років тому
Sums are the workhorse of Excel formulas. There’re also the Sums lesser known, more complicated siblings: SumIf and SumIfs. In this video we’ll cover all three. We start by assuming you already know how to do sums, but do you know how to do AutoSums with your keyboard? We’ll be covering how to perform complicated =SUM() functions with a single Keyboard action. Next we’ll move on to SumIF. This ...
Full Excel Tutorial - 4/12 - Pivot Tables: All you need to know
Переглядів 7565 років тому
Pivot tables are the beating heart of Excel. They’ll allow to perform all kinds of complicated operations in the easiest manner possible. Most of your time as analyst will be spent on Pivot Tables in Excel. They are really easy to use and don’t take long to master. In this video we’ll cover the very basics of the pivot table and how to get a proper pivot table up and running. By the end of the ...
4 of Excel's Best Kept Secrets
Переглядів 3115 років тому
In this video we’ll learn about the 4 best kept secrets of Excel. We’ll start with the NetWorkDays function in in Excel, which serves to obtain the working days between 2 dates. We will also see NetWorkDays.int in Excel, which serves to obtain the working days between 2 dates where the weekend changes and there are holidays. We will then go to the Prediction function, which serves to identify t...
Difference between SUM vs SUMX in Power BI and Power Pivot
Переглядів 3605 років тому
Sum and Sumx are 2 of the most important functions in the DAX language of power BI and Power Pïvot. Do you really know the difference? In this video we will see how to apply the SUM function in the occasions that merits it in Power BI, and the SUMX function in the more complex occasions that SUMX can handle for us. SUM Used to make simple sums on a column. It does not allow any flexibility or a...
Full Excel Tutorial - 8/12 -The Definitive guide to Vlookup! Learn Vlookup, and Approximate Matches
Переглядів 3445 років тому
Vlookup is the king of Excel formulas! It’s popular for two reasons: 1. Its main function as a lookup tool. Vlookup will allow you to extract specific data from massive tables, and even cross reference entire tables between one another. 2. It’s also a very clear dividing line between “starting” and “power” Excel users. Inverviewers will usually gauge your Excel prowess based on your proficiency...
Full Excel Tutorial - 7/12 - The complete Guide to IF function, nested if and IFS function in Excel
Переглядів 5845 років тому
The IF function in Excel is probably the most important functions you can learn. Mastering IF is as essential as simple addition, subtraction and multiplication in Excel. What is it good for? It will let you decide the output of a formula based on whether a criterion is met or not. Basically an “if this is true, then do this, otherwise, do that” kind of scenario. It’s very, very simple to apply...
Conditional Formatting with Power BI and DAX
Переглядів 38 тис.5 років тому
In this video we will learn to use conditional format with Power BI and DAX. Although conditional formatting tools in Power BI can be interesting, this application goes far beyond that. We’ll understand how to build a ranking based conditional formatting where we can show the top n products or the worst products, illuminating them with the color we want. To achieve our goals, we will learn to u...
Ace the Excel Technical Interview Get the job you want
Переглядів 1385 років тому
It’s quite common to have to present an Excel exam for the technical interview portion of a new job. In this video, we’ll see an Admission Exam for a big multinational supplier that boasts GM as their main client. The Excel level that’s necessary for this position is not complicated or advanced, you just need pivot tables and formula basics. All very simple. What people find most complicated in...
Excel Scenario Manager: Forecast the future!
Переглядів 1,4 тис.5 років тому
Excel Scenario Manager: Forecast the future!
The Complete Guide to Printing in Excel without losing your mind
Переглядів 3095 років тому
The Complete Guide to Printing in Excel without losing your mind
Compare Columns with Vlookup and Excel
Переглядів 5285 років тому
Compare Columns with Vlookup and Excel
3 Different types of Drop Down lists in Excel! Essential for your job!
Переглядів 3435 років тому
3 Different types of Drop Down lists in Excel! Essential for your job!
Solver in Excel is easy! You need to master it if you are an engineer!
Переглядів 1605 років тому
Solver in Excel is easy! You need to master it if you are an engineer!
Learn how to program practical UserForms with Excel and VBA, Fast!
Переглядів 2195 років тому
Learn how to program practical UserForms with Excel and VBA, Fast!
Create amazing Dashboards with Power BI and Excel
Переглядів 5375 років тому
Create amazing Dashboards with Power BI and Excel
5 Must-Know Formulas in Excel (These will get you a job!)
Переглядів 2635 років тому
5 Must-Know Formulas in Excel (These will get you a job!)
Full Excel Tutorial - 3/12 - Impress your boss with these 7 Essential Excel Tricks
Переглядів 2,4 тис.5 років тому
Full Excel Tutorial - 3/12 - Impress your boss with these 7 Essential Excel Tricks
DistinctCount in Excel
Переглядів 5395 років тому
DistinctCount in Excel
Essential Skill with Excel: Expiration Alerts with Conditional Formatting
Переглядів 276 тис.5 років тому
Essential Skill with Excel: Expiration Alerts with Conditional Formatting
Full Excel Tutorial - 10/12 - Index and Match with Excel ¿The Vlookup Killer?
Переглядів 7165 років тому
Full Excel Tutorial - 10/12 - Index and Match with Excel ¿The Vlookup Killer?
Create Stunning 3D maps in Excel (really simple to use)
Переглядів 16 тис.6 років тому
Create Stunning 3D maps in Excel (really simple to use)
Excel Date tricks you NEED to know.
Переглядів 1,5 тис.6 років тому
Excel Date tricks you NEED to know.
Easy Intro to Financial Math with Excel - Pt 2 Investment Math
Переглядів 2156 років тому
Easy Intro to Financial Math with Excel - Pt 2 Investment Math

КОМЕНТАРІ

  • @dianamamawal4664
    @dianamamawal4664 25 днів тому

    Does anybody know how to cite the map generated from this 3d feature in an APA format?

  • @EmilyOsborne-y3h
    @EmilyOsborne-y3h Місяць тому

    Lol "Mordor" and "Gorbag the Orc"; very good.

  • @ElMakk_Med
    @ElMakk_Med Місяць тому

    i was really mad & angry trying to solve this problem , that trick Text to columns saved me, thank you from morocco 😛

  • @Surfingandy111
    @Surfingandy111 2 місяці тому

    Incredible. How the command "Text to Columns" fixes the date issue is beyond me, but it worked. I was about to go insane fixing it.

  • @maxsablosky
    @maxsablosky 3 місяці тому

    Bro that text to columns move is insane!! Fixed my whole model thanks!!!!

  • @my_commenting_account
    @my_commenting_account 3 місяці тому

    does this work the same when your source table is crosstabbed by date (dates are the column headers, not a column value)? i cant seem to group my column headers as they are showing as "sum of" fields even though nothing is being grouped

  • @taiwoayeni6122
    @taiwoayeni6122 4 місяці тому

    THANKS FOR THIS VIDEO.

  • @zehanfarzana2762
    @zehanfarzana2762 5 місяців тому

    Thanks for the excellent guidelines.

  • @COCOCOCO-bp7vn
    @COCOCOCO-bp7vn 5 місяців тому

    Great job.Thank you

  • @jozefchromy8044
    @jozefchromy8044 8 місяців тому

    thumb up for the tutorial, but to join you, you would have to learn how to zoom your tutorial - think about you viewers man, after all not everyone has a 20/20 vision and then it becomes a struggle to watch. Some tutorials pay great attention to show, up close the viewer, what they want to convey to them that is kudo for them but this......... Greetings

  • @NishanAman-h2m
    @NishanAman-h2m 8 місяців тому

    is todays date update automatically day by day?

  • @fakdolan
    @fakdolan 8 місяців тому

    So easy to follow, you're a great teacher, ty!

  • @hakiinmohamud9852
    @hakiinmohamud9852 9 місяців тому

    Thank you so much. Great Video!

  • @vipuljain3179
    @vipuljain3179 9 місяців тому

    Just Brilliant

  • @Odawg421
    @Odawg421 10 місяців тому

    Great video. This is getting me closer to what I’m looking for. In this example that you’ve created, is there a ways to calculate the remaining days excluding weekends and/or holidays?

  • @SenthilKumar-xu9fb
    @SenthilKumar-xu9fb 10 місяців тому

    This Video is very useful. I have try for using this formula for maintaining chemical expiry monitoring. is is fine and working good. Thanks

  • @credencehomehealthservices
    @credencehomehealthservices 11 місяців тому

    THANK YOU

  • @KareemAdel-c5k
    @KareemAdel-c5k 11 місяців тому

    Hii, Thank you for this video, can you help me how i can receive and email in gmail once the value got About to expire ?

  • @danbello4728
    @danbello4728 11 місяців тому

    nice really helped me

  • @jonatancohen
    @jonatancohen Рік тому

    Amazing video bro. Thanks. Very clear

  • @michaelangelocapistrano26

    Right is correct, left is wrong. Nothing political here😂

  • @LeahHunter-y2l
    @LeahHunter-y2l Рік тому

    Could you maybe leave out the pretentious attitude and focus on the learning?

  • @etherlords88
    @etherlords88 Рік тому

    didn't work for me, I'm getting multiple 1s , no 2, multiple 3s, 4s and so on.

  • @abigailquilarto
    @abigailquilarto Рік тому

    hi! is it possible to have a date filter after grouping the dates by years? thanks. i can't move on with this error.

  • @786NOUSHAD
    @786NOUSHAD Рік тому

    Thank you so much for you training your so kind and its very easy to understand

  • @Hucklebrau
    @Hucklebrau Рік тому

    I can do this easily in the local app. But the online version does not show a [Group] option in the right-click menu. What now?

  • @thesalesforcecoach
    @thesalesforcecoach Рік тому

    Best explanation on the entire internet!

  • @vinaynagaonkar8592
    @vinaynagaonkar8592 Рік тому

    Its a wonderful tool, Thank you very much, God Bless You

  • @garimajain5907
    @garimajain5907 Рік тому

    life Saver video, thanks a lot!

  • @audjau8150
    @audjau8150 Рік тому

    Thank you very much😇, you help me to solve my problem with my data. it was a nightmare since 2 days to find a solution with my 10000 rows 🧐🤓

  • @kenji4955
    @kenji4955 Рік тому

    Thank you my friend! Good stuff! IVery much like your sense of humor. Please allow me to share one more simple way of doing "Only Month" without vlookup, by using formula "=datevalue(A2&1)"🙂

  • @joelmorales534
    @joelmorales534 Рік тому

    Thanks for the video. I finally solved my errors in grouping a date :)

  • @raheelkhokhar46
    @raheelkhokhar46 Рік тому

    Great Sir, What a beautiful and detailed explanation, love it. Thanks

  • @AmarFemco
    @AmarFemco Рік тому

    Useful video

  • @Tat-cx1lr
    @Tat-cx1lr Рік тому

    Très intéressant merci

  • @WenboCanadaImmigration
    @WenboCanadaImmigration Рік тому

    thanks a lot

  • @darshanawajira3826
    @darshanawajira3826 Рік тому

    Thanks

  • @Wealth_Focus
    @Wealth_Focus Рік тому

    You're cocky 😝 but very very good 👍. Thanks for saving me. I've spent an entire day trying to fix this. You're the best. I've done myself a favor by subscribing to your channel. Thanks 🙏 once again. Mmmmuuuuuaaaaaaa 😘💋

  • @pavelbursa9247
    @pavelbursa9247 Рік тому

    Great video! I do not like approximate match, as I do not know the algorithm and the result may be unexpected. Also, i need something, to give me weekly timeline with missing datapoints filled with zeros. Group by 7 days creates insanely long data labels for horizontal axis for chart. Last resort is to merge datapoint dates with generated simple calendar with all dates in power query.

  • @stephenedmondson8173
    @stephenedmondson8173 Рік тому

    Holy crap the audio difference between your voice over and brand intro is insane - I nearly had a heart attack. Good video though.

  • @JacobBogovefa-bb4os
    @JacobBogovefa-bb4os Рік тому

    i like it, really helpful however its not clear enough to see.

  • @observer8291
    @observer8291 Рік тому

    Thank you very much

  • @CryptoAirDrop.0
    @CryptoAirDrop.0 Рік тому

    Can it give me notification reminder

  • @trentorhu7587
    @trentorhu7587 Рік тому

    Hi. Will this work on Google Sheets?

  • @AbdulrahmanAlahdal-lc3wz
    @AbdulrahmanAlahdal-lc3wz Рік тому

    Thank you so much the video was really helpful and explained it in a very clear and easy way.

  • @johnwatson3521
    @johnwatson3521 Рік тому

    Companies that work on a fiscal calendar year instead of a normal calendar year is my special period issue. Unless there is another way? This will work! Thank you!

  • @aniketgangakhedkar7101
    @aniketgangakhedkar7101 Рік тому

    Awesome video man

  • @imransiyal801
    @imransiyal801 Рік тому

    Well Done Sir.

  • @NicoLas-yu8rh
    @NicoLas-yu8rh Рік тому

    You're a star! 👍

  • @jasminehang2820
    @jasminehang2820 Рік тому

    This video was so easy to follow. I have finally found one that I can easily understand and not get confused.