Tuesday, 20 February 2024

Excel Tips For Productivity - Conditional Formatting


Apply conditional formatting to highlight cells that meet certain criteria, making it easier to identify trends, outliers, or important data points.

#AzmiShahrin
#TripleATraining
#HRDCTrainingProvider
#KursusExcel
#KursusMicrosoftExcel
#MicrosoftOfficeExcelCourseKL
#MicrosoftExcelCourseKL
#ExcelCourseKL

Excel Tips For Productivity - Flash Fill


Excel's Flash Fill feature can automatically fill in values based on patterns it recognizes in your data. It's especially useful for separating data or combining data in a specific format.

#AzmiShahrin
#TripleATraining
#HRDCTrainingProvider
#KursusExcel
#KursusMicrosoftExcel
#MicrosoftOfficeExcelCourseKL
#MicrosoftExcelCourseKL
#ExcelCourseKL

Excel Tips For Productivity - AutoFill


Use AutoFill (click and drag the fill handle, usually a small square at the bottom-right corner of a cell) to quickly fill cells with a series of data or formulas.

#AzmiShahrin
#TripleATraining
#HRDCTrainingProvider
#KursusExcel
#KursusMicrosoftExcel
#MicrosoftOfficeExcelCourseKL
#MicrosoftExcelCourseKL
#ExcelCourseKL

Excel Tips For Productivity - Keyboard Shortcuts


Learn and use keyboard shortcuts like Ctrl+C (Copy), Ctrl+V (Paste), Ctrl+Z (Undo), Ctrl+S (Save), Ctrl+F (Find), etc., to speed up your work.

#AzmiShahrin
#TripleATraining
#HRDCTrainingProvider
#KursusExcel
#KursusMicrosoftExcel
#MicrosoftOfficeExcelCourseKL
#MicrosoftExcelCourseKL
#ExcelCourseKL

Sunday, 13 December 2020

Fonts Dalam Excel


Sebanyak 512 fonts boleh digunakan di dalam lembaran Excel.

#AzmiShahrin
#TripleATraining
#HRDFTrainingProvider
#KursusExcel
#KursusMicrosoftExcel
#MicrosoftOfficeExcelCourseKL
#MicrosoftExcelCourseKL
#ExcelCourseKL

Monday, 30 November 2020

Kandungan Sel Excel


Sel excel boleh mengandungi hingga 32,767 aksara.

#AzmiShahrin
#TripleATraining
#HRDFTrainingProvider
#KursusExcel
#KursusMicrosoftExcel
#MicrosoftOfficeExcelCourseKL
#MicrosoftExcelCourseKL
#ExcelCourseKL

Thursday, 8 October 2020

Versi Awal Excel Mengandungi Permainan Video


Versi Excel sebelumnya mengandungi beberapa "Easter Eggs" yang menakjubkan.

Untuk Excel 95, pengguna hanya perlu pergi ke baris 95, memilih keseluruhan baris, tekan kekunci tab sekali, klik pada "?" ikon dan pilih "About Microsoft Excel," tekan Ctrl, Alt dan Shift pada masa yang sama dan gunakan tetikus untuk mengklik sokongan teknikal.

Ini akan membawa anda ke tetingkap yang disebut "Hall of Tortured Souls," yang dapat anda navigasi untuk melihat gambar beberapa pereka perisian Office 95.

#AzmiShahrin
#TripleATraining
#HRDFTrainingProvider
#KursusExcel
#KursusMicrosoftExcel
#MicrosoftOfficeExcelCourseKL
#MicrosoftExcelCourseKL
#ExcelCourseKL