Microsoft excel 2019

Bag code: COMSO12515021 Days: 5 days "Training day 3 hours" Time: 15 training hours Targeted study groups Specialists in accounting and finance. School and university administrative staff. Students studying mathematics and accounting. Teachers specialized in dealing with accounts. Workers in all sectors in administrative and accounting work. Program objectives General goal Full knowledge of mathematical operations and methods of creating electronic and calculation tables, which relate to work in the field of engineering as a site engineer or quantity surveyor for professional invoicing, and also relate to the accounting department in creating invoices and daily and monthly reports. Detailed objectives - Advanced basic skills for Excel, and dealing with formulas. - Formatting within Excel, formatting tables, and conditional formatting. - Building reports within Excel, and how to develop them. - Using ready-made reporting tools within Excel. - Advanced functions in Excel, and how to employ them practically. - Dealing with charts in Excel, and how to create many charts. This program is divided into several main units: First unit: Excel 2019 basics (1) Getting started with Excel. Learn your way around the Excel environment. (2) Using OneDrive. Learn everything about working with your Microsoft account and OneDrive. (3) Creating and opening workbooks. Learn how to create and open Excel workbooks. (4) Saving and sharing workbooks. Learn how to save and share Excel workbooks. Second unit: Dealing with cells and sheets in Excel 2019 It consists of 8 topics: (5) Cell basics. Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use cut, copy, and paste functions. (6) Modifying columns, rows, and cells. Learn how to modify rows, columns, and cells in Excel. (7) Cell formatting. Learn everything about text formatting in Excel. (8) Number formats. Learn everything about number formatting in Excel. (9) Dealing with multiple worksheets. Learn how to add, delete, copy, and move worksheets, as well as group and ungroup sheets. (10) Using find and replace. Learn how to use the find and replace features in Excel to search for specific data. (11) Spell check. Learn how to use the spell check feature in Excel. (12) Page layout and printing. Learn how to use Excel commands that control how your content appears on the printed page. Third unit: Formulas and functions in Excel 2019 It consists of 4 topics: (13) Simple formulas. Learn how to use cell references to create a simple formula in Excel. (14) Creating complex formulas. Learn how to create a complex formula in Excel. (15) Relative and absolute cell references. Learn everything about absolute and relative cell references and how to use them in Excel. (16) Functions. Learn about the different parts of a function and how to create arguments to calculate values and cell references. Fourth unit: Dealing with data in Excel 2019 It consists of 8 topics: (17) Basic tips for handling data. Learn these basic tips to help organize data and find what you need. (18) Freezing rows and columns and splitting the worksheet. Learn how to freeze parts and split your worksheet so you only see certain parts. (19) Sorting data. Learn how to sort data to better display and organize your spreadsheet content. (20) Filtering data. Learn how to filter data in the worksheet to display only the information you need. (21) Groups and subtotals. Learn how to organize data into groups, summarize different groups using the Subtotal command, and create an outline for your worksheet. (22) Tables. Learn how to use styles to format tables in Excel. (23) Charts (graphs). Learn how to insert and modify Excel charts to visualize comparisons in your data. Fifth unit: Doing more with Excel 2019 It consists of 5 lessons: (24) Conditional formatting. Learn how to apply, modify, and delete conditional formatting rules in Excel. (25) Track changes. Learn how to use change tracking and comment features in Excel when auditing workbooks. (26) Checking and protecting workbooks. Learn how to check and protect an Excel workbook. (27) Pivot Tables basics. Learn how to use Pivot Tables in Excel for stronger data analysis. (28) Pivot Tables properties and settings. Learn how to do more with Pivot Tables to better summarize data. (29) What-if analysis. Learn how to use what-if analysis to answer different types of questions. (30) What are reference styles? Learn everything about using reference styles in Excel. (31) Using the Drawing tab. Learn how to use features available in the Drawing tab. (32) Dealing with icons. Learn how to add and customize icons. Contents of the Excel 2019 kit Brochure 1 PowerPoint 36 Profile file 4 Activity kit 4 Mind maps 1 Trainer guide 136 Trainee guide 134 Images 7 Videos 2 References 2 Trainee data form 3 Kit contents 12 Training kit form Please click here to view the training kit form Training kit video