Microsoft Excel (Beginners) Course

-

Microsoft Excel is a powerful spreadsheet software that is widely used in various industries. This course is designed to provide beginners with a solid foundation in Excel, teaching them the essential skills and techniques needed to navigate, create, format, and analyze data effectively. Through hands-on exercises and practical examples, learners will gain confidence in using Excel to solve real-world problems, make data-driven decisions, and improve productivity.

                   

Here are some specific benefits of taking this course:

  • Learn the basics of Excel, including how to create and format spreadsheets, enter and edit data, and use formulas and functions.
  • Gain hands-on experience with Excel by working on real-world projects.
  • Improve your productivity by learning how to automate tasks and use Excel to analyze data.
  • Make data-driven decisions by learning how to use Excel to create charts and graphs.
Who should take this course?

If you are interested in learning more about Microsoft Excel, this course is a great place to start. The skills you learn will be valuable in any career, and you will be able to use Excel to solve real-world problems and improve your productivity. 

Course Duration: 4 weeks (8 sessions)

 

Course Outline:

 

  1.  Introduction to Excel and Formatting Technique

  • Introduction to Microsoft Excel and its features
  • Excel interface and navigation
  • Workbook and worksheet basics
  • Entering and editing data
  • Formatting cells, rows, and columns
  • Using borders and shading
  • Conditional formatting

    2. Working with Formulas and Functions

  • Understanding cell references
  • Basic arithmetic operations
  • Common functions (SUM, AVERAGE, MIN, MAX, COUNT) and formula tools
  • Absolute and relative cell references

    3: Data Manipulation and Analysis

  • Sorting data
  • Filtering and advanced filtering
  • Using data validation
  • Data consolidation
  • Subtotaling and grouping data

    4: Working with Charts and Graphs

  • Creating basic charts (column, line, pie)
  • Modifying chart elements (titles, legends, axes)
  • Formatting chart objects
  • Using chart templates
  • Advanced charting techniques (trendlines, secondary axes)

How to gain access to the course
purchase course at selar
You would be redirected to a Telegram group where you would have virtual classes.

Comments

Post a Comment

Popular posts from this blog

Last Notes for 2023!!

-
I am not writing about data science today. Instead, I sit down to write onward plans with a heart brimming with excitement caused by the delightful meal I proudly crafted, which Mum really loved. Yes, I made it happen, and I can't help but chuckle at the achievement. Lolz.  As we stand on the threshold of 2024, my hopeful anticipation is for a year filled with everything good. I hope it takes us farther away from hell and brings us closer to a utopian state. The past months have unfolded with a myriad of speaking engagements and opportunities to influence and impact. In my two-plus years as a data analyst, this final half of the year has been marked by unprecedented deep dives into data analytics.  One resounding lesson has emerged – improvement is contingent upon setting certain foundations: Having a clear purpose, aiming for lofty goals, and actively avoiding stagnation in the hope that success will come to you. This realization is so in writing. Many admire skilled writers ...
Read more

My Data Analytics Career

-
Let me take you on a journey through my experience as a biologist and how learning data analysis, has transformed my career and outlook. It all started back in 2021, with a roommate who was always up-to-date with the latest trends. I noticed how he constantly sought to learn new things and often borrowed my laptop for his endeavors. One day, he mentioned taking courses in Python, and I couldn't help but ask why. His response, though I can't recall the exact words, intrigued me. He emphasized that Python would give me a competitive edge in the job market. That sparked my survival instinct and ignited a curiosity within me. As a biology major, I initially questioned the relevance of Python and data analysis in my field. However, driven by the desire to boost my employability and adapt to the changing landscape, I decided to explore it further. I enrolled in courses offered by IBM, earning digital certificates and gaining valuable skills along the way.  Fast forward to today, and ...
Read more

The one-size-fits-all unwitting assumptions (Part 1)

-
In the echoing chambers of research and analysis, the choice of statistical tools is not just a matter of convenience; it's a pivotal decision that can shape the very essence of our discoveries. Unfortunately, it is often in this crucial choice that many falter, unwittingly assuming that Pearson's correlation coefficient is a ‘one-size-fits-all’ solution. It is a grave misconception; a shortcut that threatens to undermine the integrity of our findings. Pearson correlation, or simply "r," is a statistical measure that quantifies the strength and direction of a linear relationship between two continuous variables. It ranges from -1 to 1, where: -1 indicates a perfect negative linear relationship (as one variable increases, the other decreases linearly). 0 indicates no linear relationship. 1 indicates a perfect positive linear relationship (as one variable increases, the other increases linearly). This means If you were to graph the data points, a linear relationship w...
Read more