About This Course
The Microsoft Excel: Basic to Intermediate course is designed to help learners build a strong foundation in Excel while progressing to more advanced spreadsheet, analysis, and reporting techniques. Participants will learn how to create and manage workbooks, use formulas and functions, organize and analyze data, build charts, and work with tables and pivot tables. Through practical exercises and real-world scenarios, learners will develop the confidence to use Excel efficiently for business, academic, and personal productivity tasks.
Excel Fundamentals
Build a solid foundation in Excel, including worksheets, formatting, formulas, and workbook management.
Formulas & Functions
Use Excel formulas and functions to perform calculations, automate tasks, and improve accuracy.
Data Analysis
Analyze, organize, filter, and visualize data using charts, pivot tables, and Excel tools.
Workplace Productivity
Develop practical Excel skills that improve efficiency, reporting, and decision-making.
Course Curriculum
• Excel Interface Overview
• Worksheet Navigation
• Workbook Management
• Creating and Saving Workbooks
• Cell Formatting
• Data Entry Techniques
• Formulas and Cell References
• Arithmetic Calculations
• SUM Function
• AVERAGE Function
• COUNT Function
• AutoSum Features
• Cell and Range Formatting
• Number Formatting
• Font and Alignment Tools
• Working with Rows and Columns
• Sorting Data
• Filtering Data
• Creating Charts
• Chart Customization
• Conditional Formatting
• Data Validation
• Pivot Tables
• Data Visualization Techniques
• IF Functions
• AND Functions
• OR Functions
• VLOOKUP
• HLOOKUP
• INDEX/MATCH
• Date and Time Functions
• Advanced Calculations
• Working with Tables
• Managing Data Ranges
• Table Filtering and Sorting
• Subtotals
• Data Outlining
• Worksheet Protection
• Workbook Protection
Skills You'll Gain
Develop practical skills that can be applied immediately in real-world trading scenarios.
Registration & Pricing
Everything you need to know before enrolling.
Feedback
Marios Zindilis
SCP Academy was the key for me to open new doors in my career, leading me down paths I would never have thought of. Apart from Knowledge I have been taught to value persistence, to be curious and to focus on specific and timely goals, both in career as well as in life.
Marios Kairinos
I attended my first course in 2015 with the dream of becoming an IT professional. I have registered for the MCSA course and since then I have never stop learning. I have completed successfully the Azure and Office 365 courses which helped me find my dream job. Now I can ask for more and I know who can help me take them.
Evagoras Pourgourides
SCP Academy helped me learn more than I could ever imagine. The courses enriched me with knowledge and professional skills that i use in my job
Alexandros Louca
Following my passion for technology was one of the best decisions I ever made. In SCP Academy I have found and attended courses that advanced my career to the next level.
Giota Achilleos
SCP academy was the key for me to step to success. Regarding the knowledge that I gained from the university the academy offered to me more skills to succeed my goals and my dreams. SCP academy has offered to me professional courses that helped me to start my new career in Malta.
Panos Iacovides
It is never too late to make an advancement in your career and SCP Academy has helped me to achieve that. Started with the CCNA R&S Certificate and now moving on to the MCSA Certificate with more to follow. SCP Academy has also taught me that learning is a never ending process and I should make the most of it on a daily basis, making every second count. Did you know there are 86400 seconds in a day? Interesting huh?
Course Features
- Lectures 0
- Quizzes 0
- Duration 60 hours
- Skill level All levels
- Language English
- Students 10
- Assessments Yes
