How to Add Comments in Excel 2016 | Knowledgecity.com

Check out the full course at knowledgecity.com/en/library/CMP1125/course/exc…. This handy little feature of Microsoft Excel 2016 allows you to add comments to any cell in your worksheet. It’s easy to provide extra information, make general notes and add reminders. Comments are hidden in the cell by a little red triangle. Microsoft Excel 2016 gives you the option to see comments when you hover, or you can choose the previous or next comment, or see all of them with Show All Comments. The Comments feature also allows you to change the size and color of your text in the Comments window.

Course Lessons

Welcome
Introduction
Overview
New Features and Navigation
Overview
New Features for 2016
Use and Customize the Quick Access Toolbar
Exploring the Backstage
Working with the Ribbon
Working with KeyTips
Using the Status Bar
Using the Formula bar
Using shortcut menus and the Mini toolbar
Using Excel Help
Getting Started with Excel
Overview
Creating new workbooks
Selecting Cells
Entering Text, Numbers, and Dates
Editing Data Part 1
Editing Data Part 2
Entering data with AutoFill
Finding and Replacing Data
Using Undo and Redo
Adding comments
Saving Workbooks
Formatting and Modifying Worksheets
Overview
Font styles and effects
Alignment and Wrap Text
Designing borders and backgrounds
Formatting numbers and dates
Working with dates and times
Format Painter
Using conditional formatting
Adjusting rows and columns
Insert, Delete, and Adjust Cells
Hiding and un-hiding rows and columns
Inserting and Deleting Worksheets
Copying and Moving Worksheets
Customizing Sheet Tabs
Hiding and un-hiding worksheets
Basic Formulas and Functions
Overview
What are Formulas and Functions?
Creating basic formulas
Copying a formula into adjacent cells
Relative, absolute, and mixed references
Calculating year-to-date totals
Creating a percentage-change formula
Using Functions
Other common functions
Using the Insert Function Tool
Basic Table Features
Overview
Sort and Filter Data Part 1
Sort and Filter Data Part 2
Creating and using tables
Adding Charts and Graphics
Overview
Creating a Chart
Enhancing a Chart
Modifying Chart Data
Changing Chart Types
Inserting shapes and other features
Working with chart elements
Formatting charts
Inserting Pictures
Creating in-cell charts with sparklines
Styles, Themes, and Views
Overview
Apply Styles and Themes
Create and Use Templates
Freezing and unfreezing panes
Splitting screens horizontally and vertically
Collapsing and expanding data views with outlining
Finalize, Print, and Save
Overview
Use Proofing and Research Tools
Exploring the Page Layout and View Tabs
Working with Layout and Page Setup
Changing View Options
Previewing and Modifying page breaks
Adding Headers and Footers
Previewing and Printing the Worksheet
Arranging Multiple Workbooks
Adding Hyperlinks
Saving Workbooks in Different Formats
E-Mailing a Workbook
Conclusion

knowledgecity.com | Online Employee Training Platform. KnowledgeCity offers 12,000+ online video tutorials in Business, Computer, Safety, Compliance, and Finance.

Subscribe to our YouTube Channel: youtube.com/user/knowledgeocity?sub_confirmatio…

Check our Blog: goo.gl/q47XKK

Connect with KnowledgeCity!
Twitter: goo.gl/wToC6s
Facebook: goo.gl/3eMEq9
LinkedIn: goo.gl/vg1aXt
Google+: goo.gl/Gjkffm