1 option
Excel charts and pivot tables.
- Format:
- Video
- Language:
- English
- Subjects (All):
- Microsoft software.
- Electronic spreadsheets--Computer programs.
- Electronic spreadsheets.
- Microsoft Excel (Computer file).
- Physical Description:
- 1 online resource (1 video file (42 min.)) : sound, color.
- Edition:
- [First edition].
- Place of Publication:
- [Birmingham, United Kingdom] : Packt Publishing, [2024]
- Summary:
- Dive into Excel with our expertly crafted course, designed to take you from beginner to advanced proficiency in data visualization and analysis. You'll start with creating various chart types like column, line, pie, bar, area, and scatter plots, with step-by-step instructions for effective data representation. Advanced techniques such as trendlines, error bars, and combination charts are covered, enabling clear presentations of complex data. Transitioning to pivot tables, you'll master inserting and manipulating tables, creating and customizing pivot tables, and using pivot charts for enhanced presentation. Learn to group pivot table items, create multi-level pivot tables, and generate frequency distributions for thorough data analysis. Discover interactive tools like slicers and methods to keep your pivot tables updated with changing data. By the course's end, you'll adeptly transform large datasets into actionable insights, essential for tracking KPIs, analyzing sales data, or managing projects. Enhance your data analysis capabilities with Excel's powerful charting and pivot table features, making data-driven decisions with confidence.
- Notes:
- OCLC-licensed vendor bibliographic record.
- ISBN:
- 9781836646518
- 1836646518
- OCLC:
- 1455265881
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.