Program Overview

Program Overview

The university program focuses on developing skills in common office tools, including Word, Outlook, and Excel. The program offers various courses and modules to enhance proficiency in these areas.

Course Details

The program includes the following courses:

• Excel Live Webinar (Excel 2016)
• Excel basic module - basics of spreadsheets
• Excel advanced module - database functions and data evaluations
• VITA online course (Excel 365)

Course Modules

The program is divided into modules for beginners and advanced learners. The modules for beginners include:

• Working with Excel tables (duration: 23 min)
• Working with different diagram styles (duration: 28 min)
• Create and save workbooks (duration: 1 hour 16 minutes)
• Custom and conditional formatting (duration: 49 min)
• Insert and manipulate data (duration: 1 hour 27 min)
• Format data (duration: 1 hour 5 minutes)
• Referencing data (duration: 48 min)
• Sort and filter data (duration: 41 min)
• Create diagrams and graphics (duration: 46 min)
• Illustrate documents (duration: 38 min)
• Printing worksheets (duration: 25 min)
• Use simple formulas (duration: 58 min)
• Inserting and arranging data (duration: 49 min)
• Getting started in Excel 365 (duration: 45 min)
• Getting started with diagrams (duration: 32 min)
• Creating PivotTables and PivotCharts (duration: 46 min)
• Formatting cells and ranges (duration: 49 min)
• Share and collaborate on documents (duration: 40 min)
• Configure options and settings (duration: 37 min)
• Referencing data (duration: 27 min)
• Using visual elements (duration: 50 min)
• Ten common tools (duration: 47 min)

Advanced Modules

The program also offers advanced modules, including:

• Adjusting the configurations (duration: 44 min)
• Customize charts (duration: 41 min)
• Customize text and number formats (duration: 48 min)
• Apply custom formatting (Duration: 24 min)
• Working with data in PivotTables (duration: 31 min)
• Working with tables (duration: 43 min)
• Editing PivotTable data (duration: 44 min)
• Performing data calculations using formulas (duration: 37 min)
• Carrying out data analyzes and forecasts (duration: 36 min)
• Effective collaboration (duration: 55 min)
• Inserting PivotTables (duration: 43 min)
• Creating and editing macros (duration: 38 min)
• Creating advanced diagrams (duration: 37 min)
• Troubleshooting common problems (duration: 23 min)
• Find and analyze data with formulas (duration: 44 min)
• Solving data problems (duration: 22 min)
• Forecast and troubleshooting (duration: 40 min)
• Search and analyze information using formulas (duration: 41 min)
• Searching and grouping data (duration: 29 min)
• Managing macros (duration: 40 min)
• Use of conditional formulas (duration: 38 min)
• Using the Power Pivot add-in (Duration: 1 hr 13 min)
• Using macros (duration: 34 min)
• Using conditional formulas (duration: 37 min)