Excel Formulas Training Series - Video Course from Beginner to Advanced

Onur YILMAZ, Founder at Someka Excel Solutions

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
30 Videos (2h 44m)
    • Lesson 1 Video Four Operators Excel Formulas Training

      1:01
    • Lesson 2 Video SUM Excel Formulas Training

      1:16
    • Lesson 3 Video COUNT Excel Formulas Training

      1:35
    • Lesson 4 Video AVERAGE Excel Formulas Training

      2:11
    • Lesson 5 Video MAX and MIN Excel Formulas Training

      2:55
    • Lesson 6 Video Date Functions Excel Formulas Training

      3:25
    • Lesson 7 Video LEN Excel Formulas Training

      2:23
    • Lesson 8 Video COUNTA Excel Formulas Training

      2:27
    • Lesson 9 Video ROUND Excel Formulas Training

      3:14
    • Lesson 10 Video SUMPRODUCT Excel Formulas Training

      4:46
    • Lesson 11 Video VLOOKUP Excel Formulas Training

      5:22
    • Lesson 12 Video IF Function Excel Formulas Training

      5:02
    • Lesson 13 Video COUNTIF Excel Formulas Training

      2:49
    • Lesson 14 Video SUMIF Excel Formulas Training

      4:41
    • Lesson 15 Video IS Functions Excel Formulas Training

      6:08
    • Lesson 16 Video CONCATENATE Excel Formulas Training

      4:57
    • Lesson 17 Video HLOOKUP Excel Formulas Training

      6:57
    • Lesson 18 Video RIGHT and LEFT Excel Formulas Training

      4:21
    • Lesson 19 Video RAND and RANDBETWEEN Excel Formulas Training

      6:52
    • Lesson 20 Video IFERROR Excel Formulas Training

      6:54
    • Lesson 21 Video VLOOKUP ADVANCED Excel Formulas Training

      5:30
    • Lesson 22 Video IF AND Excel Formulas Training

      8:07
    • Lesson 23 Video IF OR Excel Formulas Training

      7:54
    • Lesson 24 Video Nested IFs Excel Formulas Training

      8:07
    • Lesson 25 Video MATCH Excel Formulas Training

      7:11
    • Lesson 26 Video INDEX Excel Formulas Training

      9:54
    • Lesson 27 Video MID Excel Formulas Training

      13:15
    • Lesson 28 Video OFFSET Excel Formulas Training

      11:49
    • Lesson 29 Video INDIRECT Excel Formulas Training

      4:55
    • Lesson 30 Video Array Formulas Excel Formulas Training

      7:34

About This Class

1af4712a

You should be using Excel for business and personal purposes, aren’t you? Actually, the question should be “Do you benefit from all Excel features?”

The major feature that Excel provides us is Excel Formulas & Functions. Do not ever forget that if you start repeating the same action in Excel, there should be an Excel formula designed to solve your specific issue. We have prepared Excel Formulas Training Kits for you to check your Excel Formulas knowledge, improve your skills with hands-on experience and to feel more comfortable with Excel. Within these training kits, you will find yourself both learning and practicing Excel Formulas at the same time.

This video series are prepared to support the hands-on training workbook. There are 30 lessons going from beginner to advanced with several examples for each of them.

(Download training workbooks here: https://www.someka.net/excel-templates/excel-training/)

Lessons are as follows:

f4f25ad4

You can download the training workbooks here: https://www.someka.net/excel-templates/excel-training/

24

Students

--

Projects

0

Reviews (0)

Onur YILMAZ

Founder at Someka Excel Solutions

I am an Excel and Visual Basic Expert with over 10 years of experience on both corporate and freelance work life. I've been awarded as 2016 Excel Champion of Turkey at global championship organized by Microsoft. Also, I became Preferred Freelancer on thanks to solid results achieved in the previous projects.

With Engineering background and Business Analysis & Finance experience at international companies, I work on:

Data Analysis Excel Calculators & Simulations Automate recurring j...

See full profile