001 - Excel Basics

Course Description

COURSE DESCRIPTION

Excel Basics provides learners with a practical, functional understanding of the Excel software. We start with basic data formats and work towards a collection of useful formulas.

The following questions are designed to help you determine if this is the right Excel course for you. If you are still not sure after answering these questions, explore the curriculum or send us a note.

• I’ve entered real data into Excel for business or personal use on a recurring basis
• I’ve entered data (text & numbers) into a spreadsheet.
• I can change the name and color of a spreadsheet tab.
• I understand the functionality of at least five different Excel cursors
• I’m able to modify the font, size, style, and alignment of data in a cell.
• I know how to wrap data inside an individual cell.
• I know other ways to make a spreadsheet larger rather than increasing the font size. 

OUTLINE

• Working With Data
  • How Excel Thinks: Part II
  • Entering dates, days, years, etc
  • Formatting data: general, number, currency, accounting, etc
  • Format painter
  • Conditional formatting
  • Useful shortcuts
• The Ribbon: a deeper dive
• Configuring Excel
  • Customizing for your own use
  • Modifying the Ribbon & Quick Access toolbar
• Formulas: Part I
  • How Excel Thinks: Part III
  • Basic Math: + − × ÷
  • Solving real life problems in Excel
  • Formula vs function
  • SUM, AVERAGE, PRODUCT
  • MIN, MAX, SMALL, LARGE, DAYS

COURSE DATES

• Tuesday, March 19, 2024 – 6:00 – 8:00 pm EST
• Thursday, March 21, 2024 – 6:00 – 8:00 pm EST

CREDENTIAL

At the successful conclusion of this microcredential program, participants will receive a digital badge and certificate from Syracuse University, College of Professional Studies, which can be shared on LinkedIn or any digital media, and which will provide complete detail on information learned and competencies gained throughout the program.

SPONSORING DEPARTMENT CONTACT INFORMATION

If you have any questions regarding this course, please contact the College of Professional Studies Office of Professional Acceleration and Microcredentials at microcredential@syr.edu or 315.443.2588