Do you wish you could...

  • Organize your data faster, so you can analyze your results quickly

  • Save energy from the manual and repetitive tasks you do in Excel

  • Spend more time doing things that you like!

Who is this class for?

  • Scientists in academia

  • Scientists in industry

  • Graduate students working on Science MS or PhD programs

  • Anybody who wants to process data efficiently (and wants to learn a little bit about science)

Learn data processing techniques to become an Excel power user!

With science examples and applications you can relate to.

Enroll Now!

About This Course:

Course Curriculum

    1. Introduction to the Data Processing in Excel for Scientists!

    2. Download the Practice File!

    1. Quick Tip - Status Bar

    2. Lesson 1 - Introduction

    3. Lesson 2 - Deleting Columns

    4. Lesson 3 - Adjusting Column Widths

    5. Lesson 4 - Removing Duplicates

    6. Lesson 5 - Removing Blanks

    7. Lesson 6 - Removing Data Based on a Value

    8. Lesson 7 - Removing Data Based on a Logic

    9. Chapter 2: Quiz

    1. Lesson 1 - Introduction

    2. Lesson 2 - Sorting your Data

    3. Quick Tip - Numbered List

    4. Lesson 3 - Extracting Information from Text

    5. Lesson 4 - Splitting Text into Columns

    6. Lesson 5 - Formatting Numerical Values

    7. Quick Tip - Freeze Panes

    8. Lesson 6 - Hiding Columns

    9. Chapter 3: Quiz

    1. Lesson 1 - Introduction

    2. Quick Tip - Renaming Sheets

    3. Lesson 2 - Setting Up a Table

    4. Lesson 3 - Creating a Dropdown List

    5. Lesson 4 - Relative and Absolute References

    6. Lesson 5 - Introduction to VLOOKUP

    7. Lesson 6 - Using CONCAT Function with VLOOKUP

    8. Lesson 7 - VLOOKUP Function

    9. Quick Tip - IFERROR Function

    10. Lesson 8 - Introduction to INDEX & MATCH Functions

    11. Lesson 9 - INDEX & MATCH Functions

    12. Lesson 10 - Creating Pivot Tables

    13. Lesson 11 - Functionalities of Pivot Tables

    14. Chapter 4: Quiz

    15. Congratulations!

    16. Course Survey

Data Processing in Excel for Scientists

  • For only $99
  • Over 30 lessons, including practice worksheets and keyboard shortcut key card booo

Lesson Preview:


Our Commitment:

Excel in Science Guarantee

Our goal is to help you learn and grow in your career. If you are not completely satisfied, let us know within 30 days of your purchase and we'll refund you in full!


FAQ

  • When can I start the course?

    You can start the course anytime as soon as it's launched. You can take a break and continue whenever you want.

  • How long will I have access to the course after enrollment?

    You will have lifetime access to the course and all course materials! You can go back to it anytime to review.

  • Will I receive a course certificate upon completion of the course?

    Yes, you will receive a Completion Certificate at the end of the course which you can share and brag about with your friends and colleagues.


Coming soon!

Add your email to our mailing list so you don't miss out on the latest updates on our upcoming courses and discounts.

Thank You