Sunday, 25 February 2024

Excel Tips For Productivity - PivotTables


Use PivotTables to summarize, analyze, and present large amounts of data in a concise format. It's a powerful tool for data analysis and reporting.

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

Tuesday, 20 February 2024

Excel Tips For Productivity - Tables


Convert your data into Excel tables (Ctrl+T) to easily sort, filter, and analyze your data. Tables also make it simpler to create charts and pivot tables.

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

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