Advance MS Excel Training Course

Sarwar Ahmed, Apnaypages

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
16 Videos (1h 26m)
    • You will Learn in This courese

      2:26
    • How to create in Excel VBA From VBA visual basic application

      4:26
    • Create from table in excel using VBA

      5:07
    • How to add VB code in Excel user form

      7:32
    • Excel code

      0:21
    • Make maintinance file

      6:03
    • How to use count if and count a

      3:57
    • How to use countifs for free

      8:32
    • EXCEL DASHBOARD EASY STEPS

      11:47
    • How to give access in excel to multiple user

      1:38
    • How to create a page break in excle sheet

      3:15
    • Conditional formatting and data vilidation

      9:06
    • Chart In Excel

      4:43
    • Pivot table with chart

      6:18
    • Vlookup

      6:52
    • Develper option in excel

      3:47

About This Class

Formulas make Excel smart. With out them, Excel is just a data keeping tool. But by using formulas, you can crunch data, analyze it and get answers to most complex questions. While anyone can use a simple SUM or IF formula, an advanced user of it would be able to seamlessly write VLOOKUP,PIVOT TABLE, PIVOT CHART LOOKUP,CONDITIONAL FORMATTING,COUNT,COUNTIF,COUNTIFS, DEVELOPER OPTION  formulas. Apart from knowing the formulas, advanced Excel users know how to debug them, audit them and how to use which formula for which occasion.

173581d2

30

Students

--

Projects

0

Reviews (0)

Sarwar Ahmed

Apnaypages

Sarwar Ahmed is web developer, online marketer,SEO expert, Video tutorial's working for last 3 years on internet managing a successful websites. You can contact him via Email or on Facebook.

See full profile