Creating Data and Content
- Enter and edit cell content
- Navigate to specific cell content
- Locate, select, and insert supporting information
- Insert, position, and size graphics
Analyzing Data
- Filter lists using AutoFilter
- Sort lists
- Insert and modify formulas
- Use statistical, date and time, financial, and logical functions
- Create, modify, and position diagrams and charts based on worksheet data
Formatting Data and Content
- Apply and modify cell formats
- Apply and modify cell styles
- Modify row and column formats
- Format worksheets
Collaborating
Managing Workbooks
- Create new workbooks from templates
- Insert, delete, and move cells
- Create and modify hyperlinks
- Organize worksheets
- Preview data in other views
- Customize Window layout
- Setup pages for printing
- Print data
- Organize workbooks using file folders
- Save data in appropriate formats for different uses
Organizing and Analyzing Data
- Use subtotals
- Define and apply advanced filters
- Group and outline data
- Use data validation
- Create and modify list ranges
- Add, show, close, edit, merge, and summarize scenarios
- Perform data analysis using automated tools
- Create PivotTable and PivotChart reports
- Use Lookup and Reference functions
- Use Database functions
- Trace formula precedents, dependents, and errors
- Locate invalid data and formulas
- Watch and evaluate formulas
- Define, modify, and use named ranges
- Structure workbooks using XML
Formatting Data and Content
- Create and modify custom data formats
- Use conditional formatting
- Format and resize graphics
- Format charts and diagrams
Collaborating
- Protect cells, worksheets, and workbooks
- Apply workbook security settings
- Share workbooks
- Merge workbooks
- Track, accept, and reject changes to workbooks
Managing Data and Workbooks
- Import data to Excel
- Export data from Excel
- Publish and edit Web worksheets and workbooks
- Create and edit templates
- Consolidate data
- Define and modify workbook properties
Customizing Excel
Apply for MS Excel Certification Now!!
https://www.vskills.in/certification/excel-online-certification-course
