Excel Course

Skills you will gain:

• Navigate and use Excel effectively
• Enter and format text, numbers, and dates
• Using basic formulas such as SUM and AVERAGE
• Create and customize charts to visualize data
• Sorting, filtering, and organizing data in worksheets
• Format cells for a neat presentation
• Using relative and absolute references in formulas
• Copy, move, and autofill data
• Customizing Print Settings for Professional Reports
• Export Excel files to various formats
• Use simple conditional formatting for better visibility
• Understand how Excel can be used for everyday tasks

Implementation time and price:

• The course has a completion time of 2 hours and 18 minutes.
• Price for NITO members NOK 2490, others NOK 3490.

Skills you will gain:

• Retrieve and integrate external data
• Perform formula auditing for accurate data processing
• Using SUM, MIN, MAX, and other functions
• Create PivotCharts for Data Visualization
• Using Data Tools for Advanced Data Analysis
• Create and customize PivotTables efficiently
• Protect and manage Excel sheets professionally
• Master complex formulas and functions in Excel
• Sort and filter large amounts of data efficiently
• Remove duplicates and group data

Implementation time and price: 

• The course has a completion time of 2 hours and 17 minutes.
• Price for NITO members NOK 2490, others NOK 3490.

Skills you will gain:

• Format Structured Data Tables
• Create and format charts
• Formatting text values for better readability
• Aligning Text and Numbers in Cells
• Embed and format images in spreadsheets
• Create and apply your own formatting rules
• Increase the readability and understanding of data
• Use number formatting for clearer data
• Apply styles for a consistent look
• Customize rows, columns, and cells

Implementation time and price:

• The course has a completion time of 2 hours and 27 minutes.
• Price for NITO members NOK 2490, others NOK 3490.

Skills you will gain:

• Prepare data for PivotTable
• Organize the data in the PivotTable
• Format PivotTables for Readability
• Understanding what a PivotTable is
• Present PivotTable results visually
• Using filters for better data analysis
• Create PivotTables in Excel
• Master Advanced PivotTable Tools
• Group data for deeper insights
• Customize PivotTables as Needed
• Analyze data for informed decisions
• Perform calculations in PivotTables

Implementation time and price:

• The course has a completion time of 56 minutes.
• Price for NITO members NOK 2490, others NOK 3490.

Skills you will gain:

• Perform basic and advanced data analysis
• Use filters to isolate specific data
• Clean and organize data for better visibility
• Understand and use the sort function effectively
• Present data in an understandable and professional way
• Using Excel functions for accurate data analysis
• Create and customize section summaries in data
• Implement advanced data management techniques
• Manage large data sets efficiently in Excel
• Optimize Excel workflows for increased productivity

Implementation time and price:

• The course has a completion time of 1 hour and 56 minutes.
• Price for NITO members NOK 2490, others NOK 3490.

Skills you will gain:

• Understand the importance of data visualization
• Using advanced hierarchy charts
• Combine different chart types efficiently
• Creating Informative Line Charts
• Visualize data with pie charts
• Present data in a professional manner
• Leveraging Excel for better insights
• Format charts for clarity
• Apply practical examples in Excel
• Create and customize bar charts
• Set up charts for printing
• Using colors and styles strategically

Implementation time and price:

• The course has a completion time of 2 hours and 44 minutes.
• Price for NITO members NOK 2490, others NOK 3490.

Skills you will gain:

• Create FINN. RAD features for efficient data lookup
• Implement INDEX functions for data ranging
• Analyze data with statistical functions and matrices
• Integrate mathematical functions into business intelligence
• Create complex lookup functions with multiple criteria
• Use advanced IF functions for complex conditions
• Understand and apply matrix formulas for advanced calculations
• Using SEARCH and SUBTEXT for Text Manipulation
• Handle large amounts of data efficiently and accurately
• Automate tasks with DO.IF and other macros
• Use date and time functions for dynamic calculations
• Optimize your workflow with various Excel tools

Implementation time and price:

• The course has a completion time of 4 hours.
• Price for NITO members NOK 2490, others NOK 3490.

If you choose the entire course package of seven courses, you get a structured and thorough training in Excel – from basic to advanced functions and methods:

1. Excel for beginners 
2. Excel for Advanced 
3. Excel Advanced Formatting
4. Excel PivotTables
5. Excel – Data Analysis 
6. Excel Data Visualization 
7. Excel for Experts 

Through the courses, you get to work practically with the same project files that the course instructor uses in teaching. This way you can test what you actually master in practice - and can practice more on what you want to get even better at.

When you have completed the entire course package, you will receive a complete course certificate that documents your competence in Excel – a valuable benefit for both your career and your studies.

Implementation time and price:

• The entire course package takes approx. 17 hours to complete.
• Price for NITO members NOK 7990, others NOK 9990.