001 18.Formatting-a-Worksheet-Exercise-Solved.xlsx
001 18.Formatting-a-Worksheet-Exercise-Unsolved.xlsx
001 18.Formatting-a-worksheet-Lecture-Solved.xlsx
001 18.Formatting-a-worksheet-Lecture-Unsolved.xlsx
001 This Is How You Can Start Formatting Your Sheets in a Professional Way
001 Useful-Tips-Tools.pdf
002 Fast Scrolling That Would Allow You to Be 3x Faster
002 Useful-Tips-Tools.pdf
003 21.Fixing-Cells-Exercise-Solved.xlsx
003 21.Fixing-Cells-Exercise-Unsolved.xlsx
003 21.Fixing-references-Lecture-Solved.xlsx
003 21.Fixing-references-Lecture-Unsolved.xlsx
003 Fixing Cell References Properly
003 Useful-Tips-Tools.pdf
004 22.Alt-Enter-Exercise-Solved.xlsx
004 22.Alt-Enter-Exercise-Unsolved.xlsx
004 22.Alt-Enter-Lecture-Solved.xlsx
004 22.Alt-Enter-Lecture-Unsolved.xlsx
004 Useful-Tips-Tools.pdf
004 Using the Alt plus Enter combination
005 23.Text-to-Columns-Exercise-Solved.xlsx
005 23.Text-to-Columns-Exercise-Unsolved.xlsx
005 23.Text-to-columns-Lecture-Solved.xlsx
005 23.Text-to-columns-Lecture-Unsolved.xlsx
005 Learn How to Organize Your Excel Data with Text to Columns
005 Useful-Tips-Tools.pdf
006 24.Wrap-Text-Exercise-Solved.xlsx
006 24.Wrap-Text-Exercise-Unsolved.xlsx
006 24.Wrap-text-Lecture-Solved.xlsx
006 24.Wrap-text-Lecture-Unsolved.xlsx
006 Useful-Tips-Tools.pdf
006 Wrapping Text in Excel
007 25.Set-Print-Area-Lecture-Solved.xlsx
007 25.Set-Print-Area-Lecture-Unsolved.xlsx
007 Create Easily Printable Documents by Using Set Print Area
007 Useful-Tips-Tools.pdf
008 26.Select-Special-F5-Exercise-Solved.xlsx
008 26.Select-Special-F5-Exercise-Unsolved.xlsx
008 26.Select-Special-Lecture.xlsx
008 Find and Select Special Types of Cells with Select Special (F5)
008 Useful-Tips-Tools.pdf
009 27.Assigning-Dynamic-Names-Exercise-Solved.xlsx
009 27.Assigning-Dynamic-Names-Exercise-Unsolved.xlsx
009 27.Dynamic-Naming-Lecture-Solved.xlsx
009 27.Dynamic-Naming-Lecture-Unsolved.xlsx
009 Learn How to Assign Dynamic Names within a Model
009 Useful-Tips-Tools.pdf
010 28.Defining-a-Named-Range-Exercise-Solved.xlsx
010 28.Naming-ranges-Lecture-Solved.xlsx
010 Excel Formulas that Make Sense - Named Ranges
010 Useful-Tips-Tools.pdf
011 Completing 33% of the course.html
012 19.Custom-formatting-after.xlsx
012 19.Custom-formatting-before.xlsx
012 Introduction to Custom Formatting
013 Assigning Custom Formats to Specific Cells (Ex. Multiples)
013 Useful-Tips-Tools.pdf
013 Useful-tips-and-tools-Excel-file.xlsx
014 30.Creating-a-Macro-Lecture-Solved.xlsx
014 30.Macros-Exercise-Unsolved.xlsx
014 Execute 50 Commands with a Single Click - Excel Macros
014 Useful-Tips-Tools.pdf
015 Create a Drop-Down List by Using Data Validation
015 Useful-Tips-Tools.pdf
016 33.Sort-data-Lecture-Unsolved.xlsx
016 Useful-Tips-Tools.pdf
016 Using Custom Sort in Order to Sort Multiple Columns within a Table
017 34.Hyperlinks-Exercise-Solved.xlsx
017 34.Hyperlinks-Exercise-Unsolved.xlsx
017 Create a Great Index Page at the Beginning of Your Financial Models
017 Useful-Tips-Tools.pdf
018 35.Freeze-Panes-Lecture-Solved.xlsx
018 35.Freeze-Panes-Lecture-Unsolved.xlsx
018 Freeze the Title Row of Your Table - Freeze Panes
018 Useful-Tips-Tools.pdf
019 Excels Tell Me Search Bar
019 Useful-Tips-Tools.pdf
019 Useful-tips-and-tools-Excel-file.xlsx
