Shortcut Excel dan Fungsinya Training.pptx

Mempermudah cara kerja di excel :

Banyak cara yang bisa dilakukan dengan cara cepat dan lenbih mudah untuk dipelajari maupun diterapkan pada aktifitas sehari-hari

1. Shortcut Excel Dan Fungsinya PT. GLOBAL ELEKTRIK NASIONAL

2. INTRODUCTION Shortcut excel adalah pintasan keyboard microsoft excel yang digunakan sebagai alternatif lain untuk mengakses atau mengaktifkan perintah-perintah pada Microsoft Excel tanpa menggunakan (mouse).

3. Menyimpan file excel (File--Save) Print Preview / Langsung Print Menampilkan kotak dialog open untuk membuka file Ctrl Membuat workbook/file excel baru Menutup Workbook yang aktif (File--Close) Menyimpan file excel dengan nama yang lain (File--Save as) SHORTCUT FILE N Ctrl O Ctrl S F12 Ctrl F4 Ctrl P

4. Perintah Redo atau mengulagi perintah atau aksi yang telah dilakukan sebelumya Print Preview / Langsung Print Perintah Undo atau membatalkan perintah sebelumnya Ctrl Menampilkan atau menyembunyikan ribbon excel Membuka jendela "Paste special" Mengaktifkan/Menonaktifkan Autofilter SHORTCUT OTHERS F1 Ctrl Z Ctrl Y Ctr Ctrl Alt Ctrl P Shift L V

5. Menggunakan Autosum atau penjumlahan Membuat table otomatis pada excel Membuka jendela "Find" Ctrl Menyisipkan hyperlink Membuka jendela "Paste special" Mengaktifkan/Menonaktifkan Autofilter SHORTCUT OTHERS K Ctrl F Alt = Ctr Ctrl Alt Ctrl T Shift L V

6. Here’s what you’ll find in this Slidesgo template: A slide structure based on a multi-purpose , which you can easily adapt to your needs. For more info on how to edit the template, please visit Slidesgo School or read our FAQs . To view this template in PowerPoint with the correct fonts, download and install on your computer the fonts that we have used . You can learn how to download and install fonts here . An assortment of illustrations that are suitable for use in the presentation can be found in the a lternative resources slide. A thanks slide, which you must keep so that proper credits for our design are given. Two resources slide, where you’ll find links to all the elements used in the template. Instructions for use . Final slides with: The fonts and colors used in the template. A selection of illustrations . You can also customize and animate them as you wish with the online editor. Visit Stor yset to find more. More infographic resources , whose size and color can be edited. Sets of customizable icons of the following themes: general, business, avatar, creative process, education, help & support, medical, nature, performing arts, SEO & marketing, and teamwork. You can delete this slide when you’re done editing the presentation . CONTENTS OF THIS TEMPLATE

7. TABLE OF CONTENTS You can describe the topic of the section here You can describe the topic of the section here You can describe the topic of the section here 01 03 02 OVERVIEW FEATURES OF THE TOPIC ASSIGNMENT You can describe the topic of the section here 04 ABOUT THE TOPIC

8. You can describe the topic of the section here FEATURES OF THIS TOPIC TABLE OF CONTENTS OUR ASSIGNMENT You can describe the topic of the section here OUR OVERVIEW You can describe the topic of the section here You can describe the topic of the section here ABOUT THIS TOPIC 01 02 03 04

9. WHOA! This can be the part of the presentation where you introduce yourself, write your email…

10. INTRODUCTION You can give a brief description of the topic you want to talk about here. For example, if you want to talk about Mercury, you can say that it’s the smallest planet in the entire Solar System

11. SECTION Enter a subtitle here if you need it 01

12. OVERVIEW OF THIS LESSON You can enter a subtitle here if you need it 01

13. WHAT IS THIS TOPIC ABOUT? Neptune is the farthest planet from the Sun NEPTUNE Jupiter is a gas giant and the biggest planet JUPITER Despite being red, Mars is actually a cold place MARS Venus has a beautiful name, but it is hot VENUS

14. Mercury is the closest planet to the Sun DEFINITION OF CONCEPTS MERCURY JUPITER Jupiter is a giant and the biggest planet VENUS Venus is the second planet from the Sun

15. A PICTURE ALWAYS REINFORCES THE CONCEPT Images reveal large amounts of data, so remember: use an image instead of a long text. Your audience will appreciate it

16. DEFINITION OF CONCEPTS Venus is the second planet from the Sun VENUS It’s the biggest planet in the Solar System JUPITER Mercury is the closest planet to the Sun MERCURY

17. “This is a quote, words full of wisdom that someone important said and can make the reader get inspired.” —SOMEONE FAMOUS

18. “This is a quote, words full of wisdom that someone important said and can make the reader get inspired.” —SOMEONE FAMOUS

19. 35% SUBJECTS 50% 15% It’s the closest planet to the Sun and the smallest one of them all Venus has a nice name and is the second planet from the Sun Despite being red, Mars is a cold place. It’s full of iron oxide dust MERCURY VENUS MARS

20. OUR STUDENTS Mercury is the smallest planet MERCURY Mars is a very cold place MARS Neptune is far away from Earth NEPTUNE SATURN Saturn is the ringed planet Follow the link in the graph to modify its data and then paste the new one here. For more info, click here

21. STUDENT PROGRESS Mars is a very cold place Saturn is a gas giant with rings Neptune is far away from Earth Venus has a beautiful name Mercury is the smallest planet SEPTEMBER NOVEMBER JANUARY OCTOBER DECEMBER

22. FEATURES OF THIS TOPIC You can enter a subtitle here if you need it 02

23. You can write about the topic here You can write about the topic here You can write about the topic here You can write about the topic here FEATURES OF THE TOPIC

24. FEATURES OF THIS TOPIC JUPITER Mercury is the smallest planet Venus has beautiful name but is hot Jupiter is the biggest planet of them all SATURN NEPTUNE Saturn is a gas giant and it has rings Neptune is far away from Earth Mars is actually a very cold place MERCURY VENUS MARS A B C D E F

25. 44,000,000 100,000,000 56,000,000 Illiterate young men Illiterate youth in the world Illiterate young women

26. 16,000 6,000 OUR NUMBERS Jupiter is a gas giant and the biggest planet in the Solar System Venus has a beautiful name and is the second planet from the Sun Despite being red, Mars is actually a cold place full of iron oxide dust Saturn is composed mostly of hydrogen and also helium 20,000 70,000

27. Despite being red, Mars is a cold place MARS JUPITER It’s a giant and the biggest planet VENUS SATURN Venus has a very beautiful name Saturn is a gas giant with several rings PRACTICAL USES OF THIS SUBJECT

28. PENDING THINGS 1 WEEK 2 WEEK 3 WEEK 4 WEEK Describe your task 01 here Describe your task 02 here Describe your task 03 here Describe your task 04 here

29. Despite being red, Mars is a cold place. It’s full of iron oxide dust, which gives the planet its reddish cast DEMO You can add your own multimedia content here. Delete this image and insert the video

30. DID YOU KNOW THIS? Mars is actually a cold very place Jupiter is the biggest planet of them all Venus is terribly hot even hotter than Mercury VENUS JUPITER MARS

31. Mercury is the closest planet to the Sun and the smallest one Jupiter is a gas giant and the biggest planet in the Solar System PROBLEM SOLUTION

32. PROBLEM VS. SOLUTION SOLUTION Venus has a beautiful name and is the second planet from the Sun. It’s really hot there PROBLEM Mercury is the closest planet to the Sun and the smallest one in the entire Solar System

33. PROCESS 1960 1980 2000 2019 Mercury is the smallest planet Neptune is far away from Earth Jupiter is the biggest planet Venus has a beautiful name

34. THIS IS A GRAPH NEPTUNE MERCURY SATURN Mercury is the closest planet to the Sun and the smallest one Follow the link in the graph to modify its data and then paste the new one here. For more info, click here

35. AWESOME WORDS

36. AWESOME WORDS

37. OVERVIEW It is the farthest planet from the Sun Venus has a beautiful name, but it is hot It is the biggest planet in the Solar System MERCURY JUPITER VENUS NEPTUNE

38. OVERVIEW It is the smallest planet in the Solar System It is the biggest planet in the Solar System It is composed mostly of hydrogen and helium It has a beautiful name, but it is terribly hot MERCURY SATURN VENUS JUPITER NEPTUNE MARS

39. ASSIGNMENT OF THIS LESSON You can enter a subtitle here if you need it 03

40. PRIORITIES DEADLINE PRIORITY DESCRIPTION 01/30/22 Write your task here 9/23/22 Write your task here 10/03/22 Write your task here 12/10/22 Write your task here

41. THIS IS ANOTHER GRAPH MERCURY Mercury is the closest planet to the Sun VENUS Venus has a beautiful name, but it’s hot NEPTUNE Neptune is the farthest planet from the Sun To modify this graph, click on it, follow the link, change the data and paste the new graph here 45% 15% 40%

42. THIS IS A TIMELINE Mercury is the closest planet to the Sun and the smallest one Despite being red, Mars is actually a cold place Saturn is a gas giant and it also has several rings Neptune is the farthest planet from the Sun Jupiter is a gas giant and the biggest planet of them all MERCURY NEPTUNE SATURN MARS JUPITER 1 2 3 4 5

43. A PICTURE IS A WORTH A THOUSAND WORDS

44. A PICTURE IS WORTH A THOUSAND WORDS

45. TIMETABLE HOUR MON TUE WED THU FRI 3 4 5 6 7 10 AM Math Chemistry 11 AM 12 PM Arts Physics Math Chemistry 1 PM Lunch Lunch Lunch Lunch Lunch 2 PM

46. Big numbers catch your audience’s attention 13,012,400

47. EXERCISE Venus has a beautiful name 94% Mercury is the smallest planet 80% Despite being red, Mars is a cold place 70%

48. 25% DO YOU NEED MORE PERCENTAGES? Venus is the second planet from the Sun 15% Despite being red, Mars is a cold place 10% It’s the biggest planet of them all 50% Saturn is a gas giant and has rings VENUS MARS JUPITER SATURN

49. THIS IS A TABLE VENUS SATURN EARTH MASS 0.08 2.50 1.15 DIAMETER 5.95 9.82 1.05 GRAVITY 1.02 2.08 1.13

50. ABOUT THIS LESSON You can enter a subtitle here if you need it 04

51. Do you know what helps you make your point clear and understandable? Lists like this one: They’re simple You can organize your ideas clearly You’ll never forget to buy milk! And the most important thing: the audience won’t miss the point of your presentation WHAT IS THIS TOPIC ABOUT

52. CLASS ATTENDANCE MERCURY It’s the closest planet to the Sun and the smallest one in the Solar System VENUS Venus has a beautiful name and is the second planet from the Sun MARS Despite being red, Mars is actually a cold place. It’s full of iron oxide dust 25% 60% 15%

53. VANESSA DOE AMELIA THOMPSON JONATHAN SMITH OUR TEACHERS You can speak a bit about this person here You can speak a bit about this person here You can speak a bit about this person here

54. OUR TEACHERS MARIA SUMMERS You can speak a bit about this person JOHN JOHNSON You can speak a bit about this person DAVID SCHEINER You can speak a bit about this person LISA STRANSKY You can speak a bit about this person

55. OUR SCHOOLS You can enter here text with relevant information concerning this map NEPTUNE

56. DESKTOP MOCKUP You can replace the image on the screen with your own work. Just right-click on it and select “Replace image”

57. TABLET MOCKUP You can replace the image on the screen with your own work. Just right-click on it and select “Replace image”

58. PHONE MOCKUP You can replace the image on the screen with your own work. Just right-click on it and select “Replace image”

59. You can replace the image on the screen with your own work. Just right-click on it and select “Replace image” OTHER MOCKUPS

60. Write your material Write your material Write your material Write your material Write your material Write your material YOUR MATERIALS Write a thing to buy Write a thing to buy Write a thing to buy Write a thing to buy Write a thing to buy Write a thing to buy YOU NEED TO BUY… WHAT DO YOU NEED

61. THIS TEXT SEEMS TO BE IMPORTANT... Jupiter is a gas giant and the biggest planet in the Solar System. It's the fourth-brightest object in the night sky. It was named after the Roman god of the skies

62. Do you have any questions? [email protected] [phone] yourcompany.com THANKS! Please keep this slide for attribution

63. EDUCATION ICON PACK

64. TEACHER ICON PACK

65. ALTERNATIVE RESOURCES

66. ALTERNATIVE RESOURCES I Here’s an assortment of alternative resources whose style fits the one of this template: Illustration of online certification on computer screen

67. ALTERNATIVE INFOGRAPHICS A B C D CERES EARTH PLUTO THE SUN MERCURY SATURN JUPITER MARS NEPTUNE

68. ALTERNATIVE INFOGRAPHICS I MERCURY SATURN VENUS MARS JUPITER NEPTUNE

69. RESOURCES Did you like the resources on this template? Get them for free at our other websites: Photos Globe and books near laptop Kids and teacher posing while wearing a medical mask Happy teenager making notes near laptop Vectors Online certification with laptop Online certification concept Online certification concept Online certification for college graduates Icons Education Icon Pack

70. Did you like the resources on this template? Get them for free at our other websites: Vectors Illustrated graduates wearing medical masks at their ceremony Illustration of graduation ceremony on online platform Online certification with tablet Illustration of graduates wearing medical masks at their ceremony Icons Teacher Icon Pack RESOURCES I Photo Teenagers using laptop Guy using his laptop over the shoulder view Man holding his laptop and looking at camera People working together in a startup company People looking at tablet Woman with graduation diploma Smiley female teacher using laptop from home to hold an online class Copy space woman with graduation diploma

71. Instructions for use (premium users) In order to use this template, you must be a Premium user on S lidesgo . You are allowed to: Modify this template. Use it for both personal and commercial purposes. Hide or delete the “Thanks” slide and the mention to Slidesgo in the credits. Share this template in an editable format with people who are not part of your team. You are not allowed to: Sublicense, sell or rent this Slidesgo Template (or a modified version of this Slidesgo Template). Distribute this Slidesgo Template (or a modified version of this Slidesgo Template) or include it in a database or in any other product or service that offers downloadable images, icons or presentations that may be subject to distribution or resale. Use any of the elements that are part of this Slidesgo Template in an isolated and separated way from this Template. Register any of the elements that are part of this template as a trademark or logo, or register it as a work in an intellectual property registry or similar. For more information about editing slides, please read our FAQs or visit Slidesgo School: https://slidesgo.com/faqs and https://slidesgo.com/slidesgo-school

72. #4c64d8 #ff952b #d5e6fc #ffe599 #a8cfff #00004d #e9f3ff Fonts & colors used This presentation has been made using the following fonts: Aldrich ( https://fonts.google.com/specimen/Aldrich ) Didact Gothic ( https://fonts.google.com/specimen/Didact+Gothic )

73. Storyset Create your Story with our illustrated concepts. Choose the style you like the most, edit its colors, pick the background and layers you want to show and bring them to life with the animator panel! It will boost your presentation. Check out h ow it works. Pana Amico Bro Rafiki Cuate

74. You can easily resize these resources without losing quality. To change the color , just ungroup the resource and click on the object you want to change. Then, click on the paint bucket and select the color you want. Group the resource again when you’re done. You can also look for more infographics on Slidesgo. Use our editable graphic resources...

75. JANUARY FEBRUARY MARCH APRIL MAY JUNE PHASE 1 PHASE 2 Task 1 Task 2 Task 1 Task 2 JANUARY FEBRUARY MARCH APRIL PHASE 1 Task 1 Task 2

76. ...and our sets of editable icons You can resize these icons without losing quality. You can change the stroke and fill color ; just select the icon and click on the paint bucket/pen . In Google Slides, you can also use Flaticon’s extension , allowing you to customize and add even more icons.

77. Educational I cons Medical Icons

78. Business I cons Teamwork Icons

79. Help & Support I cons Avatar Icons

80. Creative Process I cons Performing Arts Icons

81. Nature Icons

82. SEO & Marketing Icons

83. Add the title here Text 1 Text 2 Text 3 Text 4 Text 5 Text 6 2016 2017 2018 2019 2020 “Despite being red, Mars is actually a very cold place” “Mercury is closest planet to the Sun and the smallest” “Neptune is the farthest-known planet from the Sun” “Saturn is a gas giant and has several rings” “Venus is the second planet from the Sun and is terribly hot” Premium infographics

84. “Mercury is closest planet to the Sun and the smallest” “Mercury is closest planet to the Sun and the smallest” “Mercury is closest planet to the Sun and the smallest” “Mercury is closest planet to the Sun and the smallest” TITLE 1 75% 75% Premium infographics

85. Digital Marketing Premium Icons

86. Online Learning Premium Icons

87. Laboratory Premium Icons

88. Goals & Results Premium Icons

89. Infographic Elements Premium Icons