Excel & Spreadsheets
Perform data analysis with Excel or Google Sheets — formulas, pivot tables, and charts.
0%
Confidence · no data yet
After this skill you can…
- Build a dynamic dashboard with pivot tables and slicers
- Use VLOOKUP, INDEX-MATCH, and array formulas
- Create automated reports with named ranges and conditional formatting
Watch (10 videos)
Mastering Advanced Pivot Tables in Excel
→ Create advanced pivot tables in Excel→ Analyze data like a pro with Excel
Amazing Excel Trick! Unlock Hidden Features & Boost Productivity
→ Create efficient spreadsheets→ Utilize Excel shortcuts and tips
Apply Microsoft Excel Fundamentals for Data Analysis
→ Navigate Excel 2016 interface→ Enter and manage data accurately→ Format data for clarity
Custom & Conditional Formatting in Microsoft Excel
→ Customize Excel spreadsheets for better data visualization→ Apply conditional formatting to highlight important data
How to Align and Wrap Text in Excel
→ Use Excel formatting tools→ Apply text alignment and wrapping techniques
Excel Functions, Lookups, and Secure Spreadsheet Automation
→ Build secure spreadsheets with complex data lookups→ Create professional-grade financial models in Excel
Excel VLOOKUP Mastery for Real-World Data Analysis
→ Use VLOOKUP for data analysis→ Build accurate reports→ Manage large datasets
Master Excel Fundamentals for Data Analysis
→ Navigate Microsoft Excel 2019→ Perform accurate calculations in Excel
Usar Funciones de Fecha y Hora en Excel
→ Use date and time functions in Excel→ Perform advanced data analysis with Excel formulas
Apply Microsoft Excel Basics for Data Management
→ Organize information using Excel→ Control formulas and navigate large worksheets
DeepCamp AI