Excel worksheet

Bag code: COMSO39630024 Days: 6 days "Today training: 5 hours" Time: 30 training hours Targeted participants: everyone interested in knowing information about Excel and its features Program overview: This program revolves around an updated and structured Excel worksheet (definition – types – characteristics – objectives – positives – negatives .. etc.) and will be presented through the following units: First training unit: Dealing with data in Excel Second training unit: Spell check in Excel Third training unit: Excel basics Fourth training unit: Basic skills for Excel Fifth training unit: Excel reports Sixth training unit: Excel functions and charts Program objectives: To enable the trainee to recognize rows and columns and the division of the worksheet in Excel. To understand how to use search and replace in Excel. To discuss essential tips for handling data in Excel. To deduce advanced basic skills for Excel and working with formulas. To extract reports within Excel and how to develop them. To practice advanced functions in the program and how to employ them practically. Program topics: First unit: (Dealing with data in Excel) Freezing rows and columns and dividing the worksheet in Excel. Filtering data in Excel. Relative and absolute cell references in Excel. Second unit: (Spell check in Excel) Using search and replace in Excel. Spell check in Excel. Page layout and printing in Excel. Third unit: (Excel basics) Creating and opening workbooks in Excel. Using OneDrive in Excel. Basic tips for handling data in Excel. Fourth unit: (Basic skills for Excel) Advanced basic skills for Excel and working with formulas. Formatting within Excel and table formatting. Fifth unit: (Excel reports) Reports within Excel and how to develop them. Using ready-made report tools within Excel. Sixth unit: (Excel functions and charts) Advanced functions in the program and how to employ them practically. Working with charts in Excel and how to create graphical charts. Contents of the kit: PowerPoint 162 Trainer's guide 215 Trainee's guide 196 Activities 12 Introductory guide 4 References 4 Evaluation forms and data 6 Pre- and post-test 6 Videos 12 Pictures 10 Mind maps 1 Brochure 1 Contents of the kit: Training kit model Please click here to view the training kit model