A2 Excel, Stats and Finance
A2 Excel, Stats and Finance
  • Видео 35
  • Просмотров 485 211
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 315

Видео

Part 2 The Full Guide to Pivot Tables, Charts and Dashboards in Excel - Part 2
Просмотров 2,5 тыс.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!
Просмотров 4795 лет назад
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
Просмотров 4435 лет назад
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,1 тыс.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
Просмотров 4405 лет назад
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
Просмотров 4365 лет назад
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
Просмотров 7445 лет назад
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
Просмотров 3055 лет назад
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
Просмотров 3445 лет назад
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
Просмотров 3375 лет назад
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
Просмотров 5655 лет назад
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
Просмотров 37 тыс.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
Просмотров 1275 лет назад
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,3 тыс.5 лет назад
Excel Scenario Manager: Forecast the future!
The Complete Guide to Printing in Excel without losing your mind
Просмотров 3025 лет назад
The Complete Guide to Printing in Excel without losing your mind
Compare Columns with Vlookup and Excel
Просмотров 5105 лет назад
Compare Columns with Vlookup and Excel
3 Different types of Drop Down lists in Excel! Essential for your job!
Просмотров 3325 лет назад
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!
Просмотров 1545 лет назад
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!
Просмотров 2105 лет назад
Learn how to program practical UserForms with Excel and VBA, Fast!
Create amazing Dashboards with Power BI and Excel
Просмотров 5345 лет назад
Create amazing Dashboards with Power BI and Excel
5 Must-Know Formulas in Excel (These will get you a job!)
Просмотров 2605 лет назад
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,3 тыс.5 лет назад
Full Excel Tutorial - 3/12 - Impress your boss with these 7 Essential Excel Tricks
DistinctCount in Excel
Просмотров 5355 лет назад
DistinctCount in Excel
Essential Skill with Excel: Expiration Alerts with Conditional Formatting
Просмотров 265 тыс.5 лет назад
Essential Skill with Excel: Expiration Alerts with Conditional Formatting
Full Excel Tutorial - 10/12 - Index and Match with Excel ¿The Vlookup Killer?
Просмотров 7105 лет назад
Full Excel Tutorial - 10/12 - Index and Match with Excel ¿The Vlookup Killer?
Create Stunning 3D maps in Excel (really simple to use)
Просмотров 15 тыс.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
Просмотров 2036 лет назад
Easy Intro to Financial Math with Excel - Pt 2 Investment Math

Комментарии

  • @maxsablosky
    @maxsablosky 28 дней назад

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

  • @my_commenting_account
    @my_commenting_account 29 дней назад

    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 Месяц назад

    THANKS FOR THIS VIDEO.

  • @zehanfarzana2762
    @zehanfarzana2762 2 месяца назад

    Thanks for the excellent guidelines.

  • @COCOCOCO-bp7vn
    @COCOCOCO-bp7vn 3 месяца назад

    Great job.Thank you

  • @jozefchromy8044
    @jozefchromy8044 5 месяцев назад

    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

  • @user-rx3ww3xi3h
    @user-rx3ww3xi3h 5 месяцев назад

    is todays date update automatically day by day?

  • @fakdolan
    @fakdolan 5 месяцев назад

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

  • @hakiinmohamud9852
    @hakiinmohamud9852 6 месяцев назад

    Thank you so much. Great Video!

  • @vipuljain3179
    @vipuljain3179 6 месяцев назад

    Just Brilliant

  • @Odawg421
    @Odawg421 7 месяцев назад

    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 7 месяцев назад

    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 8 месяцев назад

    THANK YOU

  • @user-zv6il4jh2l
    @user-zv6il4jh2l 8 месяцев назад

    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 8 месяцев назад

    nice really helped me

  • @jonatancohen
    @jonatancohen 9 месяцев назад

    Amazing video bro. Thanks. Very clear

  • @michaelangelocapistrano26
    @michaelangelocapistrano26 10 месяцев назад

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

  • @user-oq3be5of6r
    @user-oq3be5of6r 10 месяцев назад

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

  • @etherlords88
    @etherlords88 11 месяцев назад

    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

  • @user-sc8mq7og4d
    @user-sc8mq7og4d Год назад

    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.

  • @dbhakimi_.5123
    @dbhakimi_.5123 Год назад

    This video was very helpful for my internship project. Thank you very much!

  • @chrisa7748
    @chrisa7748 Год назад

    Any vids on caveman pivot tables?

  • @ab-bc2gr
    @ab-bc2gr Год назад

    How can I set an alert to notify me (via pop-up message) when I open an excel file on: The day before the 3rd Friday of March, June, Sept and Dec of any particular year ?

  • @husamaineia795
    @husamaineia795 Год назад

    thanks a lot...Thant's helped me to much