The Excel Bootcamp - Beginners course is an introduction to Excel and overall workbook management. Students will learn how to use and design a spreadsheet (grid of columns, rows, and cells) to enter text, values, and dates to organize and analyze data. Course topics include: Introduction to Microsoft Excel’s Ribbon, using keyboard short cuts, filling a series with Auto Fill, and using the Find & Replace function. The Beginners course also includes moving/copying worksheets, aligning Cell contents, the Wrap & Merge function, as well as applying Conditional Formatting to datasets. Setting various Page Views and Print Areas Options, will also be introduced.

The Excel Bootcamp - Intermediate course is an overall introduction to using basic Formulas in Excel including Order of Operations, Relative & Absolute Cell references, and referring to data in another Worksheet. This course will review Excel’s built-in Formula Logical Functions such as: SUM, SUMIF, COUNT, AVERAGE, MIN and MAX. The Intermediate course will also introduce basic Lookup & Reference Formulas (VLOOKUP and HLOOKUP) with examples for working with large datasets.

Are you looking to enhance your reading, writing, and math skills, or prepare for the GED/HiSET exams, college, training, or better job opportunities? If so, this free opportunity is for you!

Bristol Community College's Adult Education Online classes offer flexible options tailored to help you achieve your goals.

To participate, you must take an in-person placement test and be a resident of Massachusetts, Bristol County, or currently collecting unemployment benefits from the state of Massachusetts.

We offer two types of online classes:

Online Zoom Classes - Live classes taught via Zoom by an instructor with fellow students.

Self-Paced Online Program - Learn through online software programs with support from an online coach, but the majority of learning is done on your schedule.

Each student receives:

• Personalized Learning Plans
• Technology Assistance
• Basic Computer Skills Course (optional)
• Educational Advising
• Career Planning Assistance
• Instructor/Tutor Support

Students and graduates can also take advantage of free college courses through our Transitions to College program.

To get started, please register for an upcoming Adult Education Placement Test session and check your email for further details.

If you require an accommodation for the initial intake exam due to a documented disability, please call us directly at 774-357-3769 to schedule your test.

For further assistance, please contact:

Nicola Machado, Education and Career Advisor

Phone:774-357-3769

Email: nicola.machado@bristolcc.edu.

Class Description:

The 4-hour Excel Bootcamp for Advanced Users course will focus on Excel’s advanced Formulas and functions to ensure data consistency and integrity. Topics include Restricting Cell entries to a range of Cells (Data Validation), Group & Ungroup data and Removing Duplicate rows from a worksheet. The Advanced course will allow students to create Charts and Graphics, and how to build Pivot Tables and basic Macros.