Excel Workbook Management: Creation, Formulas, and Automation
Course
This course focuses on building and managing Excel workbooks while integrating formulas, data visualization, and automation tools.
Skills you’ll gain: creating and managing workbooks, navigating the Excel interface, entering data and creating formulas, applying basic formatting, using advanced functions, creating charts and PivotCharts, applying data validation and workbook security, and automating tasks using macros.
Here is the course outline:
1. Workbook Creation and Navigation BasicsCovers the Excel interface, Ribbon, workspace, and Quick Access Toolbar, along with creating and saving workbooks, entering data, applying basic formatting, and performing simple workbook and worksheet management tasks. 5 sections
|
|||||
|
2. Formulas, Function, and Data VisualizationFocuses on understanding and applying formulas and functions, exploring advanced functions, and creating visual reports using charts, graphs, and PivotCharts. 4 sections
|
||||
|
3. Workbook Security, Automation, and Worksheet ManagementCovers protecting workbooks using passwords and permissions, applying data validation, automating tasks with macros, and managing worksheets by creating, copying, moving, and organizing them. 7 sections
|
|||||||
|