Reviews of our Excel Bootcamp
Excel Bootcamp - Introduction rating: 5 stars from 18 reviewers
"Teacher was prepared and ready for class. Confirmed all participants were on-line and ready. " - Jeff A
See all reviews for Excel classesAll Excel classes include
Free retakes
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Excel Bootcamp
Excel Bootcamp
This Excel Bootcamp takes participants from introductory skills to advanced capabilities over three days. It includes the introduction, intermediate, and advanced Excel courses. Learn essential Excel formulas and techniques, including calculations, formatting, and charts and then move into more advanced capabilities. This three-day Excel Bootcamp provides training that leaves you with a solid foundation in Excel for any job.
What you learn in the Microsoft Excel bootcamp
- Calculations and formulas: Find out how to perform calculations like averages, sums, and counts, enhancing your data analysis capabilities.
- Formatting text, numbers, and cells: Learn to make your charts stand out and be easier to read through formatting text, numbers, cell borders, and alignment as you make your spreadsheets more readable and professional.
- Format Painter: Quickly copy formatting from one cell to another, automatically maintaining consistent styling throughout your worksheets.
- Text Functions: Use powerful functions to manipulate text by changing case, removing spaces, and extracting characters, ensuring clean, organized and accurate data.
- Charts and graphs: Learn to create and customize charts such as line charts, bar charts, and pie charts to visually represent data for easier interpretation and presentation.
- Conditional formatting: Automatically format cells based on values, text, or other criteria to highlight data trends and patterns, such as making all cells with negative numbers red.
- PivotTable: Analyze and summarize large datasets with PivotTables, creating dynamic reports to compare variables, identify trends, and make data-driven decisions.
- Pivot Charts: Visualize data from Pivot Tables using Pivot Charts to create clear and informative graphical representations.
- IF Statements: Create complex formulas with IF statements to produce different outcomes depending upon conditions you define, adding flexibility to your data calculations.
- VLOOKUP: Retrieve information from a table based on a related value in another column, essential for tasks like looking up city names by ZIP code.
- MATCH VLOOKUP: Enhance VLOOKUP functionality by using the MATCH function to locate column inputs, making lookups more powerful.
- MATCH INDEX: Perform reverse lookups and combine two MATCH functions within INDEX for flexible and powerful data extraction formulas.
- Data Validation: Control data entry by creating rules and drop-down menus, ensuring consistency and reducing input errors in your spreadsheets.
- Cell referencing: Use absolute, relative, and mixed references to create dynamic and flexible formulas, ensuring accurate calculations when copied to other cells.
See all Excel bootcamp course topics
Why this comprehensive Excel bootcamp is 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.
Ways to attend this Excel Course
- Live Online classes from your office or home as a regularly scheduled small group class.
- Live, in-person regularly scheduled Excel classes in Boston or Philadelphia with a live instructor in the same classroom.
- Private training customized to your specific needs delivered in-person or online. Call 781-376-6044 or complete the Private Excel Training form for more information.
- Corporate Excel Training for your group or team.
This course is available individually or as part of these certificate programs
Excel Bootcamp - Course Dates
All classes are led by a live instructor. Class times listed are Eastern time.
Microsoft Excel Bootcamp Training - Key Topics Covered
- Calculations and formulas: Discover how to use calculations to accurately calculate averages, sums, and counts, as well as discovering more advanced functions to enhance your data analysis.
- Formatting text, numbers, and cells: Understand formatting techniques to make spreadsheets more visually appealing. Learn how to efficiently change text and cell colors, borders, format text and numbers, and set alignment both vertically and horizontally to make your data more professional.
- Format Painter: Use the Format Painter tool to quickly copy formatting from one cell or range of cells to another. Learn to maintain consistent styling throughout your worksheets automatically.
- Conditional formatting: Understand the power of conditional formatting to highlight important data trends and patterns. Set up rules to automatically format cells based on criteria that you specify, such as coloring negative numbers in red and positive numbers in green.
- Charts and graphs: Develop skills to create and customize various types of charts, including line, bar, and pie charts. Learn how to visually represent your data, making it easier to interpret and present your findings effectively to others.
- Text Functions: Learn powerful text functions to manipulate and format data efficiently. Find out how to change text case, remove unnecessary spaces, extract specific characters from cells, and more, ensuring your data is clean and well-organized.
- PivotTable: Learn PivotTables like a pro. Gain expertise in creating PivotTables to quickly analyze and summarize large datasets. Learn to create dynamic reports that allow you to compare different variables, identify trends, and make data-driven decisions. For example, summarize sales data by region and product to understand performance trends.
- Pivot Charts: Learn to visualize data compiled into Pivot Tables using Pivot Charts.
- IF Statements: Explore how to create complex formulas using IF statements to produce different outcomes based on conditions you define. Calculate discounts based on whether a purchase amount exceeds a certain threshold, or assign grades to test scores.
- VLOOKUP: Learn the VLOOKUP function to retrieve information from a table based on a related value in another column. Use this for tasks such as looking up a city name based on a ZIP code or finding a product price based on its ID.
- MATCH VLOOKUP: Create a more powerful VLOOKUP by using the MATCH function, which can locate the input within a column.
- MATCH INDEX: Learn to conduct reverse lookups and combine two MATCH functions within INDEX to create flexible and powerful data extraction formulas.
- Data Validation: Control what data can be entered into a cell by creating rules and restrictions. Learn to create drop-down menus for selecting from pre-populated data, ensuring data consistency and reducing input errors. For example, restrict entries to dates within a specific range or allow only numeric values, or numbers within a specific range.
- Cell referencing: Learn to use cell references to create flexible formulas. Learn how to use absolute, relative, and mixed references to ensure your formulas adjust correctly when copied to other cells, making your calculations more flexible and accurate.
Excel Bootcamp: Topics Covered
Topics covered in the Microsoft Excel Bootcamp include the following:
Getting Started with Excel
- Getting to know the Excel Interface: learn to navigate within the Excel interface to access commands and functions.
- Data Entry using Excel: Understand various ways of entering data into an Excel file.
Using Excel Formulas
- Autofill in Excel: Learn to use Excel's predictive data entry
- Excel Calculations: Use excel for mathematical expressions
- True / False: Learn to have Excel test for matching data using true/false
- Functions in Excel: Discover essential AutoSum functions including: Sum, Average, Max, Min, and Count Numbers
- Excel’s Text Functions: Learn to use functions to modify text
- Multi-Input Functions: Find out how to perform calculations that involve multiple cells or ranges simultaneously.
- Constant (Absolute) Cell References: Learn to create constant cell references when required for calculations
Formatting Worksheets in Excel
- Formatting Excel sheets and content: Learn to provide visual cues to those reviewing sheets with formatting.
- Using the Format Painter in Excel: Learn to duplicate formatting from one cell to others.
- Applying Conditional Formatting: Discover how to apply formatting depending upon rules relating to content.
Working with Charts in Excel
- Understanding chart types
- Creating Line Charts: Create line charts and spark lines to represent data visually.
- Column Charts using Excel: Learn to create column charts to visualize data.
- Pie Charts in Excel: Discover how to create pie charts for data visualization.
- Customizing charts: Adjusting charts to meet your design requirements.
- Creating Tables: Understand the options and benefits of organizing data as a table.
Excel Workbook Management
- Printing & Exporting from Excel: Understand ways to easily print or convert Excel content to PDF.
- Using Multiple Worksheets in Excel: Learn to organize data by creating, moving, copying and managing Excel worksheets.
- Using Repeat Action: Learn to quickly duplicate prior actions in Excel.
- Saving Time with Excel Shortcuts: Discover shortcuts that save time and help you to work more efficiently.
Excel Worksheet Management
- Efficient Excel Navigation: Discover shortcuts to navigate efficiently within Excel.
- Using Paste Special: Learn to copy formatting or calculations from one cell to another.
Understanding Text Functions and Validation
- Splitting Text: Adapt Text to Columns for splitting text into multiple cells.
- Joining Text: Combine text from different cells.
- Named Ranges: Apply names to cell ranges for referencing when conducting calculations.
- Data Validation: Create drop-down menus, making it easier to enter data accurately.
- Sort & Filter: Locate and organize data in large data sets using sort and filter options.
- Remove Duplicates: Learn to remove duplicate data from a sheet.
Using Database Functions
- VLOOKUP: Learn to use Vlookup to locate and return related data across different columns.
- HLOOKUP: Find out how to use Hlookup to locate and return related data across different rows.
- VLOOKUP - Closet Match: Discover how to use Vlookup to find the closest match when an exact match is not identified.
Understanding Logical Functions
- AND, OR: Find out how to use and/or to determine if one or more conditions are met.
- IF statements: Learn about using IF statements to return data depending upon the values of other cells.
Working with Pivot Tables
- Pivot Tables: Discover how to use Pivot Tables to easily summarize large sets of data.
- Pivot Tables & Grouping: Create groups within Pivot Tables.
- Advanced Pivot Tables: Find out how to build several pivot tables within one Excel worksheet.
Using Statistical Functions
- Ranking: Learn how Rank.eq and Rank.avg functions help determine a cell's position within a larger array for comparative analysis.
- COUNTIFS: Discover the COUNTIFS function to count cells that meet multiple conditions for more precise data filtering.
- SUMIFS: Learn to sum values in a range that meet multiple specified criteria, enabling complex and conditional summing.
Advanced Chart Creation
- Combo Charts: Understand how to combine multiple chart types into a single chart for more comprehensive data visualization.
- Chart axis: Find out how to add a secondary axis to a chart to better display and compare different data sets.
Excel Cell Management
- Cell Locking: Learn to create powerful formulas by locking columns or rows.
- Cell Auditing: Trace and analyze relationships between cells to identify errors in formulas and data flow.
- Windows: Discover techniques for editing active windows.
- Hot Keys: Learn to use the ribbon as a custom set of personalized shortcuts.
Using Special Formatting in Excel
- Date functions: Learn to calculate dates using several functions
- Customize Formatting with Formulas: Apply custom formatting to cells that meet specific criteria defined by your own formulas,.
Understanding Advanced Excel Functions
- Nested IF statements: Learn to use nested IF statements to create multiple options for populating cells
- IF statements using AND/OR: Learn additional IF functions available by using AND / OR
Using Excel for What If Analysis
- Goal Seek: Modify parameters to achieve specific target results in your calculations.
- Data Tables: Display the range of outcomes based on different variable inputs placed into a formula..
Understanding Advanced Analytical Tools in Excel
- Data Consolidation: Learn to summarize and combine data from separate ranges into a specific output range for comprehensive analysis.
- Conditional SumProduct: Discover how SumProduct performs calculations that can exclude cells that do not meet definitions you specify.
- Pivot Table Calculations: Learn to calculate columns and rows within a Pivot Table to derive new insights into your data.
- Pivot Charts: Build data visualizations from Pivot Tables to enhance data interpretation and presentation.
Using Excel’s Advanced Database Functions
- MATCH function: Master the MATCH function to locate the exact row or column number of a specific value, enhancing your data referencing skills.
- VLOOKUP-MATCH: Combine VLOOKUP with the MATCH function to accurately determine column indexes, increasing the reliability of your data lookups.
- INDEX-MATCH: Utilize the INDEX and MATCH functions together to precisely retrieve data from specified rows and columns, improving your data extraction capabilities.
- INDEX-Double MATCH: Employ a second MATCH function with INDEX for advanced two-way lookups, enabling more versatile and dynamic data retrieval.
Learning Macros in Excel
- Recording Macros: Learn to record Macros that can apply multiple sets of formatting in a single step, or perform multiple calculations with one click.
- Relative Macros: Create automated actions based on the position relative to the active cell, allowing the macro to be applied flexibly to different cell locations
Custom and private Excel classes
This Excel course is available as a private class. Curriculum can be customized for your specific needs. Excel classes can be delivered at your location, online, or in our classrooms. For more information, call 781-376-6044 to speak with a training consultant or contact us.
Course prerequisites
We recommend that you have Microsoft Excel available to use after your return from this Excel class. A computer with Excel is provided for use during the course if attending in our classrooms.
Course materials
You will receive a comprehensive Excel course manual for this class.
You can attend this Excel class with a live instructor online or in-person. You can also schedule this as a corporate Excel training for your group or organization or as private Excel training.
Frequently Asked Questions for Excel Bootcamp
Which Excel course covers Pivot tables and V LOOKUP?
You will learn Pivottables and VLOOKUP in the intermediate Excel course. These topics are covered in-depth with hands-on projects, and the ability to ask questions from a live instructor.