See how live online training works in this brief video.
All Excel classes include
Free retake
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Small class sizes
Course recording
Excel tips & tricks course Online July 1, 2026
Excel tips & tricks course
$295.00
This Excel course provides a comprehensive exploration of tips and tricks to enhance your efficiency and proficiency with Excel. From seamless workbook and file management techniques to formatting wizardry that transforms your data into stunning presentations, this course teaches you the most essential Excel capabilities for working efficiently. Master formulas that streamline data handling, learn AutoSum, reference strategies, and error prevention. Find out how to efficiently manipulate data with advanced techniques, such as creating drop-down lists, conditional formatting, and dynamic data transposition. Explore the power of tables and pivot tables for comprehensive data analysis and presentation, and discover how to configure charts and graphics like a seasoned professional. This Excel course provides you with the tools that can revolutionize the way you work with data, and teaches you to navigate Excel's functionalities with confidence and precision.
Efficiently managing Excel workbooks
- Navigate workbooks seamlessly with pro tips
- Boost productivity with keyboard shortcuts
- Tailor Excel to your workflow with easy customization
- Safeguard your work with protected view
- Enabling and using autorecover to keep files safe
- Preserving documents in read-only format for enhanced security
Mastering Excel formatting and printing to create polished presentations
- Tailor numbers with custom number formats
- Present data more clearly with alternating row shading
- Using conditional formatting to automatically color and style data
- Streamline styling with the format painter
- Balance text and values for clear communication
- Improve data organization with merged cells
- Enhance visual appeal with styles mastery
- Add consistent style with document themes
- Print perfectly using swift printer setting adjustments
Using Excel formulas for intelligent data handling
- Turbocharge formulas using autosum capabilities
- Learn to use references including absolute and mixed references
- Eliminate errors as you become an expert with formula display
- Streamline data organization naming and structure for worksheets
- Establish consistency with named constants
- Learn to use lookups efficiently
- Achieve clarity with rounded or precise numbers
Efficient data handling techniques in Excel
- Efficiently select cells
- Automate data series with seamless and automatic range filling
- Transform data dynamically, with or without formulas
- Enhance data input using drop-down lists
- Visualize data patterns with conditional formatting
- Eliminate excess spaces for clean data
- Transpose data with ease
- Expedite data formatting with flash fill
- Find and report data effectively in reports
- New GROUPBY and PIVOTBY functions
- Advanced lookups and returns using DGET & FILTER
Unlocking the power of tables and pivot tables
- Leverage formulas within tables for smart data analysis
- Navigate data with tables for enhanced understanding
- Identify data worthy of pivot tables for comprehensive insights
- Optimize data analysis with pivot tables
- Control pivot table cell references for precision
- Master date grouping within pivot tables
- Enhance pivot table clarity using slicers and timelines
- Tables & Advanced table functions
- Calculated Items & Fields
- Summarize techniques
Creating professional charts and graphs in Excel
- Use charts to provide intuitive data representation
- Customize charts for maximum impact
- Streamline chart creation with templates
- Dynamically link chart text to cells for real-time updates
- Apply data labels to charts with effortless range selection
- Group charts and objects for organized presentations
- Capture dynamic range snapshots for visual appeal
- Seamlessly integrate images and artwork for rich visuals
- In-line progress trackers and spark lines
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.