[EN]Microsoft Excel – U Connect

Course Content

Expand All

01. Welcome to Excel 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

01. Welcome to Excel What is Excel

02. Welcome to Excel Create a Workbook

03. Welcome to Excel Insert or Delete Worksheets

04. Welcome to Excel Move or Copy Worksheets

05. Welcome to Excel Fill data automatically

06. Welcome to Excel Create a drop down list

02. Rows and Columns 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

07. Rows columns Insert or Delete Rows or Columns

08. Rows columns Change the column width and row height

09. Rows columns Hide or unhide columns

10. Rows columns Freeze columns or rows

11. Rows columns Combine data

03. Cells 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

13. Cells Select cell contents

14. Cells Merge unmerge cells

15. Cells Copy cells

16. Cells Move cells

17. Cells Auto fill dates

18. Cells Create Custom Numeric Format

19. Cells Validate cell data

04. Tables 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

20. Tables Create a table in Excel

21. Tables Add a Total row to a table

22. Tables Filter data in a range or table

23. Tables Sort data in a table

24. Tables Use slicers to filter data

05.Charts 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

25. Charts Create Charts

26. Charts Add a chart title

27. Charts Analyze your data quickly

28. Charts Add a secondary axis

29. Charts Use Spark lines to show data trends

30. Charts Show or hide a chart legend

31. Charts Change the source for a chart

06. Formulas and Functions 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

32. Formulas and functions Define and use names informulas

33. Formulas and functions SUM

34. Formulas and functions Subtraction

35. Formulas and functions Multiplication

36. Formulas and Functions Division

37. Formulas and functions IF

38. Formulas and functions IFS

39. Formulas and functions SUMIF

40. Formulas and functions SUMIFS

41. Formulas and functions VLOOKUP

07. Pivot Tables 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

42. Pivot Tables Create a Pivot Chart

43. Pivot Tables Create a Pivot Table

44. Pivot Tables Work with Pivot Tables

45. Pivot Tables Filter data in a Pivot Table

46. Pivot Tables Group data in Pivot Tables

08. Formatting 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

47. Formatting Align text in a cell

48. Formatting Formatting numbers in cells

49. Formatting Apply styles

50. Formatting Copy cell formatting

51. Formatting Conditional formatting

52. Formatting Create a watermark

09. Share and Coauthor 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

53. Share and coauthor Share a workbook

54. Share and co-author Add and review comments

55. Share and coauthor Pass work protect workbooks

English