Check out the full course at www.knowledgecity.com/en/libr.... Sorting information in Excel 2016 is as easy as clicking on a cell. Learn how to sort from A to Z or from the smallest to largest number. Reversing the order is just as simple. Custom sorting provides a sorting hierarchy to allow you to sort multiple categories at the same time.
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
www.knowledgecity.com | Online Employee Training Platform. KnowledgeCity offers 12,000+ online video tutorials in Business, Computer, Safety, Compliance, and Finance.
Subscribe to our RU-vid Channel: ru-vid.com...
Check our Blog: www.knowledgecity.com/blog
Connect with KnowledgeCity!
Twitter: goo.gl/wToC6s
Facebook: goo.gl/3eMEq9
LinkedIn: goo.gl/vg1aXt
Google+: goo.gl/Gjkffm
3 авг 2024
