Get 100%OFF Coupon For Important Functions with Microsoft Excel Course


Course Description:

Microsoft Excel is without doubt one of the strongest and broadly used spreadsheet packages on this planet

It has the facility to carry out calculations and duties to simplify our work. Whether or not you’re utilizing Excel personally, as a scholar or at work, the rationale for utilizing it’s most likely to do some kind of calculation or carry out a process of some kind.

Functions are instruments present in Microsoft Excel to make this course of simpler for us.

For those who have been to individually add the values in 2 cells collectively, a easy method telling Excel so as to add Cell A to Cell B (Cell A + Cell B) would work nicely… However what if you must add the values of 100 or 1000 or extra cells collectively??? Certainly you possibly can’t individually kind that right into a method, and subsequently Excel has capabilities, in a case like this the SUM perform, to make this a quite simple operation.

This is only one instance of how capabilities are utilized in Microsoft Excel. Excel has almost 500 built-in capabilities, and extra are being added. That’s many operations simplified, which may have taken fairly a while to carry out in any other case.

Fortunately, you don’t must know each perform to have the ability to use Excel, so on this course I’ll educate you a few of the hottest and highly effective perform that are simply should know capabilities, but in addition some capabilities that aren’t well-known, however you is likely to be shocked at how they might help you…

I’ll clarify methods to use every perform step-by-step and clarify every of the factors required for every particular perform.

This course include 9 sections which embody 38 video classes that are principally 4 – 10 min lengthy, until the perform wants some extra explaining.

Course format as follows:

Part 1: Introduction

  • Welcome
  • Introduction to capabilities in Excel

Part 2: Date & Time Functions

  • NOW and TODAY
  • DAY, MONTH, YEAR and DATE
  • HOUR, MINUTE, SECOND and TIME
  • NETWORKDAYS and WORKDAY
  • WEEKDAY and WEEKNUM

Part 3: Engineering Functions

  • CONVERT

Part 4: Logical and Data Functions

  • ISBLANK, ISERROR, ISNUMBER, ISTEXT, ISBLANK, ISFORMULA, ISODD, ISEVEN
  • AND, OR and NOT
  • IF and IFS
  • IFERROR

Part 5: Lookup and Reference Functions

  • VLOOKUP and HLOOKUP
  • INDEX and MATCH
  • ROW, COLUMN, ROWS and COLUMNS
  • HYPERLINK
  • TRANSPOSE

Part 6: Statistical Functions

  • COUNT, COUNTA and COUNTBLANK
  • COUNTIF and COUNTIFS
  • SUM, SUMIF and SUMIFS
  • MIN, MAX, LARGE and SMALL
  • MINIFS and MAXIFS
  • MODE
  • RANK

Part 7: Mathematical Functions

  • RAND and RANDBETWEEN
  • ROUND, ROUNDUP, ROUNDDOWN and INT
  • MROUND, CEILING.MATH and FLOOR.MATH
  • MOD
  • SUBTOTAL and AGGRETATE

Part 8: Textual content Functions

  • LEFT, RIGHT, MID and LEN
  • FIND and SEARCH
  • REPLACE and SUBSTITUTE
  • TRIM and CLEAN
  • CONCAT and TEXTJOIN
  • UPPER, LOWER and PROPER
  • TEXT

Anybody with fundamental Excel information can simply be taught all these capabilities by taking this course.

You probably have nonetheless by no means used Excel earlier than, please ensure to take a look at my Microsoft Excel for Full Newbies course, to be taught the fundamentals and get began.

You’ll obtain a certificates on completion of this course.

Good luck, and please give me a score and overview when you loved this course.

Who this course is for:

  • Anybody eager to be taught extra about Excel capabilities
  • Anybody who needs to enhance their Excel information


Udemy Coupon

Leave a comment

Your email address will not be published. Required fields are marked *