Udemy - Excel Bootcamp - Go from Beginner to Excel Pro in 20 Steps

seeders: 28
leechers: 1
updated:
Added by tutsgalaxy in Other > Tutorials

Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 2495
  • Language: English

Files

Excel Bootcamp - Go from Beginner to Excel Pro in 20 Steps [Tutsgalaxy.com] - Excel Bootcamp - Go from Beginner to Excel Pro in 20 Steps 20 The Complete Walk-Through of Excel Tools and Ribbons
  • 103 View Tab part 2 - The Complete Walk-Through.mp4 (71.9 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.0 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.0 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)
  • 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)
01 Introduction to the Course
  • 001 Introduction - What Youll Learn.mp4 (19.2 MB)
  • 002 How to Get the Most Out of This Course.mp4 (14.4 MB)
  • 003 Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon.mp4 (31.9 MB)
  • 004 Using Excel Templates to Save Time and Effort.mp4 (36.3 MB)
  • quizzes
    • 001 Test Your Knowledge.html (3.5 KB)
    02 Creating Your First Excel Document
    • 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 (0.9 KB)
    03 Create a Kitchen Remodel Cost Worksheet
    • 010 Introduction - Creating and Formatting Your Heading.mp4 (9.0 MB)
    • 011 Formatting Subheadings and Columns and Alphabetizings Lists.mp4 (9.5 MB)
    • 012 Entering and Formatting Numbers.mp4 (8.0 MB)
    • 013 Create Formulas to Quickly Calculate Your Costs.mp4 (16.8 MB)
    • 014 Formatting - Grids and Spacing.mp4 (10.7 MB)
    • quizzes
      • 002 Test Your Knowledge.html (4.5 KB)
      04 Introduction to Excel Formulas and Functions
      • 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)
      • quizzes
        • 003 Test Your Knowledge.html (5.4 KB)
        05 3 Things to Know Before You Start Using Functions
        • 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)
        • quizzes
          • 004 Test Your Knowledge.html (5.2 KB)
          06 How to Use the 7 Most Popular Excel Functions
          • 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)
          • attached_files 024 IF Functions
            • Excel-2016-IF-Function-Download.xlsx (10.0 KB)
            027 VLOOKUP Function
            • Excel-2016-VLOOKUP-Download.xlsx (12.7 KB)
            07 Other Popular Excel Functions
            • 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)
            • attached_files 029 CONCATENATE - Combining Text
              • Excel-2016-Concatenate-Download.xlsx (9.7 KB)
              030 LEN - Length of Text
              • Excel-2016-LEN-Download.xlsx (9.3 KB)
              031 FIND and SEARCH
              • Excel-2016-Find-and-Search-Download.xlsx (9.6 KB)
              032 MIN and MAX
              • Excel-2016-Min-Max-Download.xlsx (11.9 KB)
              033 AND and OR
              • Excel-2016-AND-OR-Download.xlsx (12.2 KB)
              034 ROUND CEILING and FLOOR
              • Excel-2016-ROUND-download.xlsx (10.9 KB)
              035 Conditional Formatting
              • Excel-2016-CONDITIONAL-FORMATTING-Download.xlsx (13.1 KB)
              08 Creating Charts From Your Spreadsheet
              • 036 Charts Download.html (0.6 KB)
              • 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)
              • attached_files 036 Charts Download
                • Excel-2016-Charts-Download.xlsx (35.7 KB)
                09 Pivot Tables and Pivot Charts
                • 042 Pivot Tables Download.html (0.4 KB)
                • 043 Introduction to Pivot Tables - Preparing Your Data.mp4 (35.6 MB)
                • 044 How to Create a Pivot Table.mp4 (47.0 MB)
                • 045 Put Your Pivot Table to Work.mp4 (5

Description


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)



Download torrent
2.3 GB
seeders:28
leechers:1
Udemy - Excel Bootcamp - Go from Beginner to Excel Pro in 20 Steps


Trackers

tracker name
udp://inferno.demonoid.pw:3391/announce
udp://tracker.openbittorrent.com:80/announce
udp://tracker.opentrackr.org:1337/announce
udp://torrent.gresille.org:80/announce
udp://glotorrents.pw:6969/announce
udp://tracker.leechers-paradise.org:6969/announce
udp://tracker.pirateparty.gr:6969/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://tracker.leechers-paradise.org:6969/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://9.rarbg.to:2710/announce
udp://9.rarbg.com:2710/announce
udp://shadowshq.yi.org:6969/announce
udp://tracker.vanitycore.co:6969/announce
udp://tracker.zer0day.to:1337/announce
µTorrent compatible trackers list

Download torrent
2.3 GB
seeders:28
leechers:1
Udemy - Excel Bootcamp - Go from Beginner to Excel Pro in 20 Steps


Torrent hash: 6C5AFF5A90F27CF98026DD1D89318062EB83EBC7