Category: Excel

DAME 01: Data Analysis Terms & the Awesome Microsoft Power Tools!

Posted on by Annie D

Download files: DAME01zip Pdf notes to read online: DAME01pdfNotes
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught my Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about data analysis terms and all the amazing Microsoft Power Tools such as: Excel, Power Query, Power Pivot, Power BI, Dataflow, Worksheet formulas, Dyanamic Spileld Array Formulas, M Code formulas, DAX formulas, and much more!
Topics:
1. (00:00) DAME Intro Song
2. (00:12) Introduction
3. (01:18) Table terminology
4. (04:52) What is Grian?
5. (06:41) SQL database as a data source
6. (07:55) Columnar Database in the Data Model in Power Pivot and Power Continue reading “DAME 01: Data Analysis Terms & the Awesome Microsoft Power Tools!” →

Excel – Export to PDF with Gridlines and Row & Column Labels

Posted on by Annie D

Microsoft Excel Tutorial: How to export a PDF file from Excel including the gridlines, row headers, and column headers.

In this Excel tutorial, we solve Angela’s problem: her exported PDF is missing grid lines! 📊 Don’t worry, we’ve got you covered. Learn step-by-step how to ensure your PDF exports retain grid lines, row numbers, and column labels. It’s all about mastering those Page Layout and Page Setup settings. Join us as we dive into the nitty-gritty of Excel’s Sheet tab and unleash the power of the dialog launcher. By the end of this video, you’ll be exporting polished PDFs like a Continue reading “Excel – Export to PDF with Gridlines and Row & Column Labels” →

Excel – How to Run a Macro from an Icon on the QAT #excelfansonly

Posted on by Annie D

Microsoft Excel Tutorial: How to run a macro from an icon on the Quick Access Toolbar.

Running your Excel macros just got a whole lot easier! Forget the hassle of navigating through menus. In this tutorial, learn how to add your macros to the Quick Access Toolbar for quick and convenient access.

Simply right-click, customize the Quick Access Toolbar, select Macros, and add your desired macro, specifying it’s for This Workbook. Choose an icon that represents your macro’s function, click OK, and voila!

Now you can effortlessly run your macro directly from the Quick Access Toolbar.

Discover more time-saving tips like Continue reading “Excel – How to Run a Macro from an Icon on the QAT #excelfansonly” →

Excel – How to Run a Macro From a Button in the Excel Grid #excelfansonly

Posted on by Annie D

Microsoft Excel Tutorial – Easy Way to Add a Macro button to your spreadsheet.

Tired of the hassle of running your Excel macros? In this video, learn a quick and easy way to streamline the process. Say goodbye to pressing Alt+F8 and clicking through menus.

Simply head over to the Insert tab, choose a shape, like a rounded rectangle, and type “Run!” while the shape is selected.

Customize it with your macro’s name and formatting preferences. Then, right-click the shape, assign your macro, and you’re done! With just a click, your macro runs smoothly.

Plus, discover more time-saving tips like this Continue reading “Excel – How to Run a Macro From a Button in the Excel Grid #excelfansonly” →

PIVOTBY & GROUPBY to Create Year by Month Sales Report. Grouping Trick! Excel Magic Trick 1859

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1857-1858.xlsx
Learn how to group in the GROUPBY and PIVOTBY functions to create Year by Month Sales Reports.
Topics:
1. (00:00) Introduction
2. (00:21) Shout Out to Excel Instructor: Radosław Poprawski at https://www.youtube.com/channel/UCVOcrn3Orn-aC0q1qGyQQmQ
3. (00:33) EOMONTH column, YEAR column inside HSTACK
4. (01:31) Custom Number Format for month
5. (01:42) GROUPBY
6. (02:17)PIVOTBY
7. (02:39) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp

Grouping in GROUPBY & PIVOTBY Functions!?!? Yes!!!! Frequency Distribution with GROUPBY EMT 1858

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1857-1858.xlsx
Learn how to group in the GROUPBY and PIVOTBY functions to create Frequency Distributions.
Topics:
1. (00:00) Introduction to Frequency Distribution
2. (00:38) Start, Increment and Last Value for frequency distribution using MAX and CEILING.MATH functions
3. (01:12) Build Bins using SEQUENCE function
4. (01:42) Build GROUPBY Formula using LET and GROUPBY
5. (02:37) Look at PIVOTBY Formula
6. (02:43) Understanding Categories
7. (03:00) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #groupby #pivotby

Free Excel Webinar March 20 2024 from MrExcel #ExcelWebinar #Free

Posted on by Annie D

Hey Excel enthusiasts! 📊 Join me, Bill Jelen, from MrExcel, for an epic free Excel webinar on Wednesday, March 20th, 2024, starting at noon Eastern time in the US. 🚀 Excited to unveil my latest book, “Mr. Excel 2024: Igniting Excel,” packed with 33 new topics! 🔥 Tune in to my YouTube channel as I dive into some of my favorite highlights. Let’s excel together! Don’t miss out, mark your calendars! 📅 #ExcelWebinar #MrExcel2024 #IgnitingExcel
Watch the Webinar here on YouTube: https://www.youtube.com/watch?v=1LXvuSt2D5I

Generate Random Data Sets with Dates & Sales Numbers: RANDARRAY Function. Excel Magic Trick 1857

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1857-1858.xlsx
Learn how to create a data set with dates and sales numbers using an Excel Formula.
Topics:
1. (00:00) Create Inputs for Randon Data Set
2. (00:37) Create Random Dates using RANDARRAY function
3. (01:21) Create Random Sales amounts using RANDARRAY & ROUND function
4. (02:00) Paste Special Values Trick!
5. (03:00) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #randomdata