01 May Excel Basics to Analytics for Business Workshop
WORKSHOP: Excel Basics to Analytics for Business
INSTRUCTOR:
David Raynor
DATE:
Thursday, May 26th, 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.
Sorry, the comment form is closed at this time.