BAM102 — Introduction to Spreadsheets and Understanding Data

Topics Covered in Course

• Master Excel basics, including navigating the interface, entering data and formulas, using functions, formatting, and managing worksheet elements such as names, colors, and properties
• Utilize advanced tools and features, such as Flash Fill, AutoCalculate, and chart creation, to analyze and present data effectively, troubleshoot errors, and optimize print and display settings
• Format and organize workbook elements, including themes, text rotation, conditional formatting, column and row adjustments, and structured use of date and number formats

• Apply and manage advanced data visualization and analysis tools, such as sparklines, charts, conditional logic with the IF function, and various worksheet views and layout options for streamlined presentation and printing
• Organize, format, and manage data efficiently using cell names, data tables, custom formats, formulas, cell styles, and protected cells, with print and display settings to enhance presentation and usability
• Perform advanced data analysis and consolidation, including 3-D references, workbook linking, formula checking, and multi-sheet operations, while leveraging Excel’s visualization and layout tools like pie charts and multi-workbook views
• Manage and analyze data efficiently by creating tables, adding calculated columns, using functions like XLOOKUP, applying conditional formatting, and organizing data with sorting, filtering, and subtotals
• Import and manipulate data from various sources, use templates and text functions, paste and transpose data, and utilize quick analysis tools for streamlined data handling and presentation
• Enhance worksheet and chart presentations by formatting bar charts, using Find feature, SmartArt graphics, applying text effects, hyperlinks, and utilizing linking and embedding features
• Conduct data analysis with trendlines, PivotTables, and PivotCharts, including formatting, filtering, calculated fields, and slicers for dynamic data visualization and reporting