inline-defaultCreated with Sketch.

This website uses cookies to ensure you get the best experience on our website.

Students
Tuition Fee
GBP 595
Per course
Start Date
Medium of studying
Duration
2 months
Program Facts
Program Details
Degree
Courses
Major
Data Analysis | Data Analytics | Computer Programming
Area of study
Information and Communication Technologies
Timing
Full time
Course Language
English
Tuition Fee
Average International Tuition Fee
GBP 595
About Program

Program Overview


This intermediate-level Python course empowers participants to manipulate and automate data on spreadsheets. Through hands-on exercises, they'll master Python libraries for data manipulation, Excel automation, and Google Sheets integration. The program is taught by an experienced instructor in small groups, fostering personalized attention and interactive learning. Upon completion, participants will receive a certificate and be equipped for careers in data analysis, business intelligence, and automation.

Program Outline


Spreadsheet Data Analysis and Automation with Python: A Detailed Extraction


Degree Overview:


Objective:

This intermediate-level course is designed for individuals familiar with basic Python who are interested in manipulating and automating data on spreadsheets. Participants will explore various Python libraries and frameworks, enabling them to work efficiently with Excel and Google Sheets.


Description:

Through this course, participants will gain the ability to:

  • Install and utilize Python libraries: Master the installation and application of libraries like Pandas, NumPy, openpyxl, xlsxWriter, and others for efficient data manipulation.
  • Control Excel with Python: Learn how to use OpenPyXL to manipulate data within Excel files and formats, including cell data, worksheets, charts, and more.
  • Automate Excel tasks: Enhance your productivity by automating repetitive tasks in Excel using xlWings, leveraging similar functionalities as in VBA.
  • Work with Google Sheets: Discover how to use Python to access and manipulate data within Google Sheets, allowing for greater flexibility and collaboration.

Outline:


Course Structure:

  • Weekly sessions: The program consists of 10 weekly evening sessions, delivered over one term.
  • Flexibility: Participants can choose to attend the course either in person or online, depending on their preference.

Course Content:

  • Review of Python basics: Refresh your understanding of fundamental Python concepts, including data structures and documentation.
  • Installing libraries: Learn how to install and utilize various Python libraries, including Pandas, NumPy, openpyxl, and more.
  • Data manipulation: Explore techniques for manipulating data using libraries like NumPy and Pandas, including data structures, functions, slicing, summary functions, and more.
  • File handling: Gain proficiency in interacting with files and operating systems using the Python `os` library.
  • Data import and export: Learn how to import and export data from various formats, including Excel files, CSV files, and exporting to HTML.
  • Excel object model: Understand the Excel object model and how to replicate Excel and VBA functionality using Python.
  • Pivot tables and charts: Discover how to create and manipulate pivot tables and charts using Python libraries like Matplotlib.
  • Virtual environments: Learn how to manage virtual environments using tools like Anaconda, ensuring project isolation and dependency management.
  • Automating Excel and Office: Explore the automation of Excel and other Office applications using xlWings and win32.com, streamlining repetitive tasks.
  • Working with Google sheets: Discover how to interact with Google Sheets using Python, enabling data access, manipulation, and analysis.

Assessment:

  • Certificate: Participants who attend over 70% of the classes will receive an official City, University of London certificate.
  • Informal assessment: Ongoing assessment will occur through class discussions, activities, and question-and-answer sessions facilitated by the tutor.

Teaching:

  • Experienced instructor: The course is taught by Sean Walsh, a professional with over 20 years of experience in Excel, VBA, and Python instruction.
  • Small groups: The course is delivered in small groups, allowing for personalized attention and interaction.
  • Interactive approach: The learning environment encourages active participation through discussions, activities, and hands-on exercises.

Careers:

Completing this program can open doors to various career paths, including:

  • Data analysts
  • Business intelligence specialists
  • Automation developers
  • Financial analysts
  • Researchers

Other:

  • The course is designed to be accessible for individuals with varying levels of experience.
  • Participants should be comfortable with basic programming concepts and installation of software.
SHOW MORE
About University
PhD
Masters
Bachelors
Diploma
Foundation
Courses

City University of London


Overview:

City, University of London is a public research university located in London, England. It is known for its focus on business, practice, and the professions, offering a wide range of undergraduate and postgraduate programs. The university is renowned for its strong academic reputation and its commitment to providing students with a high-quality learning experience.


Services Offered:

City University of London provides a comprehensive range of services to its students, including:

    Library Services:

    Access to extensive library resources, including books, journals, databases, and online resources.

    Moodle:

    An online learning platform for accessing course materials, submitting assignments, and communicating with instructors.

    Email:

    A university-provided email account for official communication.

    Staff Directory:

    A searchable directory of staff members and their contact information.

    Term Dates:

    Information on the academic year and term dates.

    Room Booking:

    A system for booking rooms on campus for meetings, events, and other purposes.

    Schools and Departments:

    Information on the various schools and departments within the university.

Student Life and Campus Experience:

City University of London offers a vibrant and diverse student experience, with a strong emphasis on:

    London Experience:

    The university's location in London provides students with access to a wide range of cultural, social, and professional opportunities.

    Sports:

    A variety of sports clubs and facilities are available for students to participate in, both competitively and non-competitively.

    Social Activities and Groups:

    Numerous student societies and groups cater to diverse interests, providing opportunities for social interaction and personal development.

    Student Wellbeing:

    The university offers a range of support services to ensure students' health and wellbeing, including learning support, personal tutoring, and counseling.

    Career Development:

    The university provides career guidance and support services to help students prepare for their future careers.

Key Reasons to Study There:

    Strong Academic Reputation:

    City University of London is consistently ranked highly in national and international rankings.

    Focus on Business, Practice, and the Professions:

    The university's programs are designed to provide students with the skills and knowledge they need to succeed in their chosen careers.

    Location in London:

    The university's location in the heart of London provides students with access to a wealth of opportunities.

    Vibrant Student Life:

    City University of London offers a diverse and engaging student experience.

    Excellent Career Support:

    The university provides comprehensive career guidance and support services.

Academic Programs:

City University of London offers a wide range of academic programs across various disciplines, including:

    Business and Management:

    Bayes Business School is renowned for its programs in finance, accounting, marketing, and entrepreneurship.

    Law:

    The City Law School is a leading institution for legal education, offering programs in law, international law, and legal practice.

    Health and Psychological Sciences:

    The School of Health & Psychological Sciences offers programs in nursing, midwifery, psychology, and other health-related fields.

    Science and Technology:

    The School of Science & Technology offers programs in computer science, engineering, mathematics, and other STEM fields.

    Communication and Creativity:

    The School of Communication & Creativity offers programs in journalism, media, performing arts, and language studies.

Other:

    Merger with St George's:

    City University of London has merged with St George's, University of London, forming a new institution called City St George's, University of London.

    Awards and Accreditations:

    The university has received numerous awards and accreditations for its teaching, research, and commitment to equality and diversity.

    Global City:

    City University of London is a global institution with a strong international presence.

    University of London:

    City University of London is a member of the University of London, a federation of 18 independent colleges and institutes.

Total programs
427
Location
Ambassadors
How can I help you today?