Главная
Study mode:
on
1
Introduction to Excel-1
2
Introduction to Excel-2
3
Introduction to Excel-3
4
Importing Data into Excel
5
Data Tables in Excel
6
Data Tables in Excel: Two Dependent Variables
7
Naming Cells in Excel
8
Formatting in Excel
9
Formatting Numbers in Excel
10
Entering an Equation into Excel
11
Linearize/Plot Non-Linear Equations (Excel)
12
Overview of Scatter and Line Plots in Excel
13
Scatter Plots in Excel
14
Line Plots in Excel
15
Overview of Pie Charts and Bar Graphs in Excel
16
Pie Charts in Excel
17
Bar Graphs in Excel
18
Creating a Scatter Plot using Regression Analysis
19
3D Plots in Excel
20
Trend Lines in Excel
21
Iterative Solutions/Excel
22
Excel Goal Seek Introduction
23
Excel Goal Seek Example
24
Excel Solver Introduction
25
Dynamic Naming of Arrays in Excel
26
Histogram in Excel
27
An Alternate to Excel's VLOOKUP for Searches in Tables
28
Excel Case Study: Cantilever Beam Part 3 - One-Way Data Table
29
Excel Case Study: Cantilever Beam Part 1 - Spreadsheet Setup
30
Excel Case Study: Cantilever Beam Part 2 - Formula Approach
31
Referencing Cells in Excel
32
Excel Case Study: Circular Calculation
33
Microsoft Excel Event Handlers
34
When Iterative Solving Does Not Work in Excel
35
An Introduction to Excel's Built-in Functions
36
Golden Section Search Method
37
Lookup Functions in Excel Part 1: VLOOKUP
38
Lookup Functions in Excel Part 2: MATCH, OFFSET, and INDEX Functions
39
Using Excel's Matrix Functions to Solve Linear Systems of Equations
40
Solving Optimization Problems in Excel
41
Linear Regression in Excel
42
Excel Case Study: Cantilever Beam Part 4 - Two-Way Data Table
43
Excel Syntax and Order of Operations
44
Solving a Nonlinear Equation in Excel
45
Solve a Set of Nonlinear Equations Using Solver
Description:
Learn essential Microsoft Excel skills through comprehensive screencasts covering a wide range of topics. Master Goal Seek and Solver functionalities, explore formatting techniques, and create various types of graphs and plots. Dive into data manipulation, formula creation, and advanced features like regression analysis and matrix functions. Gain practical experience through case studies and real-world examples, including cantilever beam analysis and optimization problem-solving. Enhance your Excel proficiency with lessons on cell referencing, built-in functions, and efficient data lookup methods. Perfect for beginners and intermediate users alike, this tutorial series provides a solid foundation for leveraging Excel's powerful capabilities in engineering and data analysis tasks.

Microsoft Excel

Add to list