Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 AWS Certified Developer - Associate
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Virtual Reality
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile App Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Meditation Sound Therapy CBT Cognitive Behavioral Therapy
Entrepreneurship Fundamentals Business Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing YouTube Marketing Podcasting

Office ProductivityMicrosoftExcel Formulas and Functions

Excel Formulas and Functions: Make Basic & Advanced Formulas

Learn MS Excel Formulas and Functions. Create Basic and Advanced Excel Formulas. Make an Excel Template Project.
Rating: 4.4 out of 54.4 (401 ratings)
12,755 students
Created by Kawser Ahmed
Last updated 6/2016
English
English

What you'll learn

  • Learn Excel Formulas and Functions from Zero.
  • Learn how to build a professional level Excel Template using Excel functions.

Requirements

  • Microsoft Office Software Installed.

Description

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Excel formulas and functions are the heart of Microsoft Excel spreadsheet. They are essential to manipulating data and obtaining useful information from your Excel workbooks. 

Without Excel formulas and functions, Excel spreadsheet would simply be a fancy word-processing document. Welcome to my Excel Formulas and Functions course.

Let’s discuss now what you will learn from this course.

  1. Operators and Precedence of Operators: I will start from zero and if you don’t know about the operators and precedence of operators that Excel uses in its formulas, then it will be tough for you to decode complex Excel formulas. So I have covered them in very details.
  2. How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the Excel formulas using the Insert Function and Function Arguments dialog box.
  3. Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your finance related jobs. So this function is covered in details at the start of the course.
  4. Relative, Absolute and Mixed Cell References: You will work with these three concepts time to time when you will build excel formulas. So, they have got a good time in the course.
  5. Formulas with Tables: Understanding how formulas work with Excel tables is very important. I have used two lectures to cover Excel formulas with tables. In the second lecture, structured referencing with Excel tables has been discussed.
  6. Then you will learn how to handle circular references with Excel formulas, how named cells and ranges work with Excel formulas, and so on.
  7. Mathematical functions are very important in your daily work with finance or any kind of jobs. In this course, you will learn about SUM, AVERAGE, MAX, MIN, INT, MOD, ROUND, RAND, and RANDBETWEEN Excel functions. Counting related excel functions are also covered in this course.
  8. Then you will work with 3-D Referencing with Excel Formulas.
  9. In Advanced Excel formulas, you will learn: IF, IFERROR, DATE related functions, Text manipulating functions, and many more.
  10. Manipulating Text using Excel Functions: There is a section where you will learn how to manipulate text using Excel formulas and functions.
  11. Then you have worked with VLOOKUP, INDEX, and Array formulas.
  12. And at the end of the course, you will build a professional Excel template where you will learn how to make complex Excel formulas using Excel functions.
  13. Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life problems using Excel formulas and functions.

So, if you are interested to learn advanced Excel formulas and functions with a real life project, then this course is for you. Thanks for reading. Enjoy the course!

Who this course is for:

  • This course is meant for intermediate level Excel users who are familiar with the general concepts of Excel features.

Instructor

Kawser Ahmed
Founder ExcelDemy.com | Data Analyst
Kawser Ahmed
  • 4.3 Instructor Rating
  • 5,538 Reviews
  • 158,333 Students
  • 9 Courses

Love to see you here.

I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a full-time data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur.

I love to make courses in the combination of both theory and practice.

Monthly 100,000 Excel users visit my Excel blog ExcelDemy (follow the website link in the profile).

I love to learn and teach (teaching from my eighteen)!

Visit my blog.

You will find plenty of useful posts, articles, video tutorials, and important Excel resources.

What I love most is: add some value to people around me, believe me.

Here are some of my working areas:

1. Corporate Budgeting, Planning & Forecasting

2. Mission-critical financial processes

3. Month-end close processes

4. Big Data Analysis using Excel

5. Company Reports (Sales, Marketing, Administrative)

6. Large Projects using Excel VBA

7. Dashboard Design using Excel

8. And Basic Accounting


I am always around you to help and support.

Just contact me.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.