Excel data analysis 2019

189

Product description

Bag code: COMSO24416021 Days: 4 days "Training today 4 hours". Time: 16 training hours. Targeted participants: Anyone interested in learning Excel functions. Program overview: This program focuses on analyzing Excel 2019 data (definition – types – properties – objectives – advantages – disadvantages .. etc.) and will be presented through the following units: First training unit: Excel basics. Second training unit: Formulas and functions in Excel. Third training unit: Spell check and planning in Excel. Fourth training unit: Handling data in Excel. Program objectives: - That the trainee understands how to start using Excel. - That the trainee is aware of using OneDrive in Excel. - That the trainee explains creating and opening workbooks in Excel. - That the trainee recognizes simple formulas in Excel. - That the trainee discusses relative and absolute cell references in Excel. - That the trainee summarizes functions in Excel. - That the trainee is aware of basic tips for handling data in Excel. - That the trainee explains using find and replace in Excel. - That the trainee summarizes spell check in Excel. - That the trainee is aware of page layout and printing in Excel. - That the trainee understands freezing rows and columns and splitting the worksheet in Excel. - That the trainee is aware of data filtering in Excel. - That the trainee recognizes charts (graphs) in Excel. - That the trainee discusses tracking changes and comments in Excel. Program topics: Unit One: (Excel basics) Getting started with Excel. Using OneDrive in Excel. Creating and opening workbooks in Excel. Unit Two: (Formulas and functions in Excel) Simple formulas in Excel. Relative and absolute cell references in Excel. Functions in Excel. Basic tips for handling data in Excel. Unit Three: (Spell check and planning in Excel) Using find and replace in Excel. Spell check in Excel. Page layout and printing in Excel. Unit Four: (Handling data in Excel) Freezing rows and columns and splitting the worksheet in Excel. Data filtering in Excel. Charts (graphs) in Excel. Tracking changes and comments in Excel. Contents of the bag: PowerPoint 119 Trainer guide 162 Trainee guide 149 Brochure 1 Profile file 4 Activity bag 12 Mind maps 1 Images 10 Videos 8 References 2 Trainee data form 3 Bag contents 12 Training bag model Please click here to view the training bag model Training bag video

Questions you might have

‌
‌
‌‌
‌
‌
‌‌
‌
‌
‌‌
‌
‌
‌‌
‌
‌
‌‌
‌
‌
‌‌
‌