Request Info from CIAT Admissions Advisors

Talk to an Advisor

Book an appointment with one of our Admissions Advisors for personalized guidance on building your education plan.

Enrollment Deadline - April 12th, 2025

By checking this box, you agree to receive SMS messages from our organization regarding our services.

*By submitting this form, you are giving your express written consent for California Institute of Applied Technology to contact you regarding our educational programs and services using email, telephone or text – including use of automated technology for calls and periodic texts to any wireless number you provide. Message and data rates may apply. This consent is not required to purchase goods or services and you may always call us directly at 877-559-3621. You can opt-out any time by calling us or responding STOP to any text message.

BAM102 — Introduction to Spreadsheets and Understanding Data

AAS in Healthcare Management

Course ID: BAM102
Course Credits: 4

AAS in Healthcare Management Program Availability:

California Institution
New Mexico Institution

About BAM102 — Introduction to Spreadsheets and Understanding Data

This course provides students with a flexible learning experience that transcends specific versions of Office, remaining relevant across platforms like Office 365, Microsoft 365, Office 2021, or Office Online. The course covers essential skills for data management in organizations.

One crucial aspect covered in the course is using Excel worksheets to easily summarize and visualize data. Students learn how to create a worksheet with charts that represent data effectively. Specifically, they work with a budget that includes monthly estimates for income and expenses. Formulas and functions are taught to help students create dynamic worksheets.

The course also explores various topics such as using option buttons, verifying formulas, applying themes, formatting numbers and text, utilizing conditional formatting, adjusting column widths and row heights, spell checking, alternative worksheet displays and printouts, and adding page headers and footers.

Additionally, students are introduced to powerful features of Excel, including its extensive function library and the ability to answer what-if questions. They learn to work with multiple worksheets and workbooks, explore advanced formatting options for pie charts, such as exploding slices and leader lines. Importing data, sorting and querying tables, creating templates, and analyzing and interpreting data are also covered.

Overall, this course equips students with a range of techniques to enhance their ability to create effective worksheets, draw meaningful charts, and leverage Excel's capabilities for data analysis and interpretation.

Topics Covered in Course

BAM102 Topics

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

Prerequisites

A Windows-based PC that meets the requirements outlined on the following web page:

https://www.ciat.edu/student-resources/system-requirements/

California Institution

401 Mile of Cars Way #100, National City, CA 91950

New Mexico Institution

1717 Louisiana Blvd., NE., Suite 208 Albuquerque, NM, 87110

Phone

(877) 559-3621

Get Started

For Students

Information

California Institution

New Mexico Institution

California Institute of Applied Technology has shared ownership and management of two distinct institutions. California Institute of Applied Technology located in California, and California Institute of Applied Technology located in New Mexico.

GI Bill® is a registered trademark of the U.S. Department of Veterans Affairs (VA). More information about education benefits offered by VA is available at the official U.S. government website at https://www.benefits.va.gov/gibill. CIAT is approved to offer VA benefits. *Financial aid is available for those who qualify. *Students are encouraged to take certification exams while actively enrolled in their Certificate or Degree program. Unlimited certification exam attempts expire 180 days after graduation. Select exams are not eligible for unlimited retakes - see certification exam policy for details. Certifications or courses may change to address industry trends or improve quality