EXCEL PRO TIP: CUBE Functions

Рет қаралды 10,913

Күн бұрын

For access to all pro tips, along with Excel project files, PDF slides, quizzes and 1-on-1 support, upgrade to the full course (75% OFF):
courses.excelmaven.com/p/micr...
FULL COURSE DESCRIPTION:
This course is NOT an introduction to Excel.
It's not about 101-style deep dives, or about showing off cheesy, impractical "hacks".
It's about featuring some of Excel's most powerful and effective tools, and sharing them through crystal clear demos and unique, real-world case studies.
We'll cover 75+ tools & techniques, organized into six categories:
-Productivity
-Formatting
-Formulas
-Visualization
-PivotTables
-Analytics
Demos are self-contained and ranked by difficulty, so you can explore the content freely and master these tools and techniques in quick, bite-sized lessons.
Full course includes LIFETIME access to:
-10+ hours of high-quality video content
-Downloadable PDF eBook
-Excel project files (including data sets & solutions)
-1-on-1 expert support
-100% satisfaction guarantee (no questions asked!)
Happy analyzing!
-Chris (Founder, Excel Maven)

Пікірлер: 7

@carolinecostaBR 27 күн бұрын

Amazing class, thank you!

@wayneedmondson1065 4 жыл бұрын

Hi Chris.. super interesting video. Lots of power in those CUBE functions when you want to customize the output beyond a standard Pivot Table. Thanks for the insights. Thumbs up!!

@ptatanasov 4 жыл бұрын

Excellent tutorial, thanks a lot for sharing it! I have a suggestion when setting up ranking with Cubemember... instead of ranking the numbers in column a from 2 to 6, you can set the parameter “A17+1”.

@LotfyKozman 4 жыл бұрын

Well well well done, we need more about CUBE Function, unfortunately this function doesn't have its luck within Excel or powerpivot.

@youjohnny16 Жыл бұрын

Maven rocks.

@republikadugave420 10 ай бұрын

7:40 holds true if you insert a cubemember into a cubevalue formula and reference a cell in square bracket followed by "&C4&"for example... i actually use this trick to change things cubevelue is referencing with data validation list..