Advanced Microsoft Excel Formulas & Functions Course 2021

What you’ll learn

  • What Are the Different Among RELATIVE, ABSOLUTE AND MIXED REFERENCE?
  • How To Use RELATIVE, ABSOLUTE AND MIXED REFERENCES?
  • How To Create The MULTIPLICATION TABLE By Using Mixed Reference?
  • How To Add The Zeros In Microsoft Excel?
  • How To Generate AUTOMATIC SERIAL NUMBERS In Microsoft Excel?
  • How To Use The CONVERT Function?
  • How To Use WORKDAY AND WORKDAYINTL Functions?
  • How To Use RAND Function?
  • How To Use RANDBETWEEN Function?
  • How To Use AUTOSUM Function?
  • How To Use VLOOKUP Function?
  • How To Use HLOOKUP Function?
  • How To Manage Stocks & Stores By Using Hlookup Function?
  • How To Use CHOOSE Function?
  • How To Use TRANSPOSE Function?
  • How To Use RANK Function?
  • How To Use COUNTBLANK Function?
  • How To Use INDEX AND MATCH Functions?
  • How To Convert Numbers To Words?
  • How To Create Data Entry Form In Excel?

Who this course is for:

  • Excel users both inexperienced and experienced who don’t feel confident about Microsoft Excel Advanced formulas and Functions
  • Anyone who uses Excel for work or personal needs such as Sales Manager, Students, Individual, Accountants ,Auditor, Financial Analyst, Information Clerk
  • Anyone who work with Excel for Entering data,Extract data, lists, formulas and functions
Note: 100% OFF Udemy coupon codes are valid for maximum 3 days only. Look for "ENROLL NOW" button at the end of the post.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Read more about Affiliate disclosure here.
Deal Score0

Udemy Popular Instructors: Rob Percival | Phil Ebiner | 365 Careers | Chris Haroun | Colt Steele | Jose Portilla | Kirill Eremenko | Maximilian Schwarzmüller | Ben Tristem | Daragh Walsh | Evan Kimbrell | Dr. Angela Yu | Laurence Svekis | Start-Tech Academy | Mike Wheeler | Joeel & Natalie Rivera | Stephane Maarek | Hadelin de Ponteves | Tim Buchalka | Scott Duffy | Valentin Despa | Mohsen Hassan | Jaysen Batchelor | Jason Dion | KodeKloud Training | Stephen Grider | Daniel Walter Scott | Rahul Shetty | Andrei Neagoie | in28Minutes Official | Mauricio Rubio | Leila Gharani | Chris Croft | Lawrence M. Miller | Steve Ballinger | Eshant Garg | Juan Gabriel Gomila Salas | Alexander Hagmann | CADCIM Technologies | Sandeep Kumar ­ | Neil Cummings | Denis Panjuta | Tarek Roshdy | Minerva Singh | Matthew Barnett | Siva Prasad | Dr Karen E Wells | Graham Nicholls | Kain Ramsay |

Courses by Top Universities and Institutions: Google Cloud | Stanford University | Deeplearning.ai | University of Michigan | University of Illinois | IBM | Johns Hopkins University | Northwestern University | University of Minnesota | HSE University | Duke Univercity | New York Institute of Finance | Rice University | University of Washington | Yale University |
Course Coupon Club
Logo