Excel worksheet

Training bag code: COMSO39630024 Professional training bag in Microsoft Excel program aimed at developing trainees' skills in data handling, report preparation, use of advanced functions, and creating professional charts. The training course helps participants master the basics of Excel and the advanced skills needed for the labor market, with practical applications on data management, organizing tables, and analyzing information. Training program details Excel worksheet Duration of the program Number of days: 6 training days Duration of the training day: 5 hours Total training hours: 30 hours Target group All interested in learning Excel program. Employees and administrators. Students. Workers in data entry and analysis. Those wishing to develop reporting and electronic table skills. Course objectives Identify rows, columns, and the division of the worksheet in Excel. Understand the search, replace, and spell check mechanisms. Acquire professional data handling skills. Master formulas and advanced functions. Prepare professional reports within Excel. Create charts and visually analyze data. Training bag topics Unit One: Handling data in Excel Freezing rows and columns. Splitting the worksheet. Filtering data. Relative and absolute cell references. Unit Two: Spell check in Excel Find and replace. Spell check. Page layout and printing. Unit Three: Excel basics Creating and opening workbooks. Using OneDrive. Data organization skills. Unit Four: Basic Excel skills Formulas and basic and advanced functions. Formatting tables and cells. Professional data formatting. Unit Five: Excel reports Preparing reports. Developing professional reports. Using ready-made reporting tools. Unit Six: Excel functions and charts Advanced functions and their applications. Creating charts. Data analysis using charts. Bag contents: PowerPoint 162 Trainer's guide 215 Trainee's guide 196 Activities 12 Introductory guide 4 References 4 Evaluation and data forms 6 Pre- and post-test 6 Videos 12 Images 10 Mind maps 1 Brochure 1 Bag contents 12 training bag models Please click here to view the training bag model