Author
Curt Frye
Released
9/24/2018Note: This course was recorded on Excel for Office 365. Most of the course contents will also be useful to those working with the most recent standalone versions of Office, including Office 2019 and 2016.
- Creating a formula
- Using operators and cell references
- Summarizing data with formulas
- Working with named ranges
- Summarizing data with Excel tables
- Importing data for analysis in Excel
- Cleaning up data
- Auditing formulas
- Identifying and tracing formula errors
- Performing What-If Analysis
Skill Level Beginner
Duration
Views
- [Curt] Excel 2019 is a powerful tool for evaluating data within your business or organization. Creating useful calculations brings that information to the surface and helps you make good decisions. In this course, I'll use real world examples to demonstrate how you can apply the incredible power of Excel to your data. I'm Curt Frye. Join me at LinkedIn learning for an introduction to the foundation of Excel's power and versatility, formulas and functions
-
Introduction
-
1. Introducing Excel 2019 Formulas and Functions
-
Create a formula6m 28s
-
Edit a formula3m 28s
-
2. Creating Basic Summary Functions
-
Create an AutoSum formula4m 16s
-
3. Managing Named Ranges and Excel Tables
-
Create a dynamic named range4m 31s
-
Edit and delete named ranges2m 49s
-
Group and outline list data2m 54s
-
4. Preparing Data for Analysis in Excel
-
Import data into Excel3m 8s
-
Convert text to columns3m 30s
-
Create data validation rules5m 35s
-
-
5. Auditing Worksheet Formulas
-
Identify and trace errors1m 23s
-
Watch cell values3m 13s
-
6. Performing What-If Analysis
-
Conclusion
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Introduction to formulas and functions