Jump to content

Excel - Logical and Text Functions


Recommended Posts

e79cd092890d169416c07218934efe4c.jpeg
Published 06/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 20 lectures (1h 18m) | Size: 650.3 MB
Excel in learning Excel Logical and Text Functions

What you'll learn
What Logical functions are an how to use them to get the information you require.
What Text functions are and how they make finding information more efficient.
We will look at some Information functions and see how using them along with other functions can produce amazing results.
How nested functions are put together, understand the language used to get the end results and how to calculate within the function.
The Data Validation tool and how that makes presenting your functions and worksheets much more professional for the user.
Various shortcuts which will make your use of the program much more smooth.
Requirements
Previous exposure to personal computers and desktop applications is needed.
A computer with Office 365 or Office 2021/2019/2016 is required for this course.
Description
This course will cover the most popular Logical and Text Functions. You will also learn the language Excel uses to better understand how to assemble the function. Additional tools will be provided to help you engage with the program and make things happen more quickly and more efficiently.
Additional shortcuts are provided to aid you in producing a more efficient product more quickly; Ctrl+Shift+↓ to select a large amount of information and Ctrl+Backspace to return you to the top of the page while in a function, F2 then Ctrl+Enter to copy a function down in a table without including the formatting, high-lighting columns while in a function, the fx Insert Function tool to aid in understanding how to enter a function you are not familiar with to avoid making errors, the Format as Table tool, how to use the F9 button to show the result of an argument in a nested function, how the clipboard works, and the Paste Values tool.
We will be covering the following functions
· AVERAGEIFS
· CLEAN
· CONCAT
· COUNTIFS
· FIND
· IF
· IFAND
· IFERROR
· IFOR
· IFS
· ISBLANK
· ISERR
· ISERROR
· ISNA
· ISNUMBER
· ISTEXT
· LEFT
· LEN
· LOWER
· MAXIFS
· MID
· MINIFS
· NOT
· OR
· PROPER
· RIGHT
· SUBSTITUTE
· SUMIFS
· TEXTJOIN
· TRIM
· UPER
· VALUE
· XOR
Upon successful completion of this course, you will be able to perform the following logical and text associated tasks in Microsoft Excel.
You will
· Demonstrate skills and knowledge of Logical and Text functions
· Demonstrate skills in using the keyboard shortcuts provided in the lectures
· Demonstrate skills in using the Data Validation tool
· Demonstrate skills in nesting functions and how to get to the final product using them
· Demonstrate skills in evaluating information while in a function
· Demonstrate skills in manipulating large amounts of information in a function
· Understand how to use nested functions and which function you can use together effectively
This course is presented for Beginning to Intermediate level students. The length of the class is short enough to keep your attention but long enough to give you as much information as possible for your knowledge level.
Enough about that - let's get started!
Who this course is for
Excel users who need to know how to manipulate information in Excel in a professional manner.
Students who need to become more familiar with this part of the program to produce better documents/spreadsheets and become more knowledgeable in the program..
This course is presented on a beginning/intermediate level. If you are getting started or need to improve upon your Excel skills, this course provides what you need.
Those in the corporate world who need to know how to manipulate information in Excel more professionally, or require a refreshing of their Excel knowledge pool.
Homepage
https://www.udemy.com/course/excel-logical-and-text-functions/





Download ( Rapidgator )
https://rapidgator.net/file/a3f3180c83e43fdd10681cdec8c39578/uimtu.Excel..Logical.and.Text.Functions.rar.html
Download ( NitroFlare )
https://nitro.download/view/875082E1B6BA7E0/uimtu.Excel..Logical.and.Text.Functions.rar
[b]Download (Uploadgig)[/b]
https://uploadgig.com/file/download/7bae0f093b5ae7e1/uimtu.Excel..Logical.and.Text.Functions.rar

Links are Interchangeable - No Password - Single Extraction
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...