Learn MS Office with Tally ERP

เรียนรู้ MS Office และ Tally ด้วยวิดีโอเพื่อการศึกษา

Tally Software is mainly used for financial statements, vouchers and taxation in many industries worldwide and has specialised packages for retail businesses. More advanced capabilities are found in its Enterprise resource planning package(ERP). TallyPrime has advanced integration capabilities in the form of Application programming interfaces to make the software extensible. Tally interacts with Software application using XML, ODBC and DLL technologies. So it is quite evident that Tally is the most demanding ERP software available in the market. So the job opportunity is huge in this particular field. Even though anyone can do this program but this must for the Commerce background students. Here you would be learning this software from the Experts with complete practical exposure.

Master the Ins and Outs of Microsoft Office and Boost Your Productivity. Having Internet connection is must. The training is absolutely free. The course content is:

MS Word:

1 Ms Word Introduction

2 Ms Word Font Formatting

3 Paragraph Options

4 Bullets And Numbering

5 Sorting Option

6 Styles In Word - Heading Pattern

7 Page , Cover Page, Page Break

8 Creating Table In Word

9 Pictures In Ms Word

10 Shapes In Ms Word

11 Smartart In Ms Word

12 Chart And Screenshot

13 Bookmark And Cross Reference

14 Hyperlink In Word

15 Header And Footer And Page No

16 Text Box, Wordart, Drop Cap And Symbols

17 Quick Parts In Ms Word

18 Print Related Option

19 Watermark In Ms Word

20 Page Color And Page Border

21 Table Of Content

22 Biblography And Citation

23 Caption In Ms Word

24 Footnate And Endnote

25 Mark Entry In Ms Word

26 Mail Merge

27 Language And Proof

28 Track Changes In Word

MS Excel:

1 Excel Structure

2 Cell Properties

3 Autofill Val And Text

4 Autofill Date

5 Autofill Adv Tools

6 Cell Reference

7 Operators Based Equation

8 Math Function

9 Advance Math Function

10 Advance Math Function 2

11 Using Of Wild Card In Math Function

12 Text To Column

13 Workbook Protect

14 Protect Sheet

15 Hide Formulas And Unlocked Cell

16 Protect File With Password

17 Share Book

18 Print Option In Excel - Part 1

19 Print Option In Excel - Part 2

20 Pivot Table - Intro

21 Pivot Table - Manage Field Area

22 Pivot Table - Value Field, Report And More

23 Pivot Table - Slicer And Dublicate Pivot

24 Pivot Table - Group To Mange Date And Values

25 Pivot Table - Insert Calculated Field

26 Chart Preperation

27 Chart Preperation - Advance

28 Chart Preperation - Customize

29 If Function - Logical Test

30 If Function - With Equation And Task

31 If Function - Nested If

32 If Function - Advance

33 If Function - Adv 2

34 And , Or Function

35 And, Or, If Nested

36 And, Or Advance

37 Vlookup Function

38 Vlookup With Iferror

39 Vlookup Nesting With If

40 Hlookup

41 Match

42 Index And Match Nested

43 Vlookup Array

44 Vlookup Col Trick

45 Vlookup True

46 Advance Vlookup

47 Conditional Formatting

48 Conditional Formatting - Types Of Rules

49 Conditional Formatting - Mange Rules

50 Conditional Formatting - New Rules 1

51 Conditional Formatting - New Rules 2

52 Data Validation

53 Data Validation - Input Message And Error Alert

Powerpoint:

1 Intro - Layout And Section

2 Formatting And Manage Video

3 Text Box, Header And Footer

4 Slide Show Options

5 Design In Powerpoint

6 Transition Effect In Powerpoint

7 Animation In Powerpoint

Access:

1 Access Intro

2 Create Table In Ms Access

3 How To Import And Export In Access

4 Create Form From Table

5 Create Blank Form In Access

6 Creating Report In Access

7 Query In Access

*** This is not a Microsoft Application. This is just an Excel Course

*** This is not an MS Excel Application, this is just a training app