Microsoft Excel
Description
Microsoft Excel Course introduces participants to working with Microsoft Excel, covering the basics such as creating and editing worksheets, formatting them for a professional look, working with formulas to manage routine tasks, etc.
Curriculum For This Course
+ MICROSOFT EXCEL (10)
| Getting Started - Understanding the Excel screen, Navigating in a spreadsheet, Understanding worksheets, columns, rows and cells, Saving, opening, and closing workbooks |
| Formatting a Spreadsheet - Changing column widths and row heights, Changing alignment of cells, Undoing and redoing actions, Formatting numbers, Clearing formats, Applying borders to cells, Merging cells |
| Formulas and Functions - Entering formulas, Copying data and formulas, Using AutoSum, Understanding functions, ,Using simple aggregate functions (Sum, Count, Average, Min, Max), Copying formulas, Applying conditions in a formula (The IF function), Working with ranges |
| Editing Features - Using cut , copy, and paste operations, Using paste special with values, Selection techniques, Navigation techniques |
| Working with Large Worksheets - Freezing and unfreezing panes, Splitting windows, Inserting page breaks for printing |
| Working with Charts - Creating charts using Chart Wizard, Creating different types of charts, Including titles and values in charts, Formatting of charts |
| Previewing and Printing - Previewing worksheets, Page setup, Printing of worksheets in multiple pages, Repeating rows and columns for multiple pages, Printing multiple worksheets |
| Simple Database Operations - Sorting tables, Filtering data with auto filter, Referring data from other worksheets |