SCORE East Bay 


Wednesday, December 2, 2020 from 2:00 PM to 5:00 PM PST

Add to Calendar 


This is an online event. 

This workshop will be conducted online only, via Zoom. Registered participants will receive an invitation to the Zoom meeting 3 days prior to the event. Please respond to the invitation to confirm your attendance. The invitation will include a link that you should click to join the workshop.

Excel with Excel for Small Business (Online)

Ascend UC Berkeley Student Chapter

Workshop List Price $40  Discounted Price $15

 Microsoft Excel is a powerful tool that has now become fundamental in many business operations. Having a strong Excel background can make many tasks, such as analyzing stocks, inventory tracking, or budgeting, more efficient. However, with its expansive functions, it can be daunting to figure out where exactly to start learning.

 If you are unfamiliar with Excel or just want to brush up on the basics, then this workshop is for you. By the end of this interactive workshop, you will gain valuable and foundational knowledge in one of the most important business tools, and Excel will no longer seem intimidating!

This workshop aims to provide a comprehensive introduction to the platform and will demonstrate ways in which its functions can be applied to real data and business scenarios. In this session, you will learn:

  1. Excel Formulas and Functions
    • Basic Formulas including: SUM, AVERAGE, COUNT, COUNTA, IF, MAX, MIN
    • Smart data entry: autofill, flash fill
  2. Data Formatting
    • Header/Footer
    • Print settings
    • Fonts/Alignment/Cell Formatting/Shading/Borders
    • Conditional formatting
  3. Data Cleaning and Manipulation
    • Functions such as: sort, filter
    • Data validation
    • Lookup Functions (for example: VLookup)
  4. Building Professional Charts
    • Regression graphs
    • Pivot Tables
    • Sliders Timeline
    • Transferring graphs to PowerPoint slides

About the Presenting Team

 Ascend logoThe Community Service Committee of the Ascend UC Berkeley Student Chapter aims to explore the intersection between social responsibility and business. Through projects and partnerships with nonprofit organizations, we strive to use our skills to make a positive impact in our community. As a whole, Ascend is a premier professional organization dedicated to developing its members’ professional skills and introducing them to careers in finance, consulting, and other business-related roles. With branches at colleges across the United States, it also offers members with mentorship services as well as networking opportunities.