YoVDO

Excel Spreadsheet Design Tips and Tricks

Offered By: Simon Sez IT via YouTube

Tags

Microsoft Excel Courses Data Visualization Courses Productivity Courses User Interface Design Courses Data Validation Courses Data Entry Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Learn essential Excel spreadsheet design techniques in this 41-minute video tutorial. Enhance spreadsheet readability with cell styles, implement data validation for input control, add navigation buttons for improved user experience, create summary sheets for quick insights, and utilize forms for rapid data entry. Follow along with timestamped sections to focus on specific skills or complete the entire tutorial to elevate your spreadsheet design capabilities.

Syllabus

- Simon Sez IT Intro
- Design Better Spreadsheets
- Improve Readability with Cell Styles
- Control Data Input: Data Validation
- Add Navigation Buttons
- Create a Summary Sheet
- Use Forms to Input Data Quickly
- Exercise 02


Taught by

Simon Sez IT

Related Courses

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard