Latest Post
Tampilkan postingan dengan label BAHAN AJAR. Tampilkan semua postingan
Tampilkan postingan dengan label BAHAN AJAR. Tampilkan semua postingan

200 Excel shortcuts



Within Excel you can conduct calculations on multiple worksheets and workbooks open at the same time.

Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a tab within a workbook with separate cells.

This section of the Excel Guide offers all shortcuts you need to open, navigate between, and control all of these options.




Worksheets dan Workbooks


Within excel you can conduct calculations on multiple worksheets and workbooks open at the same time. Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a tab within a workbook with separate cells. This section of the Excel Guide offers all shortcuts you need to open, navigate between, and control all of these options.


View


Excel offers a diverse set of ways you can view your spreadsheets. From hiding select cells to entire rows and columns, there are a number of shortcut options you can take advantage of to get the most optimal view to complete your work.


Row and Column Selection


Mass edits can save you incredible amounts of time within Excel. Often you will want to control entire rows or columns in order use the data to create charts/graphs, or simply to move and edit many cells at once. Shortcuts within this section will help you control large quantities of data with ease.


Ribbon Control


The ribbon, which is located at the top of your Excel spreadsheet, includes tabs that can be accessed to control various aspects of your work within Excel. These simple shortcuts can be used to access the ribbon, navigate its features, and change the cells your ribbon is controlling or editing.


Pivot Tables


Pivot tables allow you to extract information and significance from massive sets of data within Excel. Although operating within them can be difficult, using these shortcuts to navigate within them and control data points can turn even novices in pivot table aficionados.


Operating Within a Cell


Cells are where the magic happens within Excel. They hold your data and text, can be grouped to create beautiful graphs, and are truly the organizational cornerstone of your spreadsheet. Each shortcut in this section will help you better move within a cell, as well as add and extract data.


Navigating and Selecting Cells


Once cells are selected, Excel users are presented with a plethora of options that take full advantage of all cells in the selected range. These shortcuts will allow you to navigate to the cell you wish to select with ease no matter where it is within your spreadsheet. Additionally, you will be able to select everything from words to individual data points and characters.


Help and Menus


As with all Microsoft Office products, Excel offers a number of helpful tools that can help you to organize and optimize your spreadsheet and all it contains. Simple shortcuts for tools such as spell-check and thesaurus and be a accessed with the touch of a button, as well as more complex tools such as the cell modification menu.


Group Selection


As with all Microsoft Office products, Excel offers a number of helpful tools that can help you to organize and optimize your spreadsheet and all it contains. Simple shortcuts for tools such as spell-check and thesaurus and be a accessed with the touch of a button, as well as more complex tools such as the cell modification menu.


Group Selection


When cells are grouped together, you can do everything from creating graphs and pivot tables to extracting numerous other forms of both visual and text-based information. Shortcuts within this section will help you add cells to your selection whether they are adjacent to the active cell, or on the opposite side of the spreadsheet.


General Excel


The most of basic but useful of shortcuts within excel can be found in this section. Save your work, close it out safely, or even print a file; we’ve got you covered.


General Cell Control


The data and text you input into Excel can do much more than act as placeholders within cells. Shortcuts in this section will expand your capabilities of cell control far beyond what your mouse is capable of. You will be able to do everything from locating cell matches to creating tables.


Formulas and Functions

By adding formulas and functions to your Excel sheet, you instantly gain access to a wealth of information regarding your data and can conduct complex calculations with ease. These shortcuts can help Excel beginners and even advanced users begin building formulas and functions, as well as receive help where necessary.


Formatting Text and Numbers


Your text and data should look exactly the way you want it to. Simple shortcuts in this section will help you edit your content down to the last character. Options include bold, italics, underscore, numeric options, and much more.


Dialog Boxes


In Excel, a dialog box is a form that can help you add information and make decisions about different aspects of your current worksheet and its content such as data, charts, or graphic images. Shortcuts in this section will help you both open and work within these dialog boxes like a pro.


Copy and Paste


With these shortcuts, moving text and data around your spreadsheet can be easier than ever before. Data or text can be added to clipboard easily, and you can subsequently place the clipboard contents into whichever cell (or range of cells) you desire.


Borders


The design and aesthetics of your Excel spreadsheet is important. With these simple shortcuts you will be able to add custom borders to any cells you choose.


Advanced Selection


Navigating Excel to find certain cells based on data-driven criteria is a skill available even to Excel beginners. Try implementing shortcuts within this section to find cells such as dependents, precedents, and other advanced criteria.


Adding Content to Cells


Cells are nothing without the data and text you add to them. These shortcuts are the perfect tools to begin entering content efficiently and accurately down to the last character.

Source : www[dot]businessinsider[dot]sg

Buku Pegangan Guru dan Siswa untuk Kurikulum 2013


Melalui email yang dikirimkan oleh Bapak I Gusti Made Ardana dari P4TK BMTI Bandung  memberitahukan bahwa Buku Pegangan Guru dan Siswa untuk SD, SMP, SMA/SMK sesuai dengan Kurikulum 2013 yang dikeluarkan oleh Kementrian Pendidikan dan Kebudayaan telah selesai beliau upload.
Informasi :Hanya mata pelajaran/tema-tema yang ada dibawah yang baru menggunakan Kurikulum 2013, selain matpel tersebut atau sebelum ada buku resmi dari Kementrian P dan K, maka SEMUA matpel masih menggunakan KTSP. Contoh : Tingkat SMA/SMK hanya 3 Matpel yang menggunakan Kurikulum 2013, selain itu masih tetap KTSP
Buku - buku tersebut berupa softcopy/digital yang dapat didownload oleh Guru maupun siswa yang membutuhkannya, dengan rincian sebagai berikut :
KELAS I (SD)
No.Materi / Mata PelajaranPegangan GuruPegangan Siswa
1.PA. Budha25,2 MB66,8 MB
2.PA. Hindu3,7 MB41,5 MB
3.PA. Islam7,2 MB44,5 MB
4.PA. Katolik8,4 MB61,8 MB
5.PA. Khonghucu21,9 MB86,6 MB
6.PA. Kristen4,5 MB94,4 MB
7.Tema : Diriku24,9 MB44,3 MB
8.Tema : Kegemaranku25,5 MB42,8 MB
9.Tema : Kegiatanku18,9 MB50,3 MB
10.Tema : Keluargaku25,9 MB111,6 MB
KELAS IV (SD)
No.Materi / Mata PelajaranPegangan GuruPegangan Siswa
1.PA. Budha23,3 MB21.4 MB
2.PA. Hindu4,3 MB17.1 MB
3.PA. Islam2.8 MB39.5 MB
4.PA. Katolik4.5 MB16.3 MB
5.PA. Khonghucu21.3 MB89.6 MB
6.PA. Kristen5.5 MB21.1 MB
7.Tema : Indahnya Kebersamaan43.5 MB23.8 MB
8.Tema : Selalu Berhemat Energi-34.1 MB
9.Tema : Peduli Terhadap Makhluk Hidup53.1 MB33.2 MB
10.Tema : Berbagai Pekerjaan23.1 MB35.8 MB
KELAS VII (SMP)
No.Materi / Mata PelajaranPegangan GuruPegangan Siswa
1.PA. Budha18.7 MB23.8 MB
2.PA. Hindu17.1 MB16.9 MB
3.PA. Islam17.8 MB34.9 MB
4.PA. Katolik21.7 MB26.8 MB
5.PA. Khonghucu26.2 MB19.5 MB
6.PA. Kristen20.2 MB28.9 MB
7.Bahasa Indonesia5.3 MB14.1 MB
8.Bahasa Inggris92.4 MB143.1 MB
9.IPA22.6 MB68.9 MB
10.IPS2.5 MB68.1 MB
11.Penjasorkes29.9 MB29.8 MB
12.PPKn7.3 MB18.8 MB
13.Seni Budaya45.8 MB68.5 MB
KELAS X (SMA/SMK)
No.Materi / Mata PelajaranPegangan GuruPegangan Siswa
1.Bahasa Indonesia3.3 MB9.9 MB
2.Matematika18.2 MB4.8 MB
3.Sejarah Indonesia10.9 MB47.4 MB
Semoga postingan kali ini bisa bermanfaat - Terima Kasih  

Sumber : http://psmk[.]net/widyaprimaUpload : I Gusti Made Ardana, P4TK BMTI Bandung

Download Gratis Buku Pelajaran SMA KTSP



Selamat siang semua ...

Tahun Pelajaran baru 2013/2014 sudah dimulai pada tanggal 15 Juli 2013 beberapa hari yang lalu dan proses belajar mengajar juga berjalan. Biasanya di awal - awal Tahun Pelajaran Baru setiap siswa akan memulai segalanya dengan yang baru baik alat tulis baru, tas baru, baju baru, sepatu baru.... tapi muka tetap aja yang lama... hehehe.


Akan tetapi yang harus diingat bahwa semuanya tidak mesti baru, sesuaikan dengan kebutuhan sekolah dan yang dipersiapkan adalah yang penting saja seperti halnya buku pelajaran.


Tapi buku pelajaran tidak mesti membeli, kita juga bisa mendownloadnya dengan gratis. Berikut adalah buku-buku pelajaran yang bisa didownload dengan gratis alias ngga bayar.











































































































Mata PelajaranKelas XKelas XIKelas XII
PENDIDIKAN AGAMA ISLAM5.0 MB4.0 MB2.3 MB
PENDIDIKAN KEWARGANEGARAAN2.0 MB2.0 MB5.2 MB
BAHASA INDONESIA3.4 MB9.0 MB5.6 MB
BAHASA INGGRIS2.0 MB-4.2 MB
MATEMATIKA4.0 MB5.5 MB3.3 MB
FISIKA2.7 MB4.0 MB11 MB
BIOLOGI9.5 MB8.4 MB11.0 MB
KIMIA6.4 MB48.0 MB5.0 MB
SEJARAH5.3 MB4.0 MB4.0 MB
GEOGRAFI16.0 MB14.0 MB14.0 MB
EKONOMI10.0 MB2.7 MB1.7 MB
SOSIOLOGI7.8 MB6.0 MB6.0 MB
SENI BUDAYA---
PEND. JASMANI, ORKES1.8 MB3.4 MB20.0 MB
TEKNOLOGI INFORMASI & KOMUNIKASI58.0 MB29.0 MB27.0 MB
BAHASA ARAB--3.3 MB


Buku-buku tersebut akan selalu diupdate sampai benar - benar lengkap. PERHATIAN !!Buku-buku diatas bersumber dari BSE-Kemdikbud dan masih berbasis KTSP dan untuk Kurikulum 2013 ditunggu saja nanti akan saya share untuk pegangan guru dan siswa

 
Support : Johny Template
Copyright © 2011. Teknologi Informasi dan Komunikasi - All Rights Reserved
Proudly powered by Blogger