[EN]Microsoft Excel – U Connect

Contenu Cours

Tout Afficher

01. Welcome to Excel 6 Chapitres

Développer

Contenu du Leçon

0% terminé Marches 0/6

01. Welcome to Excel What is Excel

02. Welcome to Excel Create a Work book

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 Chapitres

Développer

Contenu du Leçon

0% terminé Marches 0/5

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 Chapitres

Développer

Contenu du Leçon

0% terminé Marches 0/7

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 Chapitres

Développer

Contenu du Leçon

0% terminé Marches 0/5

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 Chapitres

Développer

Contenu du Leçon

0% terminé Marches 0/7

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 Chapitres

Développer

Contenu du Leçon

0% terminé Marches 0/10

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 Chapitres

Développer

Contenu du Leçon

0% terminé Marches 0/5

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 Chapitres

Développer

Contenu du Leçon

0% terminé Marches 0/6

47. Formatting Align text in a cell

48. Formatting Format 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 Chapitres

Développer

Contenu du Leçon

0% terminé Marches 0/3

53. Share and coauthor Share a workbook

54. Share and coauthor Add and review comments

55. Share and coauthor Pass work protect workbooks

French