Microsoft Excel Logic Theory and If Functions (Intermediate)
Microsoft Excel Logic Theory and If Functions (Intermediate), available at $49.99, has an average rating of 4.6, with 24 lectures, 1 quizzes, based on 412 reviews, and has 17534 subscribers.
You will learn about Logic function theory "If" function variations "And" funtion "Or" function Absolute Referencing Nested Logic Functions "If" function combinations Number and Text Concatenation Error Handling This course is ideal for individuals who are Intermediate skill level on Excel or If you're an expert and want to freshen up on your skills, feel free to sign up or People from any country or People of all ages It is particularly useful for Intermediate skill level on Excel or If you're an expert and want to freshen up on your skills, feel free to sign up or People from any country or People of all ages.
Enroll now: Microsoft Excel Logic Theory and If Functions (Intermediate)
Summary
Title: Microsoft Excel Logic Theory and If Functions (Intermediate)
Price: $49.99
Average Rating: 4.6
Number of Lectures: 24
Number of Quizzes: 1
Number of Published Lectures: 20
Number of Published Quizzes: 1
Number of Curriculum Items: 25
Number of Published Curriculum Objects: 21
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will Learn
- Logic function theory
- "If" function variations
- "And" funtion
- "Or" function
- Absolute Referencing
- Nested Logic Functions
- "If" function combinations
- Number and Text Concatenation
- Error Handling
Who Should Attend
- Intermediate skill level on Excel
- If you're an expert and want to freshen up on your skills, feel free to sign up
- People from any country
- People of all ages
Target Audiences
- Intermediate skill level on Excel
- If you're an expert and want to freshen up on your skills, feel free to sign up
- People from any country
- People of all ages
WHAT’S YOUR STORY?
- Are you a business professional needing to up-skill?
- Are you struggling to get a pay-rise and/or promotion?
- Are you a recent graduate with an empty looking resume and no job experience?
- Have you recently been laid off, fired or had a contract end?
If you answered ‘yes’ to any of the above then having “Expert Microsoft Office Skills” will get you closer to your goal of either landing your first job, a new job or progressing further in your current role. Here’s why.
The job market has never been more volatile. Statistically, people are changing jobs more often now than they ever have before and that also means people are also losing jobs to newcomers who are far more skilled. So if you’re not up-skilling, you’re falling behind. It’s scary I know. I’ve experienced this myself.
A study released by Microsoft and the IDC showed that among 14.6 million job postings, proficiency in Microsoft Office was ranked 2nd as the most desired skills by employers leading up to 2020. Microsoft Office proficiency ranked higher than Project Management skills, Sales Experience, Time Management, Analytical Skills, Interpersonal Skills and Work Ethics.
This is because we live in the digital age, meaning employers are looking for proficient data handlers who process data faster, are more data-organised and can communicate effectively via digital channels. These are skills everyone should have no matter the discipline because they are transferable skills. It makes you more adaptable and more valuable in the long-term. This brings us back to Microsoft Office. It is the oldest, most well-known, most affordable and most trusted data management tool available and hence everyone uses it. So to be noticed and taken seriously in your job or job application, proficiency in these programs is compulsory.
ONLINE TRAINING AND THE MOST COMMON PROBLEMS
One of the most common problems with online learning content is that there is so much of it now and it’s difficult to know where to start or who to turn to. Many go the YouTube route and piece together videos from hundreds of tutorials from hundreds of tutors hoping to become an expert at the end of it all. This simply won’t happen and will just waste your time.
Many take the route you’re about to take, they decide to enroll in an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable for university students, recent graduates, the unemployed or those looking for a career change. That is the reason why I have decided to keep this course as low as possible even though I’m offering substantially more content than most of my competitors here on Udemy.
COURSE DELIVERY STYLE
I have been using Microsoft Office for over 20 years. I know the in’s and out’s and the simplest ways of doing things. My delivery philosophy is simple, if I can’t get a 6 year old to follow along and understand, than I’m not teaching correctly. I hate complicated language and so do you. Nobody likes trainers who focus on impressing rather than teaching and giving value to students. That is also why my lecture videos are as short as can be and divided into small sections for easy consumption. So you won’t get unnecessary chit chat or nonsense. I also assume that all my students are near-sighted and as such, I use a special software tool that allows me to draw on the screen to show exactly what I’m about to press as well as zoom in on small area’s so you don’t miss a thing.
WHAT YOU’LL LEARN IN THIS COURSE
To advance to the next stage of your Microsoft Excel development, you MUST KNOW how to use Logic Functions such as the “If” functions. It is a fundamental tool in the Excel user arsenal which allows you to manipulate data in a very unique and efficient way. Logic functions give you the ability to utilize Excel as an additional brain. You can set criteria which Excel must follow and will in turn make adjustments and calculations for you based on the criteria you set. This means, that for large or complex sets of data, especially recurring data, one formula can organise/calculate different types of information in one go.
ABOUT ME
- Member of the Udemy Council
- Co-Founded Paperclip Learning which teaches Microsoft Office
- Over 60,000 students
- Over 130,000 enrollments
- Over 5,000 Positive Reviews
- Over 20 courses on Udemy
Teaching is my passion and my creative outlet. I have been using the Microsoft Office package since I was a child and have been using it consistently throughout my life. My teaching experiences span from teaching primary school students, high school students, university graduates and business professionals. Professionally, I am trained in Aerospace Engineering, Database Design and Business Analytics.
TESTIMONIALS
Yu Hui Jun Yu –The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the ‘mini-lesson’ format. Fast and efficient. The instructor’s direction is very detailed and easy to understand. I can immediately start using this program. Thanks!
Narayanan Krishnamoorthy – Perfect and to the point…the instructor doesn’t waste time and gets to the point quickly!!
Lala Darchinova –I’ve been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing.
Spencer Berkman –Extremely knowledgeable and clear on instructions.
E Frank –Simple to learn techniques and instructor made it all really easy. Thank you!
Parth Gandhi –I learned techniques in a very short time…no need to google and waste time finding the perfect approach.
Course Curriculum
Chapter 1: Welcome and Introduction
Lecture 1: Introduction – What are Logic Functions?
Lecture 2: Downloadable Files
Chapter 2: "If" Functions
Lecture 1: Case Study Explained
Lecture 2: Logic Functions Explained
Lecture 3: "If" Function Builder File
Lecture 4: Example 1: Basic Formula Creation
Lecture 5: Example 2: "If" function cell linking
Lecture 6: Example 3: Input Variations/Alterations
Lecture 7: Example 4: Text Outputs
Lecture 8: Example 5: Handling Blanks
Chapter 3: And/Or Functions
Lecture 1: "And" function
Lecture 2: "Or" function and the Fill Handle
Chapter 4: Absolute Referencing
Lecture 1: Absolute Referencing Theory
Lecture 2: Application of Absolute Referencing with Logic Functions
Chapter 5: Bonus Features
Lecture 1: Nested Logic Functions – Adding If Functions
Lecture 2: Nested Logic Functions – If within an If
Lecture 3: "If" Function variations with "Greater Than" and "Less Than"
Lecture 4: Number and Text Concatenation
Lecture 5: Error Handling – "Iferror" function
Chapter 6: Congratulations
Lecture 1: Congratulations
Instructors
-
Jed Guinto
~500k Enrolments, ~200k Students, ~15k Reviews
Rating Distribution
- 1 stars: 4 votes
- 2 stars: 9 votes
- 3 stars: 36 votes
- 4 stars: 118 votes
- 5 stars: 245 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024