Microsoft Excel Formula Design for Beginners (Udemy.com)
Master how to create formula's from the ground up! You'll learn arithmetic, nested functions and automated formula's!
Created by: Jed Guinto
Produced in 2019
What you will learn
- Manual Calculations
- Addition, Subtraction, Multiplication and Division
- Decimal Place Setting
- Nested Formula's
- Basic Logic Functions (True and False)
- Cell Linking
- Formula Tracing
- Show Formula's
- AutoSum Functions - Sum, Average, Count, Max and Min
- Text and Formula Concatenation
Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 92 / 100
Course Description
WHATS YOUR STORY?
Are you a business professional needingto up-skill?
Are you struggling to geta 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 ExpertMicrosoft 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 youre not up-skilling, youre falling behind. Its scary I know. Ive 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 2ndas the most desired skills by employers leading up to 2021. 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 handlerswho process data faster, aremore data-organisedand cancommunicate effectively viadigital channels. Theseare 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 its 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 wont happen and will just waste your time.
Many take the route youre about to take, they decide to enrollin an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable foruniversity 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 Im offering substantiallymore content than most ofmy competitors here on Udemy.
COURSE DELIVERY STYLE
I have been using Microsoft Office for over 20 years. I know the ins and outs and the simplest ways of doing things. My delivery philosophy is simple, if I cant get a 6 year old to follow along and understand, than Im 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 wont 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 Im about to press as well as zoom in on small areas so you dont miss a thing.
WHAT YOULL LEARN IN THIS COURSE
The proper use and understanding of formula's in Microsoft Excel is essential in mastering the full program. It is a foundation skill that should not be ignored!
I'll teach you from the ground up how to construct and perform manual calculations, nested formula's, logic based functions, cell linkages, autosum functions and text/number concatenation.
Along with these functions I'll also cover additional techniques such as decimal place setting and formula expansion.
ABOUT ME
Member of the Udemy CouncilCo-Founded Paperclip Learning which teaches Microsoft OfficeOver 60,000 studentsOver 130,000 enrollmentsOver 5,000 Positive ReviewsOver 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 doesnt 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 approachWho this course is for:
You should have basic knowledge of Excel; navigation, data inputting, formatting, etcIf youre intermediate or expert and want to freshen up on the fundamentals, no problem, come on in!!
People from any countryPeople of all ages
Are you a business professional needingto up-skill?
Are you struggling to geta 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 ExpertMicrosoft 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 youre not up-skilling, youre falling behind. Its scary I know. Ive 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 2ndas the most desired skills by employers leading up to 2021. 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 handlerswho process data faster, aremore data-organisedand cancommunicate effectively viadigital channels. Theseare 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 its 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 wont happen and will just waste your time.
Many take the route youre about to take, they decide to enrollin an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable foruniversity 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 Im offering substantiallymore content than most ofmy competitors here on Udemy.
COURSE DELIVERY STYLE
I have been using Microsoft Office for over 20 years. I know the ins and outs and the simplest ways of doing things. My delivery philosophy is simple, if I cant get a 6 year old to follow along and understand, than Im 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 wont 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 Im about to press as well as zoom in on small areas so you dont miss a thing.
WHAT YOULL LEARN IN THIS COURSE
The proper use and understanding of formula's in Microsoft Excel is essential in mastering the full program. It is a foundation skill that should not be ignored!
I'll teach you from the ground up how to construct and perform manual calculations, nested formula's, logic based functions, cell linkages, autosum functions and text/number concatenation.
Along with these functions I'll also cover additional techniques such as decimal place setting and formula expansion.
ABOUT ME
Member of the Udemy CouncilCo-Founded Paperclip Learning which teaches Microsoft OfficeOver 60,000 studentsOver 130,000 enrollmentsOver 5,000 Positive ReviewsOver 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 doesnt 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 approachWho this course is for:
You should have basic knowledge of Excel; navigation, data inputting, formatting, etcIf youre intermediate or expert and want to freshen up on the fundamentals, no problem, come on in!!
People from any countryPeople of all ages
Instructor Details
- 4.6 Rating
205 Reviews
Jed Guinto
WHAT UDEMY HAS SAID ABOUT MY COURSES:
'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust'
PC MAG:
'Jed Guinto is something of an Udemy wunderkind. 'There are all-stars, such as Mr. Guinto, who do well by any metric'
WHAT MY STUDENTS SAY ABOUT ME:
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 doesnt 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.
BIOGRAPHY:
Jed Guinto has an academic backgro
More courses by Jed Guinto
Beginners Guide to Microsoft Excel Pivot Tables (2019)
4.6 (311 Reviews)
Provider: Udemy
Time: 33 mins on-demand videoh
$11.99
More excel courses
Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (2021)
4.9 (216 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Visually Stunning Microsoft Excel Dynamic Dashboard Course (2021)
4.9 (193 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Microsoft Excel Complete Excel Guide (Excel 2007 2021) (2021)
4.9 (62 Reviews)
- Provider: Udemy
- Time: 21h
$11.99
Reviews
- Video Duration:
35 mins on-demand videoh - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2019 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
