| 001 Introduction - What Youll Learn.mp4 | 19.2 MB | ||
| 001 Test Your Knowledge.html | 3.5 KB | ||
| 002 How to Get the Most Out of This Course.mp4 | 14.4 MB | ||
| 002 Test Your Knowledge.html | 4.5 KB | ||
| 003 Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon.mp4 | 31.9 MB | ||
| 003 Test Your Knowledge.html | 5.4 KB | ||
| 004 Test Your Knowledge.html | 5.2 KB | ||
| 004 Using Excel Templates to Save Time and Effort.mp4 | 36.3 MB | ||
| 005 Saving Your Document Where You Can Find It.mp4 | 7.1 MB | ||
| 006 Entering Data and Navagating Around the Cells.mp4 | 7.6 MB | ||
| 007 Creating Simple Formulas to Do Powerful Calculations.mp4 | 18.5 MB | ||
| 008 Working with Workbooks and Worksheets.mp4 | 24.1 MB | ||
| 009 Put Your Knowledge to Work - Create Your First Excel Document.html | 921.6 B | ||
| 010 Introduction - Creating and Formatting Your Heading.mp4 | 9 MB | ||
| 011 Formatting Subheadings and Columns and Alphabetizings Lists.mp4 | 9.5 MB | ||
| 012 Entering and Formatting Numbers.mp4 | 8 MB | ||
| 013 Create Formulas to Quickly Calculate Your Costs.mp4 | 16.8 MB | ||
| 014 Formatting - Grids and Spacing.mp4 | 10.7 MB | ||
| 015 Introduction to Excel Formulas and Functions.mp4 | 11.2 MB | ||
| 016 What is a Formula and What Can It DO for You.mp4 | 4.1 MB | ||
| 017 What is a Function and What Does IT Do.mp4 | 23.3 MB | ||
| 018 The Anatomy of a Formula.mp4 | 15.9 MB | ||
| 019 Quickly Select Cells to Use in Your Formula.mp4 | 11.6 MB | ||
| 020 Absolute vs. Relative Cell References.mp4 | 15.2 MB | ||
| 021 How to Use the Downloads to Learn Functions Faster.mp4 | 13.8 MB | ||
| 022 AVERAGE and AVERAGEA Functions.mp4 | 6.3 MB | ||
| 023 COUNT COUNTA and COUNTBLANK Functions.mp4 | 10.7 MB | ||
| 024 IF Functions.mp4 | 24.8 MB | ||
| 025 SUMIF and SUMIFS Functions.mp4 | 17.7 MB | ||
| 026 COUNTIF and COUNTIFS Functions.mp4 | 12.3 MB | ||
| 027 VLOOKUP Function.mp4 | 39.2 MB | ||
| 028 LEFT RIGHT and MID Functions.mp4 | 22.6 MB | ||
| 029 CONCATENATE - Combining Text.mp4 | 11.5 MB | ||
| 030 LEN - Length of Text.mp4 | 6.9 MB | ||
| 031 FIND and SEARCH.mp4 | 8.5 MB | ||
| 032 MIN and MAX.mp4 | 11.7 MB | ||
| 033 AND and OR.mp4 | 15.9 MB | ||
| 034 ROUND CEILING and FLOOR.mp4 | 29.9 MB | ||
| 035 Conditional Formatting.mp4 | 30.7 MB | ||
| 036 Charts Download.html | 614.4 B | ||
| 037 Introduction - How to Create a Chart.mp4 | 21.7 MB | ||
| 038 Format Your Chart.mp4 | 19.2 MB | ||
| 039 Create a Bar Chart.mp4 | 19.8 MB | ||
| 040 Create a Pie Chart.mp4 | 31.1 MB | ||
| 041 Create a Line Chart.mp4 | 18.6 MB | ||
| 042 Pivot Tables Download.html | 409.6 B | ||
| 043 Introduction to Pivot Tables - Preparing Your Data.mp4 | 35.6 MB | ||
| 044 How to Create a Pivot Table.mp4 | 47 MB | ||
| 045 Put Your Pivot Table to Work.mp4 | 50.2 MB | ||
| 046 Pivot Charts Download.html | 512 B | ||
| 047 Pivot Charts.mp4 | 27.5 MB | ||
| 048 Whats New in Excel 2016.mp4 | 20.7 MB | ||
| 049 6 New Chart Types for 2016.mp4 | 27 MB | ||
| 050 Tell Me What You Want To Do - The New Help Feature.mp4 | 9.6 MB | ||
| 051 1-Click Forecasting.mp4 | 22.3 MB | ||
| 052 3D Maps.mp4 | 53.3 MB | ||
| 053 Saving as CSV Text and PDF.mp4 | 43.2 MB | ||
| 054 Saving Backups of Your Excel Files.mp4 | 9.1 MB | ||
| 055 Using the AutoRecover Feature.mp4 | 20.1 MB | ||
| 056 Import from Web CopyPaste and Cleaning Up Data.mp4 | 21.9 MB | ||
| 057 Import from CSV file and Excel Workbook.mp4 | 24 MB | ||
| 058 Import from Access Database.mp4 | 21.8 MB | ||
| 059 Print Your Excel Document.mp4 | 14.3 MB | ||
| 060 Excel Keyboard Shortcuts.mp4 | 25.7 MB | ||
| 061 ALT Key Shortcuts.mp4 | 11.5 MB | ||
| 062 TEXT.mp4 | 14.7 MB | ||
| 063 REPT - Repeat.mp4 | 14.1 MB | ||
| 064 UPPER LOWER and PROPER.mp4 | 6.7 MB | ||
| 065 TRIM - Remove Extra Spaces.mp4 | 14.6 MB | ||
| 066 Combining LEFT MID FIND and TRIM.mp4 | 23.3 MB | ||
| 067 HYPERLINK - Create a Table of Contents for Your Worksheets.mp4 | 18.6 MB | ||
| 068 RAND and RANDBETWEEN - Random Numbers.mp4 | 3.9 MB | ||
| 069 ROUND.mp4 | 6.9 MB | ||
| 070 INT - Integer.mp4 | 5.5 MB | ||
| 071 MOD - Remainder.mp4 | 4.4 MB | ||
| 072 DATE and DATEVALUE.mp4 | 14.8 MB | ||
| 073 TIME.mp4 | 7.4 MB | ||
| 074 TODAY and NOW.mp4 | 4.7 MB | ||
| 075 YEAR MONTH DAY HOUR MINUTE and SECOND.mp4 | 7.2 MB | ||
| 076 WEEKDAY and WEEKNUM.mp4 | 6 MB | ||
| 077 IFERROR.mp4 | 7.6 MB | ||
| 078 LARGE and SMALL.mp4 | 12.6 MB | ||
| 079 INDEX and MATCH.mp4 | 24 MB | ||
| 080 Nested INDEX MATCH IF and IFERROR.mp4 | 9.1 MB | ||
| 081 Nested IF AND and OR Functions.mp4 | 14.1 MB | ||
| 082 Record Your First Macro.mp4 | 28.6 MB | ||
| 083 Saving Your Macro and Security.mp4 | 12.4 MB | ||
| 084 Use a Macro to Create a Template.mp4 | 13 MB | ||
| 085 How to Use Relative Cell References.mp4 | 47.1 MB | ||
| 086 Easy Cell-Formatting Macro.mp4 | 15.4 MB | ||
| 087 Intro - The Complete Walk-Through.mp4 | 12.4 MB | ||
| 088 File Menu - The Complete Walk-Through.mp4 | 48.3 MB | ||
| 089 Home Tab part 1 - The Complete Walk-Through.mp4 | 59.5 MB | ||
| 090 Home Tab part 2 - The Complete Walk-Through.mp4 | 49.1 MB | ||
| 091 Insert Tab part 1 - The Complete Walk-Through.mp4 | 51.3 MB | ||
| 092 Insert Tab part 2 - The Complete Walk-Through.mp4 | 67.5 MB | ||
| 093 Insert Tab part 3 - The Complete Walk-Through.mp4 | 69 MB | ||
| 094 Page Layout Tab part 1 - The Complete Walk-Through.mp4 | 63.3 MB | ||
| 095 Page Layout Tab part 2 - The Complete Walk-Through.mp4 | 14.1 MB | ||
| 096 Formulas Tab part 1 - The Complete Walk-Through.mp4 | 38 MB | ||
| 097 Formulas Tab part 2 - The Complete Walk-Through.mp4 | 32.8 MB | ||
| 098 Data Tab part 1 - The Complete Walk-Through.mp4 | 51.4 MB | ||
| 099 Data Tab part 2 - The Complete Walk-Through.mp4 | 26.2 MB | ||
| 100 Data Tab part 3 - The Complete Walk-Through.mp4 | 60.9 MB | ||
| 101 Review Tab - The Complete Walk-Through.mp4 | 54.6 MB | ||
| 102 View Tab part 1 - The Complete Walk-Through.mp4 | 36.2 MB | ||
| 103 View Tab part 2 - The Complete Walk-Through.mp4 | 71.9 MB | ||
| 104 Developer Tab part 1 - The Complete Walk-Through.mp4 | 32.6 MB | ||
| 105 Developer Tab part 2 - The Complete Walk-Through.mp4 | 24.5 MB | ||
| 106 Conclusion.mp4 | 12.6 MB | ||
| DATE-and-DATEVALUE-Download.xlsx | 10.7 KB | ||
| Excel-2016-AND-OR-Download.xlsx | 12.2 KB | ||
| Excel-2016-CONDITIONAL-FORMATTING-Download.xlsx | 13.1 KB | ||
| Excel-2016-Charts-Download.xlsx | 35.7 KB | ||
| Excel-2016-Concatenate-Download.xlsx | 9.7 KB | ||
| Excel-2016-Find-and-Search-Download.xlsx | 9.6 KB | ||
| Excel-2016-IF-Function-Download.xlsx | 10 KB | ||
| Excel-2016-LEN-Download.xlsx | 9.3 KB | ||
| Excel-2016-Min-Max-Download.xlsx | 11.9 KB | ||
| Excel-2016-Pivot-CHARTS-Download.xlsx | 21.4 KB | ||
| Excel-2016-Pivot-Tables-Download-REVISED.xlsx | 20.8 KB | ||
| Excel-2016-ROUND-download.xlsx | 10.9 KB | ||
| Excel-2016-VLOOKUP-Download.xlsx | 12.7 KB | ||
| Excel-Shortcut-Keys-List.pdf | 288.4 KB | ||
| INDEX-MATCH-Download.xlsx | 10.3 KB | ||
| INT-Function-Download.xlsx | 8.1 KB | ||
| LEFT-and-MID-Function-Download.xlsx | 9.6 KB | ||
| MOD-Function-Download.xlsx | 8.5 KB | ||
| Nested-IF-AND-and-OR-Download.xlsx | 8.8 KB | ||
| Nested-INDEX-MATCH-IF-and-IFERROR-Download.xlsx | 11.4 KB | ||
| Read Me.txt | 102.4 B | ||
| TIME-Download.xlsx | 10.6 KB | ||
| TRIM-Function-Download.xlsx | 9.6 KB | ||
| Torrent_downloaded_from_Demonoid_-_www.demonoid.pw_.txt | 102.4 B | ||
| TutsGalaxy.com.txt | 0 B | ||
| WEEKDAY-WEEKNUM-Download.xlsx | 8.6 KB | ||
| ▲ 137 total files | |||
Description
Welcome to my BIGGEST, most complete, Microsoft Excel course ever. Excel is one of the most important skills in today’s job market. Having a solid working knowledge of Excel can improve your job performance, help you qualify for raises and promotions, or even help you land that new job that you deserve. If you need to know Excel, you’re in the right place. This course walks you through Excel from the very basics of opening Excel all the way to advanced Excel skills used by the pros, like pivot tables and macros. My goal with this course is to give you the skills you need to get that raise, promotion, or new job you deserve.This course was created using Excel 2016, but it is good for versions 2013 and 2010 as well. It was created for use with a PC (personal computer). Mac (Macintosh) users can still benefit from this course, but the course doesn’t cover Mac-specific keyboard shortcuts and interface.
We’ll start at the very beginning, with opening and saving a worksheet in Excel.
I’ll show you what all the tools do and walk you through each Excel skill that you need to know.
I’ll show you how to enter and format your data and how to create charts, tables and pivot tables so you can organize and analyze your data. I’ll teach you amazing keyboard shortcuts to make your work faster and more productive. You’ll learn how to record macros so you can do a whole series of actions with the just click of a button.
We’ll keep going until you’re a pro at Excel. When you finish this course, you’ll know more than most people who use Excel at their job every day.
Here’s some of what you’ll learn.
Creating spreadsheets in Excel
Saving your work where you can find it
Working with multiple workbooks in Excel
Formatting and printing
Importing data from CSV files, Access and the web
Creating and using formulas and functions like: Vlookup, Index/Match, If statements and dozens of others
Creating charts including: Bar charts, Line charts, Column charts, Pie charts and more
Creating tables
Sorting and filtering your data
Creating pivot tables
Creating pivot charts from your pivot tables
Fun New features for Excel 2016
Keyboard shortcuts to make your work go faster
How to record basic macros to automate repetitive tasks
A whole lot more
The course comes with a certificate of completion, a full 30-day money back guarantee, and I’m always available to answer questions or share additional resources if you get stuck.
Who is the target audience?
Anyone who wants or needs to learn Microsoft Excel for their work.
Anyone who wishes to improve their job or career prospects in an office environment.
Design for beginners who are brand new to Excel (also suitable for intermediate Excel users who want to improve).
Requirements
You should have basic computer skills.
You should have a PC (you can get by with a Mac, but this course is not specifically designed for Mac users)
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - Data Analytics for Beginners - Excel, SQL, and AI Dashboards Posted by
freecoursewb in Other
|
2.1 GB | freecoursewb | 1 day | 0 | 0 |
| 2.7 GB | freecoursewb | 1 month | 12 | 1 | |
| 2.7 GB | freecoursewb | 1 month | 18 | 1 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 1 month | 9 | 5 |
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 1 month | 6 | 1 |
All Comments