Menu Close

Our Training - Introduction to Data Analysis

This course is designed to provide you with basic working knowledge for using Excel spreadsheets for Data Analysis. It covers some of the first steps for working with spreadsheets and their usage in the process of analyzing data. It includes plenty of videos, demos, and examples for you to learn, followed by step-by-step instructions for you to apply and practice on a live spreadsheet. Excel is an essential tool for working with data - whether for business, marketing, data analytics, or research. This course is suitable for those aspiring to take up Data Analysis or Data Science as a profession, as well as those who just want to use Excel for data analysis in their own domains. You will gain valuable experience in cleansing and wrangling data using functions and then analyze your data using techniques like filtering, sorting and creating pivot tables. This course starts with an introduction to spreadsheets like Microsoft Excel and Google Sheets and loading data from multiple formats. With this introduction you will then learn to perform some basic level data wrangling and cleansing tasks and continue to expand your knowledge of analyzing data through the use of filtering, sorting, and using pivot tables within the spreadsheet. By performing these tasks throughout the course, it will give you an understanding of how spreadsheets can be used as a data analysis tool and understand its limitations.

Training hours

  • Weekday Session

    Monday: 8:00pm - 10:00pm
    Wednesday: 8:00pm - 10:00pm

  • Weekend Session

    Saturday: 7:00pm - 9:00pm
    Sundays : 5:00pm - 7:00pm

We are here

  • 24/7 Online - Virtual Classrom Training
  • Phone: +233 50 078 4867 / +233 54 267 0177
  • Email: trainings@seltechghana.com

    • OUR LEAD INSTRUCTORS

    REGISTER COURSE HERE

    Trainee will have access to the following After Payment:

    • Our Free Online Zoom Classroom

    • Training Materials 

    • International Certification on Course from IBM and CFI- Canada

    • Free Prep Exams to Pass IBM Certificate

    • Free Prep Exams to Pass CFI Certificate

    • Recorded Class video

    • Free Application Guide on Cousera and Financial Aid Support Letter.  

    This paid Excel tutorial is perfect for beginners, intermediate, and even advanced users.  The tutorial starts off with the very basics, but the training quickly advances so even power users will learn something new and have a great refresher. Learn industry-leading best practices. This Excel course is based on real investment banking training programs at global banks. The quality of instruction you receive in this course will have you just as sharp as if you took an expensive, live Wall Street course.

    Learn from the very best

    Join our course and start building the most wanted career available today. We make sure every class is easily understood, and that all students reach the same level of expertise needed for today’s hi-tech industry.

    Course Outline

    • Download files – Excel template and course notes
    • Layout overview
      Workbooks, worksheets, cells, & formula bar
    • The ribbon – home
      The ribbon- insert page, layout, formulas, data review, view, help
      Keyboard shortcuts to navigate the ribbon
    • Excel settings overview
    • Excel general settings
    • Excel formulas settings
    • Excel data proofing, save language, ease of access settings
    • Excel advanced settings, customize ribbon, quick access toolbar
    • Excel add-ins
      [Optional] Macabacus Excel Add-in
    • Format background, special numbers, column width
    • [Optional] Special Formatting Using Macabacus
    • Page break preview, orientation, freeze panes
    • Paste special, format numbers, subtotals
      Font colors with paste special
    • [Optional] Autocolor and Blue-Black Toggle Using Macabacus
    • Assumptions, percentages, decimal places
      Fill right, borders, view gridlines

    Career Opportunities

    •  You get a lot of job opportunities if you study WordPress.
    • You can become a WordPress Specialist in an organization.
    • After taking this certification course of the WordPress module, you can become a WordPress Developer. 
    • You can become a Functional Consultant.
    • You can become an application Consultant, either freelancing or in an organization.
    • You can become an Advisory Consultant.
    • You can become a Manager of a business, whether it’s your personal business or an organization
    • You can become a WordPress Developer, after finishing this module and getting certified.
    • You can become a WordPress Functional Consultant for an organization.
    • You can become a team leader in an organization and be responsible for managing production planning.
    • You can become a WordPress Development Trainer.
    • You can become a senior WordPress Developer commanding high pay.  

    Course objectives

    After completing the class, you will have:

    • Describe the fundamentals of spreadsheet applications 
    • Applicant will also have access to our online Meeting Room for training and discussions.
    • Employ data quality techniques to import and clean data in Excel.
    • Perform basic spreadsheet tasks including navigation, data entry, and using formulas.
    • Analyze data in spreadsheets by using filtering, sorting, look-up functions, and pivot tables.
    • Manage Data Validations
    • Cleaning & Wrangling Data Using Spreadsheets
    • Analyzing Data Using Spreadsheets
    %d bloggers like this: