www.specialskills.in
Home
Recognitions AND CERTIFICATES
MICROSOFT
is learning ms excel important?
MS excel Courses
MS Excel Refund Policy
Disclaimer
Caution
Contact
Services
Tech solutions
Business solutions
Music/Hobby Solutions
Online Trainings
Video Marketing
Social Media Marketing
Fashion/Graphic Solutions
Services Content Pages
Purchase flow and Refund Policy
Disclaimer
Contact
Caution
More
Grapho Therapy
Forum
Articles
Lyrics
www.specialskills.in
Home
Recognitions AND CERTIFICATES
MICROSOFT
is learning ms excel important?
MS excel Courses
MS Excel Refund Policy
Disclaimer
Caution
Contact
Services
Tech solutions
Business solutions
Music/Hobby Solutions
Online Trainings
Video Marketing
Social Media Marketing
Fashion/Graphic Solutions
Services Content Pages
Purchase flow and Refund Policy
Disclaimer
Contact
Caution
More
Grapho Therapy
Forum
Articles
Lyrics
Home
Forum
List of important MS Excel tools for office work
List of important MS Excel tools for office work
Rajesh Pathak
Here is a list of some of the important and frequently used MS Excel tools in offices:
Control C for copy
Control V for paste
Format painter and double click format painter to copy formatting of one cell to other cell or cells
Font size, font colour, fonts, bold, italic, underline
Text alignment
Wrap text to bring your text in one cell
Number formatting to use dates, percentages, etc.
Conditional formatting
Control T to convert range table into Excel table
Auto sum to quickly add numbers in a row or column
Sorting and filtering
Pivot tables to summarize and analyze data
Charts
Slicer and timeline to filter data
Print area to select the area you want to print
Gridlines to appear or disappear from worksheet
Excel formulas
Name manager to use defined names in Excel formulas
Power query to mash up and analyze data
New comment to insert comment box in cell
Freeze panes to freeze rows or columns
Macros to record macros
Shortcut keys to speed up the work in Excel
Hyperlinking to link various cells or worksheets
Flash fill to quickly split or merge data
{"follow":"Follow","edit":"Edit","reply":"Comments","suggestedTopics":"Suggested Topics"}
+91-9971911018
-
Whats App
contact@specialskills.in