Gaussian Sale: Half off annual subscriptions. Save 50% now.

828 matching results

  • 7
    48 min
    7-part Microsoft Office course
    Playing
    28 CQ
    Master Lookup Functions in Excel
    A 7-part course with Paula
    View course

    Have some Excel experience, but want to up your Excel formula skill level? This course helps intermediate Excel beginners to carry out complex lookup functions, including lookup formula combinations.

    with Paula

    Have some Excel experience, but want to up your Excel formula skill level? This course helps intermediate Excel beginners to carry out complex lookup functions, including lookup formula combinations.

  • 7
    82 min
    7-part Microsoft Office course
    Playing
    45 CQ
    Getting Started with Excel 2016
    A 7-part course with Trump Excel
    View course

    Excel 2016 offers many features for daily data tracking. In this course, learn how to use major features of Excel 2016 such as formulas, formatting, charting, pivot tables, and more.

    Excel 2016 offers many features for daily data tracking. In this course, learn how to use major features of Excel 2016 such as formulas, formatting, charting, pivot tables, and more.

  • 4
    38 min
    4-part Microsoft Office course
    Playing
    20 CQ
    How to Create Tables & Charts in Excel
    A 4-part course with Subject Money
    View course

    Microsoft Excel is a powerful program that’s perfect for organizing data! In this brief, beginner- to intermediate-level course, learn how to create and edit Excel tables, and format a Gantt Chart.

    Microsoft Excel is a powerful program that’s perfect for organizing data! In this brief, beginner- to intermediate-level course, learn how to create and edit Excel tables, and format a Gantt Chart.

  • 12
    42 min
    12-part Microsoft Office course
    Playing
    28 CQ
    Excel Formulas
    A 12-part course with Trump Excel
    View course

    Excel is a wonderful data organization software—if you know the functions. This comprehensive course from Trump Excel demonstrates how to use common excel functions, from “FIND” to “IF” functions.

    Excel is a wonderful data organization software—if you know the functions. This comprehensive course from Trump Excel demonstrates how to use common excel functions, from “FIND” to “IF” functions.

  • 5
    56 min
    5-part Microsoft Office course
    Playing
    31 CQ
    Using Excel 2013 for Basic Bookkeeping
    A 5-part course with Paula
    View course

    Learn how use Microsoft Excel 2013 for bookkeeping with this course from E-Learning Educators. You'll learn how to enter in daybook data, edit it, as well as sort and analyze it using built-in tools.

    with Paula

    Learn how use Microsoft Excel 2013 for bookkeeping with this course from E-Learning Educators. You'll learn how to enter in daybook data, edit it, as well as sort and analyze it using built-in tools.

  • 6
    47 min
    6-part Microsoft Office course
    Playing
    27 CQ
    How to Plan & Create Excel Spreadsheets
    A 6-part course with Geoff Hudson
    View course

    Want to build an expense-tracking spreadsheet in Excel? Learn how to plan a spreadsheet, analyze data, and display results that are easy to read, and useful for keeping your finances on track!

    Want to build an expense-tracking spreadsheet in Excel? Learn how to plan a spreadsheet, analyze data, and display results that are easy to read, and useful for keeping your finances on track!

  • 6
    21 min
    6-part Microsoft Office course
    Playing
    14 CQ
    Excel 2013 Advanced Data Techniques
    A 6-part course with SONIC Performance Support
    View course

    Want to dive into the best of Excel? In this course, SONIC Performance Support introduces intermediate to advanced data management techniques, from debugging complex formulas to creating web queries.

    Want to dive into the best of Excel? In this course, SONIC Performance Support introduces intermediate to advanced data management techniques, from debugging complex formulas to creating web queries.

  • 10
    45 min
    10-part Microsoft Office course
    Playing
    27 CQ
    How to Create a Gradebook in Excel
    A 10-part course with Todd McLeod
    View course

    With the basic Microsoft Excel knowledge introduced in this course, build a gradebook based on a course syllabus, format and customize data, and use formulas and functions to calculate grades!

    With the basic Microsoft Excel knowledge introduced in this course, build a gradebook based on a course syllabus, format and customize data, and use formulas and functions to calculate grades!

  • 11
    59 min
    11-part Microsoft Office course
    Playing
    34 CQ
    Excel Pivot Table Basics
    An 11-part course with MyExcelOnline
    View course

    In this data processing course, learn the basics of using pivot tables in Excel, from how to create and format a pivot table to how to make a dashboard using slicers and pivot charts.

    In this data processing course, learn the basics of using pivot tables in Excel, from how to create and format a pivot table to how to make a dashboard using slicers and pivot charts.

Lessons Sort By Relevance

Curios

  • FREE
    Work Daily Curio #1166
    Playing
    Free
    1 CQ
    Wrapped around Excel’s axle
    A curio with
    View curio

    Spreadsheet “bugs” are a problem for most data-crunching people. But most of them are not world-renowned Harvard economists using their Excel models to justify highly partisan theories. That’s exactly what Carmen Reinhart and Kenneth Rogoff were doing though. They released a paper that spawned a global movement to reduce national federal debt, only to realize their fundamental conclusions were based on a serious Excel blunder. In essence, they accidentally “hid” five rows in their Excel spreadsheet that contained GDP data from 5 of the 19 nations in their study. Reinhart and Rogoff’s key claim was that when countries reached a gross government debt equal to 90% of their GDP they hit a tipping point which caused annual economic growth to start decreasing every year. The Reinhart-Rogoff paper was music to the ears of “deficit hawks” around the world. It seemed to provide solid proof that national debt could reverse a nation’s growth. Except not. When Reinhart and Rogoff included the missing rows of data, the growth in countries with high government debt jumped to an extremely healthy +2.2% per year. D’oh! The data error was discovered by a graduate student at UMass Amherst whose econ professor had asked students to find a published paper and replicate it. When Herndon couldn’t replicate the same results, he went to his professor, who also failed to replicate the results. So they gathered a team at UMass to assemble a corrected version of the Reinhart-Rogoff paper, and then published it. Reinhart and Rogoff almost immediately responded, admitting the data error. But it was too late. The original Reinhart-Rogoff paper had already been used to support the 2013 US budget created by the Republican majority in the House of Representatives. The study had also already been used by the European Commission to justify major fiscal cuts and “austerity” measures. And Rogoff himself had already gone before a large panel of bipartisan economists warning of catastrophic consequences for the US economy, since it was in a 90% debt situation. Next time they could save time by just using Excel’s “goal seek” feature.

    with

    Spreadsheet “bugs” are a problem for most data-crunching people. But most of them are not world-renowned Harvard economists using their Excel models to justify highly partisan theories. That’s exactly what Carmen Reinhart and Kenneth Rogoff were doing though. They released a paper that spawned a global movement to reduce national federal debt, only to realize their fundamental conclusions were based on a serious Excel blunder. In essence, they accidentally “hid” five rows in their Excel spreadsheet that contained GDP data from 5 of the 19 nations in their study. Reinhart and Rogoff’s key claim was that when countries reached a gross government debt equal to 90% of their GDP they hit a tipping point which caused annual economic growth to start decreasing every year. The Reinhart-Rogoff paper was music to the ears of “deficit hawks” around the world. It seemed to provide solid proof that national debt could reverse a nation’s growth. Except not. When Reinhart and Rogoff included the missing rows of data, the growth in countries with high government debt jumped to an extremely healthy +2.2% per year. D’oh! The data error was discovered by a graduate student at UMass Amherst whose econ professor had asked students to find a published paper and replicate it. When Herndon couldn’t replicate the same results, he went to his professor, who also failed to replicate the results. So they gathered a team at UMass to assemble a corrected version of the Reinhart-Rogoff paper, and then published it. Reinhart and Rogoff almost immediately responded, admitting the data error. But it was too late. The original Reinhart-Rogoff paper had already been used to support the 2013 US budget created by the Republican majority in the House of Representatives. The study had also already been used by the European Commission to justify major fiscal cuts and “austerity” measures. And Rogoff himself had already gone before a large panel of bipartisan economists warning of catastrophic consequences for the US economy, since it was in a 90% debt situation. Next time they could save time by just using Excel’s “goal seek” feature.

  • FREE
    Work Daily Curio #944
    Playing
    Free
    1 CQ
    More proof Excel is the coolest program ever
    A curio with
    View curio

    Microsoft Excel is one of the most powerful programs on the planet. It can generate complex financial models, run statistical simulations, and graph just about anything. But Tatsuo Horiuchi, a Japanese artist, uses Excel to make art. Using just the AutoShapes function, Horiuchi creates stunning landscapes and portraits that appear to be painted on a canvas. Horiuchi claims he just stumbled upon this new medium as a matter of frugality—he tells reporters he only started using Excel because it was preinstalled on his computer. But it has made him a local celebrity. In 2006, he won an AutoShapes art contest, which apparently is a thing. Not bad for a 73-year old retiree who had never used Excel before. The best part about Horiuchi's art is that you can open the original XLS files on your computer (assuming you have Excel—sorry Google Sheets users) to see how the artwork was created. And Horiuchi isn't the only Excel artist. Detroit-based artist Danielle Aubert turned a daily Excel drawing exercise into a book, 16 Months Worth of Drawings in Microsoft Excel. The mathematics group Think Maths even created an application that turns any photo into pixelated art for Excel. I love nerds!

    with

    Microsoft Excel is one of the most powerful programs on the planet. It can generate complex financial models, run statistical simulations, and graph just about anything. But Tatsuo Horiuchi, a Japanese artist, uses Excel to make art. Using just the AutoShapes function, Horiuchi creates stunning landscapes and portraits that appear to be painted on a canvas. Horiuchi claims he just stumbled upon this new medium as a matter of frugality—he tells reporters he only started using Excel because it was preinstalled on his computer. But it has made him a local celebrity. In 2006, he won an AutoShapes art contest, which apparently is a thing. Not bad for a 73-year old retiree who had never used Excel before. The best part about Horiuchi's art is that you can open the original XLS files on your computer (assuming you have Excel—sorry Google Sheets users) to see how the artwork was created. And Horiuchi isn't the only Excel artist. Detroit-based artist Danielle Aubert turned a daily Excel drawing exercise into a book, 16 Months Worth of Drawings in Microsoft Excel. The mathematics group Think Maths even created an application that turns any photo into pixelated art for Excel. I love nerds!

  • FREE
    Drawing Daily Curio #89
    Playing
    Free
    1 CQ
    A curio with
    View curio

    Joseph Priestley is most famous for discovering oxygen in 1770, but he also made another equally important discovery. He figured out that the congealed sap of an India Gum tree was "excellently adapted to the purpose of wiping from paper the mark of black lead pencil." In fact, it was Priestley's description of the necessary vigorous rubbing action that gave the tree its modern name: the "rubber" tree. It proved to be a vast improvement over the then state-of-the-art eraser technology--old bread that had been de-crusted, moistened and balled up. We promise we're not making any of this up!

    with

    Joseph Priestley is most famous for discovering oxygen in 1770, but he also made another equally important discovery. He figured out that the congealed sap of an India Gum tree was "excellently adapted to the purpose of wiping from paper the mark of black lead pencil." In fact, it was Priestley's description of the necessary vigorous rubbing action that gave the tree its modern name: the "rubber" tree. It proved to be a vast improvement over the then state-of-the-art eraser technology--old bread that had been de-crusted, moistened and balled up. We promise we're not making any of this up!

  • FREE
    Humanities Daily Curio #175
    Playing
    Free
    1 CQ
    A curio with
    View curio

    BEST OF 2013 #7 - Joseph Priestley is most famous for discovering oxygen in 1770, but he also made another equally important discovery. He figured out that the congealed sap of an India Gum tree was "excellently adapted to the purpose of wiping from paper the mark of black lead pencil." In fact, it was Priestley's description of the necessary vigorous rubbing action that gave the tree its modern name: the "rubber" tree. It proved to be a vast improvement over the then state-of-the-art eraser technology--old bread that had been de-crusted, moistened and balled up. We promise we're not making any of this up!

    with

    BEST OF 2013 #7 - Joseph Priestley is most famous for discovering oxygen in 1770, but he also made another equally important discovery. He figured out that the congealed sap of an India Gum tree was "excellently adapted to the purpose of wiping from paper the mark of black lead pencil." In fact, it was Priestley's description of the necessary vigorous rubbing action that gave the tree its modern name: the "rubber" tree. It proved to be a vast improvement over the then state-of-the-art eraser technology--old bread that had been de-crusted, moistened and balled up. We promise we're not making any of this up!

  • FREE
    Mind + Body Daily Curio #405
    Playing
    Free
    1 CQ
    Bieber saves more lives
    A curio with
    View curio

    We recently learned how Justin Bieber saved countless lives by sparking a haircut trend that protected millions of teens against skin cancer. This week there was an even more dramatic Bieber lifesaving event. A Russian bear was in the process of mauling fisherman Igor Vorozhbitsyn near a fishing spot in the Republic of Yakutia when Igor's phone rang. The ringtone was set to Bieber’s song “Baby," which his daughter had downloaded as a joke. The bear, whose claws were digging into Igor's face, was so startled that he turned and fled back into the woods. Igor, badly injured, managed to use the phone to call for help... and credits Bieber with saving his life. Putting all kidding aside--well, actually, I'm finding that hard to do, so I'm just going to end it here.

    MORE FROM JUSTIN: Listen up, peeps! Today we are introducing the "Course of the Week." Each Tuesday we'll highlight one of our courses that our Curious learners are raving about. If you enroll before the following Sunday, you'll get $15 of FREE credit put in your account for future learning.

    Up first is Motion Training's Excel Essentials, one of our all-time most popular courses. If you've ever felt stupid when using Excel, or have resigned yourself to "not being a spreadsheet person," then this course will change your life. Remember, enroll before Sunday night and get $15 of Curious Credit FREE. Not bad for a $30 purchase! Click here to get a peek inside the course.
    -- jsk

    with

    We recently learned how Justin Bieber saved countless lives by sparking a haircut trend that protected millions of teens against skin cancer. This week there was an even more dramatic Bieber lifesaving event. A Russian bear was in the process of mauling fisherman Igor Vorozhbitsyn near a fishing spot in the Republic of Yakutia when Igor's phone rang. The ringtone was set to Bieber’s song “Baby," which his daughter had downloaded as a joke. The bear, whose claws were digging into Igor's face, was so startled that he turned and fled back into the woods. Igor, badly injured, managed to use the phone to call for help... and credits Bieber with saving his life. Putting all kidding aside--well, actually, I'm finding that hard to do, so I'm just going to end it here.

    MORE FROM JUSTIN: Listen up, peeps! Today we are introducing the "Course of the Week." Each Tuesday we'll highlight one of our courses that our Curious learners are raving about. If you enroll before the following Sunday, you'll get $15 of FREE credit put in your account for future learning.

    Up first is Motion Training's Excel Essentials, one of our all-time most popular courses. If you've ever felt stupid when using Excel, or have resigned yourself to "not being a spreadsheet person," then this course will change your life. Remember, enroll before Sunday night and get $15 of Curious Credit FREE. Not bad for a $30 purchase! Click here to get a peek inside the course.
    -- jsk

  • FREE
    Biology Daily Curio #575
    Playing
    Free
    1 CQ
    Zebra A/C
    A curio with
    View curio

    Do you think you know why zebras have stripes? Well you don't, and neither do evolutionary biologists. They ruled out most popular theories like camouflage years ago. So the explanation for such bold stripes has remained a mystery. But scientists might have made a breakthrough. Researchers recently compared the stripes of zebra populations in 16 regions, from eastern Africa to South Africa. They found the stripe intensity varied by population, with some having bold black and white stripes, and others having lighter and thinner stripes. After regressing the data for 30 different environmental factors, the researchers have concluded that temperature is strongly correlated with striping patterns. Warmer-climate zebras have wider and blacker stripes while zebras living in cooler temperatures have the fewest and faintest stripes. Scientists aren't sure why this correlation exists, but they suspect it has something to do with temperature regulation. Because black and white stripes heat up differently, airflow between the black and white stripes differs, creating a current of air that could be excellent for cooling. So basically they have built in A/C!

    with

    Do you think you know why zebras have stripes? Well you don't, and neither do evolutionary biologists. They ruled out most popular theories like camouflage years ago. So the explanation for such bold stripes has remained a mystery. But scientists might have made a breakthrough. Researchers recently compared the stripes of zebra populations in 16 regions, from eastern Africa to South Africa. They found the stripe intensity varied by population, with some having bold black and white stripes, and others having lighter and thinner stripes. After regressing the data for 30 different environmental factors, the researchers have concluded that temperature is strongly correlated with striping patterns. Warmer-climate zebras have wider and blacker stripes while zebras living in cooler temperatures have the fewest and faintest stripes. Scientists aren't sure why this correlation exists, but they suspect it has something to do with temperature regulation. Because black and white stripes heat up differently, airflow between the black and white stripes differs, creating a current of air that could be excellent for cooling. So basically they have built in A/C!

  • FREE
    STEM Daily Curio #667
    Playing
    Free
    1 CQ
    Squinting clearly
    A curio with
    View curio

    Squinting really does improve our vision. One reason is that squinting changes the shape of our eyes slightly, allowing light to focus more accurately on our retinas. But the real explanation is that our eyes operate just like a camera. Instead of film in the back of a camera, we have retinas in the back of our eyes. And, just like a camera, the smaller the aperture (opening allowing light through), the larger the depth of field (portion of the image in focus that is projected on the film/retina). This is because a narrower opening allows less light in, increasing the percentage of visible photons that will be sharply in focus. Since the lenses in our eyes malform as we age, our natural vision begins to have a shorter focal range, making the need for squinting greater. You can test this yourself. Make a tiny hole with your forefinger and thumb, and then look through the hole at an object across the room. The object you are looking will appear less blurry, especially if you are older. Check out an excellent video explaining all of this by clicking below. It will make things much clearer!

    with

    Squinting really does improve our vision. One reason is that squinting changes the shape of our eyes slightly, allowing light to focus more accurately on our retinas. But the real explanation is that our eyes operate just like a camera. Instead of film in the back of a camera, we have retinas in the back of our eyes. And, just like a camera, the smaller the aperture (opening allowing light through), the larger the depth of field (portion of the image in focus that is projected on the film/retina). This is because a narrower opening allows less light in, increasing the percentage of visible photons that will be sharply in focus. Since the lenses in our eyes malform as we age, our natural vision begins to have a shorter focal range, making the need for squinting greater. You can test this yourself. Make a tiny hole with your forefinger and thumb, and then look through the hole at an object across the room. The object you are looking will appear less blurry, especially if you are older. Check out an excellent video explaining all of this by clicking below. It will make things much clearer!

  • FREE
    Photography Photo Curio
    Playing
    Free
    1 CQ
    Horseman in the mist
    A curio with
    View curio

    Choo! That's "giddy up!" in Mongolian. A Mongol rider races his herd at Saihanba National Forest Park, near China's Inner Mongolia. Hong Kong-based photographer Anthony Lau captured spotted the rider emerging from the mist at dusk with a telephoto lens. Evaporating body heat in the -20°F weather further enhances the drama of the cinematic moment and makes the rider seem like one with his horses. This isn't too far from the truth, as Mongols are some of the world's best horsemen, and regard the animals as vital to daily life in the autonomous region. Don't be fooled by their small size; the Mongolian steeds possess excellent endurance for long rides, impressive strength for carrying more than their body weight, and tenacity for racing. It's unclear which horse won this particular contest, but Lau was definitely a winner: his adrenaline-packed image earned him the grand prize in the 2016 National Geographic Travel Photographer of the Year Contest.
     
    Image credit & copyright: Anthony Lau
     

    with

    Choo! That's "giddy up!" in Mongolian. A Mongol rider races his herd at Saihanba National Forest Park, near China's Inner Mongolia. Hong Kong-based photographer Anthony Lau captured spotted the rider emerging from the mist at dusk with a telephoto lens. Evaporating body heat in the -20°F weather further enhances the drama of the cinematic moment and makes the rider seem like one with his horses. This isn't too far from the truth, as Mongols are some of the world's best horsemen, and regard the animals as vital to daily life in the autonomous region. Don't be fooled by their small size; the Mongolian steeds possess excellent endurance for long rides, impressive strength for carrying more than their body weight, and tenacity for racing. It's unclear which horse won this particular contest, but Lau was definitely a winner: his adrenaline-packed image earned him the grand prize in the 2016 National Geographic Travel Photographer of the Year Contest.
     
    Image credit & copyright: Anthony Lau
     

  • FREE
    World History Photo Curio
    Playing
    Free
    1 CQ
    Dances with bears
    A curio with
    View curio

    These suits are a real bear. A bearskin-clad young girl looks tired in a furry procession during the recent New Year's "bear dance" festival in Comanesti, Romania. According to legend, the animal brings good luck, health, and protection to the village. Each year, throngs dress up in red-tasseled bearskins and dance and march through town, chasing out evil spirits and ushering in a bountiful spring. In the old days, local gypsies, or Roma, would arrive into town from their forest homes with real bears in tow. Jovial reveling would follow, with the animals made to stand on hot metal plates and "dance" for townsfolk. Some spectators would even pay to have a bear cub walk up and down their backs as a cure for aches. The present-day festival is more humane, though the bearskins are real—and cost up to $2,200 each. Whether or not you believe in the bearskins' ability to ward off evil, one thing's for sure: they do an excellent job of warding off the winter chill.
     
    Image credit & copyright: Vadim Ghirda/AP
     

    with

    These suits are a real bear. A bearskin-clad young girl looks tired in a furry procession during the recent New Year's "bear dance" festival in Comanesti, Romania. According to legend, the animal brings good luck, health, and protection to the village. Each year, throngs dress up in red-tasseled bearskins and dance and march through town, chasing out evil spirits and ushering in a bountiful spring. In the old days, local gypsies, or Roma, would arrive into town from their forest homes with real bears in tow. Jovial reveling would follow, with the animals made to stand on hot metal plates and "dance" for townsfolk. Some spectators would even pay to have a bear cub walk up and down their backs as a cure for aches. The present-day festival is more humane, though the bearskins are real—and cost up to $2,200 each. Whether or not you believe in the bearskins' ability to ward off evil, one thing's for sure: they do an excellent job of warding off the winter chill.
     
    Image credit & copyright: Vadim Ghirda/AP
     

Get started!
Save
Complete your purchase

Please show this teacher your appreciation:

Leave comment
Love this lesson
Tip $1
Tip $2
Tip $5
500 characters left
Thank You
Thank you for your generosity!
No thanks
Continue
Whoops!
Your free trial of Curious+ has expired