Adobe Photoshop CC - Essentials Training Course

Adobe Photoshop CC - Essentials Training Course

Other
Size
4.9 GB
Seeders
0
Leechers
1
Files
99
Category
Other
Added
02/22/21 at 5:30pm GMT+1
Infohash
647ad4eed72da7ce59380c51ce19fc5d5f0f7281

Description
Description

**Includes downloadable follow-along files**

In this two-course bundle, we take you through how to perform a number of tasks in Excel by utilizing advanced functions and formulas, before moving onto how to use Macros and VBA to automate and supercharge your spreadsheets!

If you’ve used Excel a lot, but you know that you could be doing more with it, then this two-part course is for you. You’ll learn skills that will help you clean data, perform analysis, set up spreadsheets to collect data, and create amazing looking charts that auto-update.

This course includes follow-along instructor files so you can immediately practice what you learn. This class is not for Excel beginners. You will need an intermediate knowledge of Excel to get the most from these videos.

In the Advanced Functions and Formulas part of the course you will learn how to:

Filter a dataset using a formula
Sort a dataset using formulas and defined variables
Create multi-dependent dynamic drop-down lists
Perform a 2-way lookup
Make decisions with complex logical calculations
Extract parts of a text string
Create a dynamic chart title
Find the last occurrence of a value in a list
Look up information with XLOOKUP
Find the closest match to a value

In the Macros and VBA part of the course you will learn:

Examples of Excel Macros
What is VBA?
How to record your first macro
How to record a macro using relative references
How to record a complex, multi-step macro and assign it to a button
How to set up the VBA Editor
How to edit Macros in the VBA Editor
How to get started with some basic VBA code
How to fix issues with macros using debugging tools
How to write your own macro from scratch
How to create a custom Macro ribbon and add all the Macros you’ve created

4+ hours of video tutorials
27 individual video lectures
Instructor files to practice as you learn
Certificate of completion

Who this course is for:

Those wanting to automate Excel task or procedures.
Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions
Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge.

Requirements

Microsoft Excel for Windows. The course was created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.
Intermediate knowledge of Microsoft Excel.

Last Updated 2/2021

File list
  • Adobe Photoshop CC - Essentials Training Course
  • .pad/0 183 B
  • .pad/1 63 B
  • TutsNode.com.txt 63 B
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/02 Before you start this Adobe Photoshop CC Tutorial.en.srt 9.8 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/02 Before you start this Adobe Photoshop CC Tutorial.en.vtt 9.5 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/03 How to use layers in Adobe Photoshop CC.en.srt 17.7 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/03 How to use layers in Adobe Photoshop CC.en.vtt 17 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/04 Basic navigation & how to combine images in Photoshop.en.srt 15.6 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/04 Basic navigation & how to combine images in Photoshop.en.vtt 15 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/10 How to add a gradient to an image & text in Photoshop.en.srt 19.2 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/10 How to add a gradient to an image & text in Photoshop.en.vtt 18.4 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/11 Creating a specific sized document Adobe Photoshop CC.en.srt 7.2 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/12 How to draw star square circle shape in Photoshop CC.en.srt 21.1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/12 How to draw star square circle shape in Photoshop CC.en.vtt 20.2 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/13 Stealing Colors & Adobe Color Themes.en.srt 10.7 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/13 Stealing Colors & Adobe Color Themes.en.vtt 10.4 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/14 How to create text in Adobe Photoshop CC.en.srt 13.7 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/14 How to create text in Adobe Photoshop CC.en.vtt 13.1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/16 How to get text to follow a line or circle in Photoshop.en.srt 22.1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/16 How to get text to follow a line or circle in Photoshop.en.vtt 21.1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/17 How to add a line around the outside of type in Photoshop.en.srt 14.3 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/17 How to add a line around the outside of type in Photoshop.en.vtt 13.8 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/20 Presenting your Photoshop work for your portfolio.en.srt 11.2 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/20 Presenting your Photoshop work for your portfolio.en.vtt 10.9 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/21 Project 1 - Creating your own postcard.en.srt 9 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/23 How to crop an image for a frame in Adobe Photoshop CC.en.srt 10.3 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/23 How to crop an image for a frame in Adobe Photoshop CC.en.vtt 10 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/25 How to copy from one image to another in Photoshop CC.en.srt 10.7 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/25 How to copy from one image to another in Photoshop CC.en.vtt 10.3 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/26 How to crop images inside of text.en.srt 17.3 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/26 How to crop images inside of text.en.vtt 16.6 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/27 How to remove the background in Adobe Photoshop CC.en.srt 18.3 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/27 How to remove the background in Adobe Photoshop CC.en.vtt 17.6 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/28 Class Project - Quick Select Tool.en.srt 1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/28 Class Project - Quick Select Tool.en.vtt 1.1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/29 How to put text behind a person in Adobe Photoshop CC.en.srt 10.8 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/29 How to put text behind a person in Adobe Photoshop CC.en.vtt 10.4 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/31 Class project - Cut a person out & put them into another image in Photoshop.en.srt 15.9 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/31 Class project - Cut a person out & put them into another image in Photoshop.en.vtt 15.3 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/32 How to blend fade one image into another in Photoshop CC.en.srt 9.8 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/32 How to blend fade one image into another in Photoshop CC.en.vtt 9.3 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/34 How to select hair in Adobe Photoshop CC.en.srt 28.2 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/34 How to select hair in Adobe Photoshop CC.en.vtt 26.9 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/34 How to select hair in Adobe Photoshop CC.mp4 263.6 MB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/37 How to get text to interact with ink & plants in Photoshop CC.en.srt 21.9 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/37 How to get text to interact with ink & plants in Photoshop CC.en.vtt 21 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/42 How to create the Dotted Halftone Poster Effect in Photoshop.en.srt 11.3 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/42 How to create the Dotted Halftone Poster Effect in Photoshop.en.vtt 10.9 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/46 What is a smart object in Adobe Photoshop CC.en.srt 15.9 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/46 What is a smart object in Adobe Photoshop CC.en.vtt 15.3 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/47 How to bend a logo onto an image realistically in Photoshop.en.srt 13.3 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/47 How to bend a logo onto an image realistically in Photoshop.en.vtt 12.8 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/48 How to make a sky peeling like fabric revealing background in Photoshop.en.srt 5.1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/50 How to shrink body parts in Adobe Photoshop CC using liquify.en.srt 9.7 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/50 How to shrink body parts in Adobe Photoshop CC using liquify.en.vtt 9.4 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/51 How to create dripping paint text effect in Photoshop CC.en.srt 15.7 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/51 How to create dripping paint text effect in Photoshop CC.en.vtt 15.1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/53 How to remove people & text from a picture in Photoshop.en.srt 11.5 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/53 How to remove people & text from a picture in Photoshop.en.vtt 11.1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/58 Enhancing eyes in Adobe Photoshop CC.en.srt 11.4 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/58 Enhancing eyes in Adobe Photoshop CC.en.vtt 11 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/61 Using blending modes as color accents in Photoshop.en.srt 12.1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/61 Using blending modes as color accents in Photoshop.en.vtt 11.7 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/62 How to put images inside a bottle using Photoshop.en.srt 24.9 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/62 How to put images inside a bottle using Photoshop.en.vtt 23.8 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/64 How to create the spotify Duotone effect in adobe Photoshop.en.srt 9.2 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/64 How to create the spotify Duotone effect in adobe Photoshop.en.vtt 9 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/66 How to create the 3D glasses Anaglyph effect in Adobe Photoshop.en.srt 9.7 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/66 How to create the 3D glasses Anaglyph effect in Adobe Photoshop.en.vtt 9.3 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/68 How to create a vintage instagram Matte Photo in Photoshop.en.srt 15.5 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/68 How to create a vintage instagram Matte Photo in Photoshop.en.vtt 14.9 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/70 How to create the paper cut effect in Adobe Photoshop CC.en.srt 18 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/70 How to create the paper cut effect in Adobe Photoshop CC.en.vtt 17.3 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/72 How to use an Artboard in Adobe Photoshop CC.en.srt 33.2 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/72 How to use an Artboard in Adobe Photoshop CC.en.vtt 31.7 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/73 What is the difference between RGB and CMYK in Adobe Photoshop CC.en.srt 13.2 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/73 What is the difference between RGB and CMYK in Adobe Photoshop CC.en.vtt 12.7 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/74 How do you change the resolution to 300dpi in Photoshop CC.en.srt 17.7 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/74 How do you change the resolution to 300dpi in Photoshop CC.en.vtt 17 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/75 Basic introduction to using a wacom tablet with Photoshop.en.srt 19.6 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/75 Basic introduction to using a wacom tablet with Photoshop.en.vtt 18.8 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/76 How to create splatter paint effects in Adobe Photoshop CC.en.srt 14.1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/76 How to create splatter paint effects in Adobe Photoshop CC.en.vtt 13.5 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/78 How to create dripping paint ink effect in Photoshop.en.srt 11.5 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/78 How to create dripping paint ink effect in Photoshop.en.vtt 11.1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/80 How to create smoke with an image inside it using Photoshop CC.en.srt 9.1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/82 How to make a Long vector hard shadow in Photoshop.en.srt 8.9 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/83 How to cast a realistic shadow on the ground in Photoshop.en.srt 12.3 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/83 How to cast a realistic shadow on the ground in Photoshop.en.vtt 11.9 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/85 How to export images from Photoshop for print web & social media.en.srt 18.9 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/85 How to export images from Photoshop for print web & social media.en.vtt 18.1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/86 BONUS Software Updates.en.srt 56 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/86 BONUS Software Updates.en.vtt 53.5 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/86 BONUS Software Updates.mp4 447 MB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/87 Adobe Photoshop CC 2021 New Features & Updates part 1.en.srt 53.1 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/87 Adobe Photoshop CC 2021 New Features & Updates part 1.en.vtt 50.6 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/87 Adobe Photoshop CC 2021 New Features & Updates part 1.mp4 216.5 MB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/88 Adobe Photoshop CC 2021 New Features & Updates part 2.en.srt 47.6 KB
  • [TutsNode.com] - Adobe Photoshop CC - Essentials Training Course/88 Adobe Photoshop CC 2021 New Features & Updates part 2.en.vtt 45.4 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
868 MB11/28/2030
12.9 GB10/28/2120
2.8 GB11/18/2010
2.8 GB11/18/2010
8.5 GB09/23/1810
860 MB12/01/2001
9 GB08/18/1901
9 GB02/10/1901
9 GB12/17/1801
9 GB12/05/1801
8.5 GB11/21/1801
8.5 GB10/19/1801