See how live online training works in this brief video.
All Excel classes include
Free retakes
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Excel Course Online December 9, 2024 Charts, Graphs, & Design
Excel Charts, Graphs and Design Course
$295.00
In this Excel charts and graphs course, become an expert on creating data visualizations. Learn to create dynamic charts, discover techniques to visualize data, and create impactful data visualizations. Elevate your workbook design using styles, themes, and templates to consistently create professional documents. Develop expert skills with formatting and data visualization techniques, ensuring your spreadsheets are clear and easily comprehensible. Learn advanced charting strategies, from map charts to combo charts, going beyond standard pie and bar charts. Upon completing this course, you'll possess the skills to create visually compelling reports from Excel.
Detailed topics for Excel charts, graphs, & design course
Visualizing Data with Dynamic Charts
- Master the Art of Creating Charts
- Optimize Chart Location and Size for Impact
- Transform Data Representation with Chart Type Modifications
- Refine and Enhance Charts with Advanced Techniques
- Craft Stunning Charts Using Styles and Filters
- Personalize Charts with Element Formatting
- Unleash Creativity with Data Series Manipulation
- Print Polished Charts for Professional Reports
- Harness the Power of Sparklines for Quick Insights
- Efficiently Build Dashboards for Data Visualization
Elevating Your Workbook Design with Styles, Themes, and Templates
- Streamline Formatting with Cell Styles
- Seamlessly Merge Styles for Consistency
- Infuse Elegance with Dynamic Themes
- Utilize Productive Templates for Efficiency
- Create Personal Templates Tailored to Your Workflow
Mastering Excel Formatting Techniques
- Develop and Apply Custom Formats with Ease
- Implement Smart Formatting with Conditional Formatting
- Craft New Rules for Dynamic Conditional Formatting
- Efficiently Manage Conditional Formatting Rules
- Expedite Analysis with Quick Analysis Tool
Integrating Excel Data Seamlessly
- Effortlessly Paste, Link, and Embed Data
- Seamlessly Embed Excel Ranges into Word Documents
- Enhance Word Documents with Excel Charts
- Integrate Excel Data into PowerPoint Presentations
- Create and Modify Charts Directly in Word or PowerPoint
Exploring Advanced Charting Techniques
- Using Specialty Charts for Enhanced Insights
- Visualize Data Geographically with Map Charts
- Organize Data Effectively with Treemap Charts
- Illuminate Relationships with Sunburst Charts
- Analyze Distributions with Histograms
- Prioritize with Pareto Charts
- Uncover Patterns with Box and Whisker Charts
- Navigate Complex Processes with Waterfall Charts
- Optimize Sales Funnels with Funnel Charts
- Blend Multiple Perspectives with Combo Charts
Sharing and Printing from Excel with Perfection
- Optimize Print Options for Professional Output
- Define Print Areas for Focused Reports
- Harness Range Names for Printing Precision
- Customize Print Settings for Clarity
- Streamline Printing with Page Setup Tools
- Preview and Refine Prints with Page Break Preview
- Impress with Custom Headers and Footers
- Print Gridlines and Headings for Enhanced Readability
- Tailor Views with Custom Worksheet Views
- Preserve Data Integrity with PDF Files
Why Excel classes at AGI are the best option for you
- Hands-on learning: Learn Excel quickly with our proven teaching methods.
- Exceptional curriculum: AGI has delivered Excel training to thousands over 25 years.
- Expert instructors: Our instructors are Excel experts and skilled educators.
- Small class sizes: Receive personalized attention with 10 or fewer participants per class.
- Repeat for Free: If you need a refresher or miss a class day, retake the Excel class at no cost.