Excel Essentials: Beginner to Pro
Published 4/2025
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Language: English | Duration: 2h 58m | Size: 1.4 GB

Excel mastery in formulas, Pivot Tables, lookup functions, and charts for effective data analysis.



What you'll learn
Master essential Excel functions and formulas for data analysis.
Build dynamic Pivot Tables and create insightful charts.
Utilize advanced tools like conditional formatting and data validation effectively.
Enhance productivity with proven Excel shortcuts and best practices.
Gain confidence in cleaning and organizing data for professional use.


Requirements
No prior experience required! This course is designed for beginners and professionals alike. You do not need any previous Excel knowledge. All you need is a computer with Microsoft Excel (2016 or later) and a willingness to learn. With our self-paced structure and clear instructions, you'll quickly gain confidence and proficiency. Beginners will find this course approachable, while anyone looking to brush up on their skills will enjoy the in-depth, practical examples.


Description
Welcome to our comprehensive Excel course - your ultimate guide to mastering one of the world's most versatile productivity tools! Whether you're a beginner or looking to polish your skills with advanced techniques, this course is designed to help you become proficient in Excel through hands-on exercises and real-world examples.What You'll Learn:Basic Operations & Formatting: Learn how to perform arithmetic operations, format spreadsheets for clarity, and use essential shortcuts.Lookup & Statistical Functions: Master functions such as SUM, AVERAGE, MIN, MAX, VLOOKUP, INDEX/MATCH, and XLOOKUP to analyze and interpret data.Pivot Tables & Charts: Discover how to create pivot tables for data summarization and build dynamic charts for visual analysis.Data Tools: Get comfortable with Text-to-Columns, Flash Fill, Data Validation, and Remove Duplicates to clean and structure your data.Advanced Features: Gain skills in conditional formatting, date manipulation, and protecting your Excel files.Course Features:Self-paced learning with adjustable video playback speed.Interactive exercises and real-world datasets.A dedicated Q&A section where you can ask questions and get support from instructors and fellow learners.Opportunities to provide course feedback and ratings to continuously enhance your learning experience.Join us to unlock the full power of Excel and take your data analysis skills to the next level. Enroll today and transform the way you work with data!

Who this course is for
Beginners who are looking to build a strong foundation in Excel, including basic operations, formatting, and data manipulation.
Intermediate Learners wanting to develop skills in advanced functions such as LOOKUP, Pivot Tables, conditional formatting, and more.
Students and Job Seekers aiming to acquire essential Excel skills that enhance their resumes and improve their quantitative analysis abilities.


Homepage

Excel for Legal Professionals
Released: 01/2025
Duration: 1h 51m | .MP4 1280x720, 30 fps® | AAC, 48000 Hz, 2ch | 323 MB Level: Beginner + Intermediate | Genre: eLearning | Language: English

Looking for pro tips on how to leverage Microsoft Excel as an early-career legal professional? In this course, designed for paralegals, legal assistants, and attorneys, instructor Jordan Goldmeier covers essential Excel techniques tailored for the legal profession, including data management, analysis, reporting, and automation. Gain practical skills on organizing case data, analyzing legal information, generating reports, and more. By the end of this course, you'll be prepared to apply advanced Excel features to improve your efficiency in handling legal tasks.


Homepage

Calculus 2, part 2 of 2: Sequences and series
Last updated 4/2025
Created by Hania Uscka-Wehlou,Martin Wehlou
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Level: All | Genre: eLearning | Language: English + subtitle | Duration: 273 Lectures ( 60h 36m ) | Size: 47.4 GB

Single variable Calculus: sequences and series of numbers and of real-valued functions of one real variable



What you'll learn
How to solve problems concerning sequences and series (illustrated with 378 solved problems) and why these methods work.
Various ways of defining number sequences: with help of a descriptive definition, an explicit (closed) formula, a recursive definition.
Limits of number sequences, both finite and infinite (repetition and continuation of the topic introduced in Calc1p1).
Arithmetic on extended reals (repetition and continuation of the topic introduced in Calc1p1).
Dealing with indeterminate forms (repetition and continuation of the topic introduced in Calc1p1).
Standard limits, comparing infinities (repetition and continuation of the topic introduced in Calc1p1).
Squeeze Theorem for sequences (repetition and continuation of the topic introduced in Calc1p1).
Weierstrass' Theorem for sequences (repetition and continuation of the topic introduced in Calc1p1).
Functions defined for all positive arguments and their role in examining number sequences (monotonicity, limits).
Solving recurrence relations: closed formula for linear recurrences of order two (with or without initial conditions).
Stolz-Cesàro Theorem for computing limits of indeterminate forms.
Ratio test for sequences for determining convergence or divergence.
Cauchy Theorem (convergence of the arithmetic means of a convergent sequence).
AM-GM inequality; convergence of the geometric means of a convergent sequence.
Examining the differences of consecutive terms of the sequence (a_n) for determining convergence of a_n/n.
Examining the quotients of consecutive terms of the sequence (a_n) for determining convergence of the n-th roots of a_n.
Some applications of sequences (discretisation, approximations); sequences in other courses.
Cauchy sequences and completeness of the set of real numbers; Bolzano-Weirestrass' Theorem.
Series as limits of partial sums of sequences: definition and examples.
Convergent and divergent series: simple and advanced examples.
Arithmetic and geometric series and their convergence.
p-series, their relation to p-integrals; discussion of their convergence.
Comparison criteria for series.
Integral test for series.
Ratio test for series.
Root test for series.
Sequences of real-valued functions (a very brief introduction).
Series of real-valued functions (a very brief introduction).
Power series and their radius of convergence.
Taylor polynomials and Taylor series, smooth functions.
Applications of Taylor polynomials for approximating values of functions.
Applications of Taylor polynomials for computing limits of indeterminate forms.
Sneak peek into the content of the next course (Real Analysis: metric spaces).

Requirements
Calculus 1: Limits and continuity (or equivalent)
Calculus 1: Derivatives with applications (or equivalent)
Calculus 2: Integrals with applications (or equilvalent)
You are always welcome with your questions. If something in the lectures is unclear, please, ask. It is best to use QA, so that all the other students can see my additional explanations about the unclear topics. Remember: you are never alone with your doubts, and it is to everybody's advantage if you ask your questions on the forum.

Description
Calculus 2, part 2 of 2: Sequences and seriesSingle variable calculusS1. Introduction to the courseYou will learn: about the content of this course; you will also get a list of videos form our previous courses where the current topics (sequences and series) were discussed.S2. Number sequences: a continuation from Calc1p1You will learn: more about sequences, after the introduction given in Calc1p1 (Section 5): in this section we repeat some basic facts from Calc1p1: the concept of a sequence and its limit, basic rules for computing limits of both determinate and indeterminate forms; these concepts are recalled, and you also get more examples of solved problems.S3. Weierstrass' Theorem: a continuation from Calc1p1You will learn: here we continue (after Calc1p1) discussing monotone sequences and their convergence; the main tool is Weierstrass' Theorem, also called "Monotone Convergence Theorem"; after repetition of some basic facts, you will get a lot of solved problems that illustrate the issue in depth.S4. Using functions while working with sequencesYou will learn: in this section we move to the new stuff: a functional approach to sequences, that we weren't able to study in Calc1p1, as the section about sequences came before the section about functions (in the context of limits and continuity); how to use (for sequences) the theory developed for functions (derivatives, l'Hôpital's rule, etc).S5. New theorems and tests for convergence of sequencesYou will learn: various tests helping us computing limits of sequences is some cases: Stolz-Cesàro Theorem with some corollaries, the ratio test for sequences; we will prove the theorems, discuss their content, and apply them on various examples.S6. Solving recurrence relationsYou will learn: solving linear recursions of order 2 (an introduction; more will be covered in Discrete Mathematics).S7. Applications of sequences and some more problems to solveYou will learn: various applications of sequences; more types of sequence-related problems that we haven't seen before (some problems here are really hard).S8. Cauchy sequences and the set of real numbersYou will learn: more (than in Calc1p1) about the relationships between monotonicity, boundedness, and convergence of number sequences; subsequences and their limits; limit superior and limit inferior (reading material only: Section 3.6 on pages 50-55 in the UC Davis notes); Bolzano-Weierstrass Theorem; fundamental sequences (sequences with Cauchy property), their boundedness and convergence; construction of the set of real numbers with help of equivalence classes of fundamental sequences of rational numbers; the definition of complete metric spaces.S9. Number series: a general introductionYou will learn: about series: their definition and interpretation, many examples of convergent and divergent series (geometric series, arithmetic series, p-series, telescoping series, alternating series); you will also learn how to determine the sum of series in some cases; we will later use these series for determining convergence or divergence of other series, that are harder to deal with.S10. Number series: plenty of tests, even more exercisesYou will learn: plenty of tests for convergence of number series (why they work and how to apply them): comparison tests, limit comparison test, ratio test (d'Alembert test), root test (Cauchy test), integral test.S11. Various operations on seriesYou will learn: how the regular computational rules like commutativity and associativity work for series; Cauchy product of series; remainders, their various shapes and their role in approximating the sum of a series.S12. Sequences of functions (a very brief introduction)You will learn: you will get a very brief introduction to the topic of sequences of functions; more will be covered in "Real Analysis: Metric spaces"; the concepts of point-wise convergence and uniform convergence are briefly introduced and illustrated with one example each; these concepts will be further developed in "Real Analysis: Metric spaces".S13. Infinite series of functions (a very brief introduction)You will learn: you get a very brief introduction to the topic of series of functions: just enough to introduce the topic of power series in the next section.S14. Power series and their propertiesYou will learn: the concept of a power series and different ways of thinking about this topic; radius of convergence; arithmetic operations on power series (addition, subtraction, scaling, multiplication); some words about differentiation and integration of power series term after term (optional).S15. Taylor series and related topics: a continuation from Calc1p2You will learn: (a continuation from Section 10 in "Calculus 1, part 2 of 2: Derivatives with applications") Taylor- and Maclaurin polynomials (and series) of smooth functions; applications to computing limits of indeterminate expressions and to approximating stuff.Make sure that you check with your professor what parts of the course you will need for your final exam. Such things vary from country to country, from university to university, and they can even vary from year to year at the same university.A detailed description of the content of the course, with all the 272 videos and their titles, and with the texts of all the 378 problems solved during this course, is presented in the resource file "001 List_of_all_Videos_and_Problems_Calculus_2_p2.pdf" under video 1 ("Introduction to the course"). This content is also presented in video 1.

Who this course is for
University and college students wanting to learn Single Variable Calculus (or Real Analysis)
High school students curious about university mathematics; the course is intended for purchase by adults for these students

TTC - Freelancing 101: Turning your Side Hustle into Cash
Published 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44 KHz
Language: English | Size: 1.55 GB | Duration: 2h 6m 3s | Lesson (11)

How to earn income as a freelancer, no business degree required.

This class will empower you to take your skills and monetize them as a freelancer. After this class, you will be able to identify competitors, price your services, and develop skills to network so that you can land that next deal.


Homepage