Productivity in Excel using ExTool
4.3 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,128 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Productivity in Excel using ExTool to your Wishlist.

Add to Wishlist

Productivity in Excel using ExTool

Learn how to be a champion at work with cloud-powered Excel
4.3 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,128 students enrolled
Created by Zhenyu Zhu
Last updated 8/2016
English
Price: Free
Includes:
  • 4 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • At the end of this course, students will be able to master their Excel skills by learning both basic and extended functions using the ExTool Application. Through this mastery, work efficiency will increase and result in a more productive, positive work or educational environment.
View Curriculum
Requirements
  • Students will need the Excel software and will also need to download the ExTool Add-on Application from the ParaTool website. It would be helpful to know the basic Excel functions, but not necessary.
Description

This course will include Excel topics such as working with templates, workbook and worksheet management, page setup & printing, range tools, formulas, and file & folder management. Each virtual lecture includes a visual demonstration along with audio or written commentary. At the end of the course, users are exposed to case studies—practical applications that are useful in both a workplace and educational setting. Students should take this course if they are using Excel in their daily lives—especially if they are manually completing redundant tasks with large amounts of data. Excel itself can seem very complex and not so user-friendly. By completing this course and learning the ExTool functions, users can execute basic and advanced tasks automatically and, therefore, more efficiently.

Who is the target audience?
  • Students that use Excel in their daily work or education should take this course, no matter his or
Students Who Viewed This Course Also Viewed
Curriculum For This Course
120 Lectures
04:05:56
+
ExTool Introduction
4 Lectures 28:08

In this lecture, ExTool will be introduced. ExTool is a cloud-based, add-on application for Excel designed to eliminate repetitive tasks and, therefore, increases your productivity.

Lecture 1: ExTool Introduction
06:00

This lecture will demonstrate how to install, setup, and register ExTool for first time use.

Lecture 2: ExTool Initial Setup
05:33

This lecture will introduce ExTool's user interface and demonstrate how some apps are run and used.

Lecture 3: ExTool First Time Use
15:38

For better accessing to ExTool app, we prepare customized ribbon (zip file) for each section. You can download it directly from Udemy or from link https://dl.dropboxusercontent.com/u/32072909/ExTool/RibbonLayout/Udemy_Ribbon/Udemy_Ribbon.zip

Unzip the zip file and follow the instruction in this lecture to import ribbon.

Lecture 4: ExTool Import Ribbon
00:57
+
Info & Template
4 Lectures 03:23
Lecture 1: Information in Excel--Who's Who?
00:47

Lecture 2: Excel—Function Help Summary
00:54

Lecture 3: Information (ShortCut)—Excel 2010
00:43

Lecture 4: Template Chart—Chandoo
00:59
+
Excel Workbook Management
7 Lectures 12:45

This section will introduce how to manage Excel workbooks. The current practice relies on a file system and built-in functions without a record of any GUI actions. With ExTool, you can batch process workbooks and easily track changes. This section will also demonstrate how to convert .xls files to .xlsx files and how to manipulate workbooks.

Excel Workbook Management
05:28

Lecture 1: Convert .xls to .xlsx
01:40

Lecture 2: Open Folder of This File
01:17

Lecture 3: Combine Listed Workbook
00:47

Lecture 4: List Recent Workbooks
01:33

Lecture 5: Remove Listed Files from Recent Workbook List
01:03

Lecture 5: List Opened Workbooks
00:57
+
Excel Worksheet Management
16 Lectures 23:07

This section will introduce how to manage Excel worksheets. The current practice relies on a file system and built-in functions without a record of any GUI actions. With ExTool, you can batch process worksheets and easily track changes. This section will also demonstrate how to add, delete, copy, rename, hide, and protect worksheets.

Excel Worksheet Management
06:03

Lecture 1: Add Listed Sheet
01:23

Lecture 2: Delete Listed Sheet
01:24

Lecture 3: List Sheet Name and Range (A1)
01:37

Lecture 4: Excel—Copy Listed Sheet to New Workbook
00:59

Lecture 5: Copy Each Listed Sheet to New Workbook
01:14

Lecture 6: Combine Data in Listed Sheet
00:50

Lecture 7: Copy Listed Sheet and Update Link
00:59

Lecture 8: Sort Sheet in Listed Order
01:04

Lecture 9: Rename Listed Sheet
01:08

Lecture 10: Get Listed Sheet Color
00:59

Lecture 11: Change Listed Sheet Color
01:13

Lecture 12: Hide Listed Sheet
00:55

Lecture 13: Unhide Listed Sheet
00:55

Lecture 14: Protect Listed Sheets
01:07

Lecture 15: Un-Protect Listed Sheets
01:17
+
Excel Page Setup and Print
6 Lectures 13:28

In this section, setting up pages in Excel will be introduced. The current practice has no record of GUI actions and is not consistent in quality. With ExTool’s built-in feature to track changes, these actions can be reversed anytime. Moreover, this lesson will show how to copy and clear sheet page setup and how to print ranges.

Excel Page Setup and Print
06:45

Lecture 1: Copy Listed Sheet Page Setup
02:05

Lecture 2: Clear Listed Sheet Page Setup
01:07

Lecture 3: Print Selected Range to PDF
01:08

Lecture 4: Print Listed Sheet to PDF
01:09

Lecture 5: Print Charts in Sheets to GIF
01:14
+
Excel Graphic Object Management
6 Lectures 10:10

This section will demonstrate how to manage objects in Excel. The current practice has no record of GUI actions and is not consistent in quality. With ExTool’s built-in feature to track changes, these actions can be reversed anytime. Moreover, this lesson will show how to print, list, rename, delete, relocate, and resize objects.

Excel Graphic Object Management
04:10

Lecture 1: List Objects in This Sheet
01:03

Lecture 2: Rename Listed Objects
00:52

Lecture 3: Delete Listed Objects
01:07

Lecture 4: Relocate Listed Objects
01:14

Lecture 5: Resize Listed Objects
01:44
+
Range – Select and List
10 Lectures 12:13

This section will introduce how to efficiently manage Excel ranges. Sometimes, ranges need to be selected intelligently based on specific criteria. The current practice has no record of GUI actions and, sometimes, one mistake will ruin all previous steps and force the user to repeat the task. This section will also demonstrate how to list objects and how other apps can be used to conduct specific actions will be introduced.

Range – Select & List
04:35

Lecture 1: List Selected Ranges
01:03

Lecture 2: Select Listed Ranges
01:02

Lecture 3: Select Non-Empty Cells In Target Range
00:46

Lecture 4: Select Empty Cells in Target Range
00:53

Lecture 5: Select Maximum Value in Each Column of Target Range
00:58

Lecture 6: Select Maximum Value in Each Row of Target Range
00:47

Lecture 7: Select Maximum Value in Target Range
00:44

Lecture 8: Select Minimum Value in Each Row of Target Range
00:43

Lecture 9: Select Minimum Value in Target Range
00:42
+
Range – Copy and Move
6 Lectures 12:10

This section will introduce how to efficiently manage Excel ranges. Sometimes, ranges need to be selected intelligently based on specific criteria. The current practice has no record of GUI actions and, sometimes, one mistake will ruin all previous steps and force the user to repeat the task. This section will also demonstrate how to select a minimum and maximum value from a range and convert a column to a range.

Range – Copy & Move
05:18

Lecture 1: Column to Range
01:36

Lecture 2: Range to Column
01:02

Lecture 3: Copy Selected Ranges
01:59

Lecture 4: Copy Listed Ranges
01:01

Lecture 5: Copy Range Exact Formula
01:14
+
Range – Hyperlink
5 Lectures 08:25

This section will introduce how to efficiently manage Excel ranges. Sometimes, ranges need to be selected intelligently based on specific criteria. The current practice has no record of GUI actions and, sometimes, one mistake will ruin all previous steps and force the user to repeat the task. This section will also demonstrate how to add hyperlinks.

Range – Hyperlink
03:01

Lecture 1: Add External Hyperlink
01:36

Lecture 2: Add Internal Hyperlink
01:34

Lecture 3: List Internal Hyperlink
01:09

Lecture 4: List External Hyperlink
01:05
+
Range – Text
7 Lectures 10:13

This section will introduce how to efficiently manage Excel ranges. Sometimes, ranges need to be selected intelligently based on specific criteria. The current practice has no record of GUI actions and, sometimes, one mistake will ruin all previous steps and force the user to repeat the task. This section will also demonstrate how to manipulate the ranges’ text.

Range – Text
04:26

Lecture 1: Concat Cells
01:20

Lecture 2: Reverse Text
00:44

Lecture 3: Replace Star in Cell Text
00:58

Lecture 4: Upper Case Text in Range
00:49

Lecture 5: Capitalize Each Word in Range
00:50

Lecture 6: Lower Case Text in Range
01:06
10 More Sections
About the Instructor
Zhenyu Zhu
3.4 Average rating
45 Reviews
3,797 Students
3 Courses
CEO at ParaTool

Dr. Zhenyu Zhu is a senior data analyst, database specialist, and seasoned structural engineer. Hehas 20 years of experience using Excel with advanced data analysis and presentation functionalities and 10 years of programming experience with multiple languages—including Excel VBA. Over the years, he has served as the lead analytical engineer for multiple landscape bridge projects, most significantly the San Francisco-Oakland Bay Bridge. During this time, he also implemented a cloud-based platform to facilitate data communication between multiple disciplinary workers of the design and construction project. The cloud-based platform has, hence, extended to other industrial fields and served as the infrastructure for all of the apps discussed within this course.