Learn Excel - Scratch to Dashboard with Pivot Charts - Playlist Part 00/28 | XL Smart Lab
Please save the playlist which will be updated bi-weekly (Monday & Friday),
Link 🔗 of playlist: • Excel Tutorials
Link 🔗 of full video • EXCEL Advanced Tutorial for Beginners | Le...
This is an introductory video showing what you can achieve in this whole tutorial playlist (link above) which is creating a financial dashboard and financial reports using real data examples to cover most of the basic features to advanced ones, like:
What is Excel
Format
Clipboard
Format Cell & Keyboard Shortcuts
Font
Alignment
Formulas (SUMIFS, IF, DATE, YEAR, SUMIFS with INDEX & MATCH, XLOOKUP, VLOOKUP, INDEX MATCH and many more)
Paste Special
Fill
Freeze Panes
Sort
Filter
Delete Filtered Data
Financial Reporting
Presentation of Report
Lock Cells
Group
Ungroup
Check Formulas
Subtotal
Conditional Formatting
Data Validation
Get & Transform Data (Power Query)
Excel Table (Work faster in Excel)
Name Manager (Work faster in Excel)
Text vs Date format
PivotTable
Charts
Pivot Charts
Financial Dashboard
This will teach you keyboard shortcuts as we go along that can significantly speed up your Excel work.
This tutorial will be broken down into smaller clips in a playlist, each covering a specific area of Excel. This way, if you ever get stuck or need help with a particular topic, you can easily find the right clip in our playlist. I’ll upload the full tutorial in one piece once this tutorial is complete, just in case.
While the aim is to cover a wide range of Excel topics, it can't cover everything in a single video. These are complex subjects that require their own dedicated tutorials, which I'll try to cover separately.
If you find this video helpful, please give it a thumbs up, subscribe to the channel for more content like this, and don't forget to save the playlist so you can stay updated with new videos as these are added. Cheers!
🕸 Website https://sharaz1990.github.io/worksmar...
🔔 SUBSCRIBE if you'd like more tips & tutorials / @xlsmartlab
💬 COMMENT if you have suggestions, questions, or compliment
🎁 SHARE this video to spread the tips & tricks
👍LIKE at least if you enjoyed the content
➡️ Let's connect on Facebook: / xlsmartlab
➡️ Let's connect on Instagram: / xlsmartlab
#exceltutorial #ExcelTips #ExcelTricks #ExcelForBeginners #ExcelAdvanced #ExcelPivotTables #ExcelFinancialDashboard #ExcelFinancialAnalysis #ExcelDataAnalysis #ExcelBusinessIntelligence #ExcelDataVisualization #ExcelDashboard #LearnExcel #ExcelCrashCourse #ExcelMasterclass #ExcelNinja #xlsmartlab