Intermediate Ms Excel
In-Person/Online
2 Days
English/Arabic
Learning Objectives
Apply key excel functions and formulas. Change and customize the workbook appearance to optimize spreadsheets. Manage spreadsheets using filter and sort table data capabilities. Re-order and summarize data effectively. Use data from multiple sources. Perform data visualization using basic charts.
In-Person/Online 2 Days
English/Arabic
Learning Objectives
Apply key excel functions and formulas. Change and customize the workbook appearance to optimize spreadsheets. Manage spreadsheets using filter and sort table data capabilities. Re-order and summarize data effectively. Use data from multiple sources. Perform data visualization using basic charts.
Modules
Module 1: Performing Calculations, Functions and Formulas
- Selecting and naming ranges
- Using auto calculate
- Using functions and formulas
- Using auto sum and autofill
- Using date & time functions
- Using text functions
- Using IF function
Module 2: Managing Workbook Information
- Managing information
- Clearing information
- Deleting and inserting ranges
- Moving and copying information
- Copying formulas:
- Understanding relative, absolute, and mixed formulas
- Creating absolute and mixed references
- Copying values only
- Using autocomplete
Module 3: Working With Multiple Worksheets and Workbooks
- Working across worksheets & workbooks
- Working with multiple sheet formulas
- Consolidating information
- Linking information between workbooks
- Working with large worksheets
Module 4: Working With Data in Lists
- Understanding data lists
- Creating and removing subtotals
- Using data validation
- Restricting cells to numbers/dates/times
- Restricting cells to a list of values
- Convert, sort, filter, and manage lists
Module 5: Using Illustrations in Excel
- Working with clip art
- Using shapes
- Working with icons
- Working with SmartArt
Module 6 : Working With Charts: Create and Modify Charts
- Creating different chart
- Modifying titles and labels
- Modifying axes, gridlines, and legends
- Working with data tables
- Changing the data range
- Working with data series
- Deleting a chart
Module 7 : Conditional Formatting
- Highlight cells rules
- Top/bottom rules
- Data bars, color scales, and icon sets
- Adding your own formatting rules manually
- Showing only one icon
- Showing data bars and icons outside cells
- Representing trends with icon sets
- Building a legend for your conditional formatting
Our Partners
