Introduction to Microsoft Excel
Microsoft Excel is the #1 productivity software in the world. A huge amount of data comes in a spreadsheet format, so an analyst needs Excel in their arsenal. This course will teach you all the Excel skills you need to perform multi-layered calculations, create charts, manipulate data, lookup functions, and more!
Your Instructor
We create online on-demand video courses in data science. The 365 Data Science Program is comprised of different modules starting from the fundamentals (Mathematics, Probability, and Statistics), going through programming languages (Python, R, SQL) and finishing off with state-of-the-art machine and deep learning.
We have a team of experts that create the curriculum and the course content, who work closely with our talented designers to bring the concepts to life in the most engaging and understandable way using specialized animation software. We strive to make the learning experience not only all-inclusive, detailed, and thorough, but also interactive, practical, and fun.
Course Curriculum
Welcome! Course Introduction
Available in
days
days
after you enroll
-
StartWelcome!
-
StartExcel Made Easy: A Beginner's Guide to Excel Spreadsheets (3:32)
-
StartData Entry Techniques in Excel (3:00)
-
StartHow to Make Your Spreadsheets Look Professional (5:49)
-
StartInserting, Deleting, and Modifying Rows & Columns (1:44)
-
StartExcel Formulas for Beginners (2:54)
-
StartExcel Functions (3:41)
-
StartWork Efficiently by Using Cut, Copy, and Paste (2:10)
-
StartFormat Cells (5:24)
-
StartPasting Values, Formulas and Formats with Paste Special (1:16)
Microsoft Excel - Useful Tools & Tips
Available in
days
days
after you enroll
-
StartInserting a Line Break with Alt + Enter (0:49)
-
StartDo More with Your Sales Data with Excel's Text to Columns Feature (1:52)
-
StartCreate Easily Printable Excel Documents (1:11)
-
StartHow to Wrap Text in Excel and Adjust a Cell's Size (0:44)
-
StartInsert Hyperlinks into Excel Spreadsheets (1:16)
-
StartUsing Excel's Freeze Panes to Handle Large Datasets (1:12)
-
StartFind Excel Functionalities in a Quicker Way - Tell Me What You Want to Do (0:46)
-
StartA Quick Introduction to Excel's Pivot Tables (2:17)
-
StartInitial Formatting Is Key for Creating Professional-looking Spreadsheets (1:53)
-
StartMacros Are a Great Timesaver! Here's Why (2:59)
-
StartHow to Use the Same Macro On Multiple Workbooks (1:34)
-
StartThe Secret to Faster Scrolling in Excel (1:36)
-
StartBe even quicker: F5 + Enter (1:51)
-
StartUsing Absolute and Relative Cell References (2:15)
-
StartFind and Select Cells That Meet Specific Conditions (1:30)
-
StartHow to Create Dynamic Names in Excel Spreadsheets (1:22)
-
StartUsing Named Ranges to Make Formulas More Readable (1:34)
-
StartHow to Add a Drop-down List in Excel (1:49)
-
StartUsing Custom-sort to Sort Multiple Columns Within a Table (1:23)
-
StartSaving Time in Excel and Doing Everything Faster by Using Excel Shortcuts (4:15)
-
StartMultiply by 1 (1:34)
-
StartFind and Replace - References (3:03)
-
StartFind and Replace - Formatting (1:53)
-
StartGreen References (1:31)
-
StartBeauty Saving - The Professional Way of Saving Files (2:13)
-
StartThe Power of F2 (1:50)
-
StartConditional Formatting (5:40)
-
StartIntroduction to Custom Cell Formatting (6:13)
-
StartCustom Formatting - An example (1:34)
Microsoft Excel - Beginner, Intermediate & Advanced Functions
Available in
days
days
after you enroll
-
StartKey Excel Functions: If (2:35)
-
StartEnlarge the formula bar (1:03)
-
StartKey Excel Functions: Sum, Sumif, Sumifs (4:20)
-
StartKey Excel Functions: Count, Counta, Countif, Countifs (3:58)
-
StartKey Excel Functions: Average & Averageif (1:54)
-
StartKey Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate, & (4:25)
-
StartWorking with text in Excel (2:40)
-
StartFind the Highest and Lowest Values in a Range: Max & Min (0:52)
-
Start= and + are interchangeable when you start typing a formula (0:44)
-
StartUse Round in Your Financial Models (1:01)
-
StartExcel's Lookup Functions: Vlookup & Hlookup Made Easy (7:42)
-
StartIndex, Match, and Their Combination - The Perfect Substitute for Vlookup (7:27)
-
StartUsing Excel's Iferror Function to Trap Spreadsheet Errors (1:43)
-
StartA Useful Tool for Financial Analysis - The Rank Function (2:36)
-
StartCreate Flexible Financial Models with Choose (2:24)
-
StartGoal Seek Will Help You Find the Result You Are Looking For (2:17)
-
StartPerform Sensitivity Analysis with Excel's Data Tables Functionality (4:05)