PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

PRACTICE LOGO

EXCEL TUTORIAL- For new learners

DON’T HAVE EXCEL???

CLICK HERE...

DON’T HAVE EXCEL???

Get software before starting this excel tutorial.

Primarily, MS EXCEL and Open Office Calc are popular for spreadsheets.(Softwares like Excel).

MS EXCEL is a paid software whereas Open Office is a free software. The links for both are given below.

LINK TO GET MICROSOFT OFFICE

https://www.microsoft.com/en-in/store/b/home

LINK TO GET OPEN OFFICE

https://www.openoffice.org/download/index.html

EXCEL TUTORIALS

  1. What is Microsoft Excel? How to use formula in Microsoft Excel?
  2. How to use FORMAT PAINTER in EXCEL?
  3. How to change the font of text, set text size,align the text to the right or left, align the text to the top , middle or bottom.
  4. How to WRAP TEXT AND MERGE in excel?
  5. How to INCREASE OR DECREASE DECIMAL PLACES in excel?
  6. How to use CONDITIONAL FORMATTING in excel?
  7. How to INSERT SHEETS in excel?
  8. How to DELETE SHEETS in excel?
  9. How to ADJUST ROW HEIGHT in excel?
  10. How to ADJUST COLUMN WIDTH in excel?
  11. How to INSERT TABLE in excel?
  12. How to INSERT PICTURES, CLIPARTS AND SHAPES  in excel?
  13. How to insert HYPERLINK in excel?
  14. How to insert TEXTBOX in excel?
  15. How to insert HEADER AND FOOTER in excel?
  16. How to insert WORD ART, OBJECT and SYMBOL in excel?
  17. How to change THEME in excel?
  18. How to set MARGIN, ORIENTATION AND SIZE in excel?
  19. How to set PRINT AREA in excel?
  20. How to insert PAGE BREAKS and BACKGROUND in excel?
  21. How to print TITLE in Excel?
  22. How to hide GRIDLINES, COLUMN NAMES AND ROW NUMBERS in excel?
  23. How to Arrange, Align and Rotate OBJECTS in excel?
  24. How to get EXTERNAL DATA in excel?
  25. How to FILTER DATA in excel?
  26. How to use ADVANCED FILTER in Excel?
  27. How to convert TEXT TO COLUMN in excel?
  28. How to REMOVE DUPLICATES in excel?
  29. What is DATA VALIDATION in excel?
  30. How to consolidate data in excel?
  31. How to do WHAT-IF analysis in excel?
  32. How to GROUP AND UNGROUP in excel?
  33. How to do SUBTOTAL in excel?
  34. How to apply SPELL CHECK in excel?
  35. How to use RESEARCH, THESAURUS AND TRANSLATE in excel?
  36. How to PROTECT and UNPROTECT sheets with password in excel?
  37. How to set PAGE LAYOUT in excel?
  38. How to use PAGE BREAK PREVIEW in excel?
  39. How to set CUSTOM VIEW AND FULL SCREEN in excel?
  40. How to ZOOM  in excel?
  41. How to show or hide GRIDLINES, FORMULA BAR OR HEADINGS in excel?
  42. How to FREEZE PANES in excel?
  43. How to create and arrange WINDOWS in excel?
  44. How to use MACROS in excel?
  45. How to use NAME MANAGER and define names in excel?
  46. How to TROUBLESHOOT  a formula in excel?
  47. How to use PIVOT TABLES in excel?
  48. Frequently occurring problems in PIVOT TABLES?
  49. How to SORT DATA in excel?
  50. How to make CHARTS in excel?
  51. How to create COLUMN CHARTS in excel?
  52. How to create PIE CHARTS in excel?
  53. How to create MAP CHART in excel?
  54. How to create 3D MAP CHART in excel?
  55. How to create WATERFALL CHART in excel?
  56. How to create PARETO CHART in excel?
  57. How to create GANTT CHART in excel?
  58. How to create a DOUGHNUT CHART in excel?
  59. How to create a FUNNEL CHART in excel?
  60. How to create XY SCATTER CHART in excel?
  61. How to create SUNBURST CHART in excel?
  62. How to create TREEMAP CHART in excel?
  63. How to create BOX AND WHISKER CHART in excel?
  64. How to create HISTOGRAM CHART in excel?
  65. How to use PIVOT CHARTS in excel?
  66. How to create PIVOT TABLE quickly?
  67. How to use SLICER in EXCEL?
  68. How to use FLASH FILL in EXCEL?
  69. How to change NUMBER FORMAT of Cells in Excel?
  70. How to create SPARKLINES in Excel?
  71. How to create RADAR CHARTS in Excel?

EXCEL TUTORIAL- For advanced learners

The posts cover different formulas and functions used in Excel.

OTHER WAYS TO REACH THIS ARTICLE

  • MS EXCEL TUTORIAL, LEARN EXCEL EASILY, LEARN COMPLETE EXCEL, EXCEL LEARNING, WHAT ARE THE FUNCTIONS IN EXCEL, LEARN EXCEL 100%, BEST EXCEL TUTORIAL, EXAMPLE OF ALL EXCEL FUNCTIONS.
YOU MAY LIKE

LEARN

  • EXCEL
  • HTML
  • JAVASCRIPT
  • MORE TO COME…

Encourage us by following at …

Facebook
Twitter
Pinterest

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]