Excel Workshop II: Warm Up Session for Excel Intermediate Level Weekend Class

Vivian Zhang
Posted on Apr 4, 2014
NYC Data Science Academy is offering an relative courses:

--------------------------------------

Video:

Desktop recorded:

Video Camera Recording:

--------------------------------------

Meetup Announcement:

This hands-on workshop is intended to introduce concepts for working with Excel and VBA. Familiarity with Excel is recommended and necessary to get the most from the presentation. After topics are introduced attendants have a chance to practice with them for a few minutes on a sample workbook.

Speaker: Mary DiPerna (Master’s in computer science), our instructor of Excel class in NYC Data Science Academy.

More about the Speaker:

"I have worked with Excel and VBA intensely for more than 10 years. I have worked with clients to develop complex Excel systems that combine lookup and summary formulas with macros to import data from sales, accounting and personnel systems and produce complex data analysis.

For example: one spreadsheet was used to determine pay raises and bonuses across multiple departments, based on performance statistics imported from the sales and personnel systems and another was used to analysis various cost/profit alternatives based on different style and vendors options."

Outline:

Topics including: Quick tour of multi-sheet formulas (3D and multi-reference) and multi-file formulas, Named Ranges as a technique for maintaining data integrity in multi-file calculation, Lookup and Logical functions, Overlay and data segmentation charts, Data summarization of lists with formulas and Pivot Tables, Data analysis with Data tables, Macros and Buttons and automation ideas.

Preparation:

Please have an installed version of Excel ready to go.
Macs: The sample files will work with MACS, although the screen interface may vary from the ones displayed.

About Author

Vivian Zhang

Vivian Zhang

Vivian is a data scientist who has been devoted to the analytics industry and the development and use of data technologies for several years. She obtained expertise in data analysis and data management as a Senior Analyst and...
View all posts by Vivian Zhang >

Related Articles

Leave a Comment

No comments found.

View Posts by Categories


Our Recent Popular Posts


View Posts by Tags

#python #trainwithnycdsa 2019 airbnb Alex Baransky alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus API Application artist aws beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep Bundles California Cancer Research capstone Career Career Day citibike clustering Coding Course Demo Course Report D3.js data Data Analyst data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization Deep Learning Demo Day Discount dplyr employer networking feature engineering Finance Financial Data Science Flask gbm Get Hired ggplot2 googleVis Hadoop higgs boson Hiring hiring partner events Hiring Partners Industry Experts Instructor Blog Instructor Interview Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter lasso regression Lead Data Scienctist Lead Data Scientist leaflet linear regression Logistic Regression machine learning Maps matplotlib Medical Research Meet the team meetup Networking neural network Neural networks New Courses nlp NYC NYC Data Science nyc data science academy NYC Open Data NYCDSA NYCDSA Alumni Online Online Bootcamp Open Data painter pandas Part-time Portfolio Development prediction Prework Programming PwC python python machine learning python scrapy python web scraping python webscraping Python Workshop R R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn Selenium sentiment analysis Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau team TensorFlow Testimonial tf-idf Top Data Science Bootcamp twitter visualization web scraping Weekend Course What to expect word cloud word2vec XGBoost yelp