![](https://res.cloudinary.com/micronetonline/image/upload/c_crop,h_312,w_310,x_0,y_0/f_auto/q_auto:best/f_auto/q_auto:best/v1706569607/tenants/3225374c-47c3-4da8-8a08-d45b4d7a95fb/9b6e17eaa97c42b2972f43e127af35b1/Butte-College-Logo.png)
MS Excel Basic 3-Part Series / Part Three
Wednesday, February 28, 2024 (9:00 AM - 12:00 PM) (PST)
Description
In MS Excel BASIC topic areas including getting started with terms and navigating a spreadsheet, entry and editing data a beginning modification to spreadsheets are covered. Upon completion, attendees will be able to:
- Define a spreadsheet and identify spreadsheet components
- Identify the main components of the excel window
- Open and navigate workbooks
- Create a workbook from a template
- Enter and edit text and values in a worksheet
- Enter and edit formulas in a worksheet
- Save and update a workbook, and save a workbook in a different file format
- Move and copy data in a worksheet
- Move, copy, and view formulas in a worksheet
- Use absolute references in formulas
- Insert and delete ranges, rose, and columns in a worksheet
- Apply the SUM function to calculate the sum of values
- use the AutoSum to enter some functions
- Use the AVERAGE, MIN, MAX, COUNT, and COUNTA functions to find average, minimum, and maximum values, and the count of cells in a range
- Apply text formatting
- Customize column widths, row heights, and alignment, and apply color and border formatting
- Format values as currency, percentages, and ordinary numbers •Apply conditional formatting based on specific criteria
- Copy formatting, apply cell styles, and use Find and Replace to update the formatting for specific content
- Create charts based on worksheet data, and move charts within a workbook
- Customize charts and format chart elements
- Insert a picture into a worksheet
- use graphics as conditional formatting to represent cell data
- insert and modify SmartArt graphics
- Preview how a worksheet will look when printed, use the spelling checker, and use find and replace to update data
- set page orientation, scaling, and margins, and create headers and footers
- print a worksheet and a selected range
Website Link: MS Excel Basic series | The Training Place (coursestorm.com)
Contact Information: The Training Place-Butte College @ 530-893-9015
Butte College - The Training Place
2480 Notre Dame Blvd
Chico, CA 95928 United States
2480 Notre Dame Blvd
Chico, CA 95928 United States
Wednesday, February 28, 2024 (9:00 AM - 12:00 PM)
(PST)
Powered By GrowthZone