Call us Today ! +233 248 833 753 | support@gh-lep.com
   

In this introductory course, you learn how to summarize data with Excel by incorporating formulas, formatting, and charts and graphs. You also gain the skills to efficiently navigate and manipulate multiple spreadsheets in a workbook, optimize your worksheets using templates, graphs and formulas, and design simple-to-complex formulas by nesting Excel functions.

 

Spread the love
  • 15
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
    15
    Shares

Course Curriculum

SECTION 1
Lesson 1 – How to opening Microsoft Excel 01:00:00
Practical 1 – How to Opening Excel 01:00:00
Exercise 1 – How to opening Excel 02:00:00
Lesson 2 – Excel Interface 01:00:00
Practical 2 – Excel User Interface 01:00:00
Exercise 2 – Excel Interface 02:00:00
Lesson 3 – Create a workbook 01:00:00
Practical 3 – Create a workbook 01:00:00
Lesson 4 – Enter data in a worksheet 24 hours
Practical 4 – Enter data in a worksheet 00:00:00
Exercise 4 – Enter data in a worksheet 00:00:00
Lesson 5 – Format a worksheet 00:00:00
Practical 5 – Format a worksheet 00:00:00
Exercise 5 – Format a worksheet 00:00:00
Lesson 6 – Reposition the data in a cell 00:00:00
Practical 6 – Reposition the data in a cell 00:00:00
Exercise 6 – Reposition the data in a cell 00:00:00
Lesson 7 – Apply or remove cell borders on a worksheet 00:00:00
Practical 7 – Apply or remove cell borders on a worksheet 00:00:00
Exercise 7 – Apply or remove cell borders on a worksheet 00:00:00
Lesson 8 – Change the color of text 00:00:00
Practical 8 – Change the color of text 00:00:00
Lesson 9 – Saving a workbook 00:00:00
Practical 9 – Saving a workbook 00:00:00
Exercise 8 – Changing text color and Saving a workbook 00:00:00
SECTION 2
Lesson 10 – Apply or remove cell shading 00:00:00
Practical 10 – Apply or remove cell shading 00:00:00
Lesson 11 – Format numbers in a worksheet 00:00:00
Practical 11 – Format numbers in a worksheet 00:00:00
Exercise 9 -Cell Shading and Format numbers in a worksheet 00:00:00
Lesson 12 – Print a worksheet 00:00:00
Practical 12 – Print a worksheet 00:00:00
Exercise 10 – Print a worksheet 00:00:00
Lesson 13 – Filter data by using an AutoFiltert 00:00:00
Practical 13 – Filter data by using an AutoFilter 00:00:00
Lesson 14 – Sort data by using an AutoFilter 00:00:00
Practical 14 – Sort data by using an AutoFilter 00:00:00
Exercise 11 – Filter and Sort data by using an AutoFilter 00:00:00
Lesson 15 – Apply conditional formatting 00:00:00
Practical 15 – Apply conditional formatting 00:00:00
Lesson 16 – Apply data validation 00:00:00
Practical 16 – Apply data validation 00:00:00
Exercise 12 – Apply Conditional formatting and data validation 00:00:00
Lesson 17 – Create or delete an Excel table in a worksheet 00:00:00
Practical 17 – Create or delete an Excel table in a worksheet 00:00:00
Exercise 13 – Create or delete an Excel table in a worksheet 00:00:00
SECTION 3
Lesson 18 – Create a formula 00:00:00
Practical 18 – Create a formula 00:00:00
Exercise 14 – Create a formula 00:00:00
Lesson 19 – Use a function in a formula 00:00:00
Practical 19 – Use a function in a formula 00:00:00
Exercise 15 – Use a function in a formula 00:00:00
Lesson 20 – Chart your data 00:00:00
Practical 20 – Chart your data 00:00:00
Exercise 16 – Chart your data 00:00:00
Practical 21 – Create a PivotTable report 00:00:00
Lesson 21 – Create a PivotTable report 00:00:00
Lesson 22 – Create a macro 00:00:00
Practical 22 – Create a use a macro 00:00:00
Exercise 17 – Create a PivotTable Report and macro 00:00:00
Lesson 23 – Activate and use an add-in 00:00:00
Practical 23 – Activate and use an add-in 00:00:00
SECTION 4
Lesson 24 – Share a workbook 00:00:00
Lesson 25 – Edit a shared workbook 00:00:00
Lesson 26 – Remove a user from a shared workbook 00:00:00
Lesson 27 – Resolve conflicting changes in a shared workbook 00:00:00
Lesson 28 – End the sharing of a workbook 00:00:00
Practical 28 – End the sharing of a workbook 00:00:00
Exercise 18 – Share a workbook 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE

Instructors

2 STUDENTS ENROLLED

Course Reviews

X