- Downloaded
- 135.2 GB
- Uploaded
- 13.1 TB
- Ratio
- 99.14
- Seedbonus
- 259,116
- Upload Count
- 265 (300)
Member for 9 years
[udemy] Excel 2019 Beginner
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 48.0 KHz
Language: English | Size: 756 MB | Duration: 29 lectures ( 1h 52m)
Learn the basics of Excel - how to build and format spreadsheets
with functions and formulas between cells
What you'll learn
Learn how to navigate Excel and create basic spreadsheets
Be able to use Excel's essential functions (sum, max, min, avg)
Select cells and sheets using keyboard shortcuts
Edit spreadsheets by adding columns and rows and much more
Create reusable fonts and formats in workbooks by saving them as templates
Make your spreadsheets suitable for printing
Requirements
Basic computer skills
No Excel knowledge required
Who this course is for
Excel beginners looking to learn the basics
Experienced Excel users looking for a quick refresher
Download
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 48.0 KHz
Language: English | Size: 756 MB | Duration: 29 lectures ( 1h 52m)
Learn the basics of Excel - how to build and format spreadsheets
with functions and formulas between cells
What you'll learn
Learn how to navigate Excel and create basic spreadsheets
Be able to use Excel's essential functions (sum, max, min, avg)
Select cells and sheets using keyboard shortcuts
Edit spreadsheets by adding columns and rows and much more
Create reusable fonts and formats in workbooks by saving them as templates
Make your spreadsheets suitable for printing
Requirements
Basic computer skills
No Excel knowledge required
Feel like you're the only person who doesn't know Excel and worried about getting up to speed? You're not alone, and we can help! Our Excel 2019 Beginner course leads you, step-by-step, through the basics of this popular spreadsheet program. There's plenty of time for practice and hands-on exercises to cement your new knowledge.
As we go through the training, you'll recognize — and finally understand — the very same features you've seen in Excel spreadsheets at work. By the end of this course, you'll be making those kinds of spreadsheets yourself.
First, we talk about lists. These could be lists of employees, products, customers, or anything else. Lists take advantage of Excel's formatting in rows and columns. You'll learn how to format and freeze table headers; change fonts, sizes and colors; and set printing specs.
We also go over tabulations. Excel is great at number-crunching and offers a slew of arithmetic functions you can apply to your data, like averages, sums, and counts.
Finally, we talk about computations. Typically financials, these could be budgets, income statements, invoices, tax computations or similar. These spreadsheets contain values that are tied together by formulas so that changing one instantly changes the others: for example, the same way changing revenue immediately flows through to a change in profits. The key to creating these tied-together spreadsheets is learning how to correctly reference the spots where data is kept ("cells") using formulas in other cells.
This is course 1 of 3 in Learnit Anytime’s Excel 2019 training series.
As we go through the training, you'll recognize — and finally understand — the very same features you've seen in Excel spreadsheets at work. By the end of this course, you'll be making those kinds of spreadsheets yourself.
First, we talk about lists. These could be lists of employees, products, customers, or anything else. Lists take advantage of Excel's formatting in rows and columns. You'll learn how to format and freeze table headers; change fonts, sizes and colors; and set printing specs.
We also go over tabulations. Excel is great at number-crunching and offers a slew of arithmetic functions you can apply to your data, like averages, sums, and counts.
Finally, we talk about computations. Typically financials, these could be budgets, income statements, invoices, tax computations or similar. These spreadsheets contain values that are tied together by formulas so that changing one instantly changes the others: for example, the same way changing revenue immediately flows through to a change in profits. The key to creating these tied-together spreadsheets is learning how to correctly reference the spots where data is kept ("cells") using formulas in other cells.
This is course 1 of 3 in Learnit Anytime’s Excel 2019 training series.
Who this course is for
Excel beginners looking to learn the basics
Experienced Excel users looking for a quick refresher
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
You must be registered for see links
Download
You must be registered for see links
You must be registered for see links
You must be registered for see links
Last edited: