Highline College Busn 210 Statistical Analysis with Excel Intro Video, Winter 2021
Category: Excel
Highline College Busn 135 Winter 2021 Intro Video
Highline College Busn 135 Winter 2021 Intro Video
Amazing ASCII & Unicode Characters in Excel! Excel Magic Trick #1709
Download Excel File: https://excelisfun.net/files/EMT1709.xlsx
Learn how to list off ASCII and Unicode characters in Excel. Why? To help to understand sorting and to make useful Text Formulas. See how to make a professional Text Formula to Document Formulas Continue reading “Amazing ASCII & Unicode Characters in Excel! Excel Magic Trick #1709”
Excel Statistical Analysis 09: Location, Mean, Median, Mode, Moving Average, Skew & More!
Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about the Measures of Central Location: Mean, Median, Mode and Moving Average. Learn about Skew. See how to use Power Query to import covid 19 data, calculate the 7-day moving average and plot Continue reading “Excel Statistical Analysis 09: Location, Mean, Median, Mode, Moving Average, Skew & More!”
Mode for Categorical Data? LET Function to Dynamically List all Modes with Category Labels EMT 1770
Download Excel File: https://excelisfun.net/files/EMT1770.xlsx
Learn how the basics of how to use the LET function and define variables within the formulas with repeating formula elements more efficient. Learn how to use LET and six other functions to create Continue reading “Mode for Categorical Data? LET Function to Dynamically List all Modes with Category Labels EMT 1770”
Excel Page Break by Rows with VBA
Tina C asks if there is a better way to add a page break every 35 rows. Way back in episode 360, I showed a few methods. But today, one line of VBA in the Immediate Window seems much easier. Continue reading “Excel Page Break by Rows with VBA”
SCAN & LAMBDA to Simulate Relative Cell Reference, One Cell Above in Spilled Array Formula. EMT 1769
Download Excel File: https://excelisfun.net/files/EMT1769.xlsx
Learn Accounting and Financial Spilled Array Formulas when the formula uses a Relative Cell Reference, One Cell Above, as an Accumulator like in investment value from period to period (multiplicative) or a checkbook balance Continue reading “SCAN & LAMBDA to Simulate Relative Cell Reference, One Cell Above in Spilled Array Formula. EMT 1769”
Excel VLOOKUP In Pivot Table Calculated Field? – 2456
Evil Angel on YouTube asks if you can do a VLOOKUP in a Pivot Table Calculated Field. I am fairly sure this won’t work in a regular pivot table based on the pivot table cache. But if you build a Continue reading “Excel VLOOKUP In Pivot Table Calculated Field? – 2456”
Excel Flashing Christmas Tree 2021- Happy Holidays Old School Formula Method. EMT 1768
Download Excel File: https://excelisfun.net/files/EMT1768.xlsx
Happy Holidays, Online Excel Team!!!!!! –excelisfun
Song Credits:
Jingle Bells 7 by Kevin MacLeod is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/
Artist: http://incompetech.com/
Excel Easily Choose Which Currency – 2455
Today a question from someone who frequently uses three currency styles in Excel: USD, EGP, and SAR. Excel makes it easy to choose USD, GBP, EUR, CHF but if your currency is not in that drop-down, then you are scrolling Continue reading “Excel Easily Choose Which Currency – 2455”
Red Gridlines In Excel – 2454
My courses on Retrieve: https://mrexcel.retrieve.com/store/#/
For a special holiday-week treat, change the color of the gridlines in Excel to red. It could drive your co-workers insane.
Actually, as time goes by, the gridlines are becoming more faint. Changing the Continue reading “Red Gridlines In Excel – 2454”
Excel Sort Left To Right – 2453
Today, a quick tip for sorting left to right in Excel.
With the correct headings, it is a faster way to rearrange columns.
Check out all 12 expert tricks at: https://www.youtube.com/watch?v=nOIEeUHyye0
My course on Retrieve: https://mrexcel.retrieve.com/