Workshop: Excel Basics to Analytics for Business - Fuquay Coworking by Empowered Ideas
Fuquay Coworking, by Empowered Ideas, is a creative coworking space designed for local entrepreneurs — by entrepreneurs. Our mission is to foster creative entrepreneurial development through a creative environment, resources, and access to business services successful entrepreneurs need. We bring the resources and knowledge of enterprise business to local small business owners, in a safe and pressure-free environment, and without the need to invest in expensive office space and equipment.
Coworking, Fuquay-Varina, Fuquay, Varina, Office, Office Space, Cowork, Shared Office, Community Coworking, Coworking Community
16207
post-template-default,single,single-post,postid-16207,single-format-standard,ajax_fade,page_not_loaded,,hide_top_bar_on_mobile_header,qode-theme-ver-12.1,qode-theme-bridge,wpb-js-composer js-comp-ver-7.9,vc_responsive

Workshop: Excel Basics to Analytics for Business

29 Apr Workshop: Excel Basics to Analytics for Business

Posted at 15:06h in Blog, Community Events, Fuquay Coworking by
0 Likes

WORKSHOP: Excel Basics to Analytics for Business

INSTRUCTOR:
David Raynor

 

DATE:
Thursday, June 30th, 6pm to 8pm

 

LOCATION:
Fuquay Coworking
1000 N. Main Street, Suite 102
Fuquay-Varina, NC 27526

 

COST:
$25 per person

 

OVERVIEW:

This workshop exposes attendees to a the basic tools available in Spreadsheet programs as well as introducing them to more advanced (Easy) ways to sort visualize and analyze the data available.

 

Software Essentials

  • Spreadsheet Environment
  • Fundamentals of Spreadsheets
  • Cut, Copy, Insert, Delete, Paste
  • Custom Formatting, Undo, Redo
  • Formulas, Functions, & Calculations
  • Printing

 

See the Data (Charts)

  • Quick Charts
  • Formatting
  • Trend Lines
  • Sending Charts to Another Workbook. (Dashboarding)

 

A Little Beyond the Basics

  • Transpose Rows to Columns
  • If Functions
  • AutoFill Series
  • Calculation Validation (Checking)
  • Linking between Workbooks
  • Freeze Panes
  • Importing Data from elsewhere
  • Track History

 

The Analytics

  • Tables
  • Sorting and Filtering
  • Totals Row
  • Pivot Tables
  • Slicers
  • Pivot Charts

 

About the Instructor

David Raynor has 10+ years of experience using Excel to perform engineering calculations. Most recently he has been writing programs to harvest data from Architectural and Engineering Design models and create Excel reports used for enforcing company standards and making business decisions.

 
 
 

No Comments

Sorry, the comment form is closed at this time.