-
Microsoft Project
- Project Cheat Sheet
- Resource Files
- What is Microsoft Project
- The Project Interface
- Project Management Phases
- Create a new Project Plan
- Create a Project Calendar
- Creating Project Tasks
- Placeholder Text and Task Types
- Create Work Breakdown Structure
- Define Task Relationships
- Tying Up Loose Ends
- Add Resources to Project Plan
- Creating a Resource Calendar
- Assign Resources to Tasks
- Resolve Resource Conflicts
- Optimize the Project Plan
- Cost of the Project
- Adding Additional Resources
- Setting a Baseline
-
Microsoft SharePoint
- SharePoint Cheat Sheet
- What is SharePoint
- SharePoint Look Book
- Getting SharePoint and Home Page Overview
- Create a New Team Site in SharePoint
- Team Site Home Page in SharePoint
- Uploading Files in SharePoint
- Creating a New List in SharePoint
- Adding Web Parts in SharePoint
- Reorganizing and Customizing Web Parts in SharePoint
- Republish Team Site in SharePoint
- Add Members to Team Site in SharePoint
- Teams and Sharepoint Integration
- Create a New Communication Site in SharePoint
- Add Countdown Timer Web Part in SharePoint
- Edit Web Part Layouts in SharePoint
- Edit Sections in SharePoint
- Add Youtube Web Part in SharePoint
- Change Page Look and Editing Navigation in SharePoint
- Create a News Post in SharePoint
- Manage Site Access in SharePoint
-
Microsoft Power Apps
- Power Apps Cheat Sheet
- How to access Power Apps
- Create Excel Data Source in Power Apps
- Creating the Power App
- Previewing the Power App
- Tree View in Power Apps
- Edit Properties in Power Apps
- Insert New Item in Power Apps
- Insert New Screen in Power Apps
- Actions in Power Apps
- Additional Options in Power Apps
- Save and Distribute the Power App
- Mobile Power App
-
Microsoft Power Automate
- Power Automate Flows Cheat Sheet
- Accessing Power Automate
- First Power Automate Template Flow
- Test run your first Power Automate Flow
- My Power Automate Flows
- Power Automate Templates Overview
- Power Automate Connectors Overview
- Different Power Automate Flow Types
- Create a Power Automate Flow from scratch
- Test run your New Power Automate Flow
- Book Order Tracker Power Automation - Introduction
- Book Order Tracker Power Automation
-
SQL
- SQL Cheat Sheet
- Resource Files
- 01 - What You Will Learn in this SQL course
- 02 - All About SQL
- 03 - Setting Up Your SQL Training Ground
- 04 - SQL Data Manipulation
- 04 - Running the Initial SQL File
- 05 - Simple SQL Queries
- 06 - Simple SQL Queries (exercise)
- 07 - Advanced Simple SQL Queries
- 08 - Advanced Simple SQL Queries (exercise)
- 09 - SQL Joins
- 10 - SQL Joins (exercise)
- 11 - SQL Subqueries
- 12 - SQL Subqueries (exercise)
- 13 - More SQL Examples and Exercises!
-
Beginner - Introduction
-
-
Beginner - Formatting
- Copy, Cut & Paste
- Adding & Deleting Rows or Columns
- Column Widths
- Hide & Unhide Columns
- Delete Worksheets
- Renaming Worksheets
- Move & Copy Worksheets
- Font Formatting
- Fill & Font Color
- Adding Borders
- Formatting Numbers as Currency
- Formatting Numbers as Percentage
- Format Painter
- Cell Styles
- Merge & Center
- Conditional Formatting
-
-
-
-
Intermediate - Pivot Tables
- Downloadable Workbooks
- New Intermediate Pivot Table Videos - Uploaded 02.2020
- Cheat Sheet - 5 Speedy Steps to an Excel Pivot Table
- Cheat Sheet - The Top Pivot Table Features
- Setting Up Your Data - Tabular Format
- No Gaps in your data
- Formatting your data
- Excel Tables
- Clean Your Data Set
- Inserting a Pivot Table
- Field List - Activate, move, resize & layout
- Field List & Areas
- Drill down to audit
- Sort Field List from A to Z
- Double click on any labels to show more Fields
- Defer Layout Update
- Pivot Cache explained
- Refresh a Pivot Table
- Clear Filters & Clear Pivot
- Select & format
- Move a Pivot Table
- Pivot Table Styles
- Customize Pivot Table Styles
- Pivot Table Subtotals
- Pivot Table Grand Totals
- Pivot Table Report Layouts
- Pivot Table Blank Rows
- Expand & Collapse buttons
- Move & Remove Fields and Items
- Show/Hide Field List
- Show/Hide Field Headers
- Change Count of to Sum of
- Number formatting
- Field name formatting
- Change Sum views in Label Areas
- Indent rows in compact layout
- Change the layout of a report filter
- Format error values
- Format empty cells
- Printing a pivot table on two pages
- Show Report Filter on multiple pages
- Create multiple subtotals
- Count
- Average
- Maximum
- Minimum
- Product
- Count Numbers
- Show Various Grand Totals
- Shortcuts to access Value Field Setting & Summarize Values By
- Percentage of Grand Total
- Percentage of Column Total
- Percentage of Row Total
- Percentage Of
- Difference From
- Percentage Difference From
- Running Total In
- Percentage Running Total In
- Shortcuts to Show Values As
- CASE STUDY: Actual v Plan Variation
- Group by Days
- Group by Months
- Group by Quarters & Years
- Group by Sales ranges
- Group by Text fields
- Group by Time
- Filter by Dates
- Filter by Labels - Text
- Filter by Labels - Numerical Text
- Filter by Values
- Filter by Values - Top or Bottom 10 Items
- Filter by Values - Top or Bottom Percent
- Filter by Values - Top or Bottom Sum
- Filter by Report Filter
- Insert a Slicer
- Slicer Styles
- Slicer Settings
- Slicer Size & Properties
- Slicer Connections for multiple pivot tables
- Different ways to filter a Slicer
- CASE STUDY: Select a Monthly Profit & Loss Report with a Slicer
- Creating a Calculated Field
- Use an existing Calculated Field in a new calculation
- Editing a Calculated Field
- Excel Formulas and Calculated Fields
- Creating a Calculated Item
- Use an existing Calculated Item in a new calculation
- Editing a Calculated Item
- Excel Formulas and Calculated Items
- Calculated Item on Column Labels
- Shortcomings of Calculated Items
- CASE STUDY: Actuals v Plan with Calculated Fields
- Insert a Pivot Chart
- Insert a Slicer with a Pivot Chart
- Pivot Chart Designs
- Pivot Chart Layouts
- Pivot Chart Formats
- Limitations of Pivot Charts & Workarounds
- Saving a Pivot Chart template
- Printing a Pivot Chart
- Include a Sparkline with your Pivot Table
- CASE STUDY: Pivot Table Slicer and Chart Dashboard
-
-
Intermediate - Analysis
- Convert Text Dates to Excel Dates with Text To Columns
- Regional Dates with Text To Columns
- Remove Emails from Names with Text To Columns
- Split Full Names with Text To Columns
-
-
Advanced - Formulas
- Course Intro
- Relative Cell References
- Absolute Cell References
- Variations on Absolute References
- Name Ranges
- Nesting Functions
- Course Intro
- What are Arrays?
- Nesting Array Formulas
- Using Arrays to SUM Data
- Streamline Conditions Using Arrays
- Course Intro
- Creating a Dynamic SUM() Using INDEX() - Part 1
- Creating a Dynamic SUM() Using INDEX() - Part 2
- Combine Multiplication with INDEX() and MATCH() - Part 1
- Combine Multiplication with INDEX() and MATCH() - Part 2
- Create a Dynamic VLOOKUP() with MATCH() - Part 1
- Create a Dynamic VLOOKUP() with MATCH() - Part 2
- Create a Dynamic VLOOKUP() with MATCH() - Part 3
- Turn INDEX() and MATCH() into an ARRAY - Part 1
- Turn INDEX() and MATCH() into an ARRAY - Part 2
- Returning Multiple Values with INDEX() - Part 1
- Returning Multiple Values with INDEX() - Part 2
- Returning Multiple Values with INDEX() - Part 3
- Returning Multiple Values with INDEX() - Part 4
- Adding Criteria to INDEX() and MATCH() - Part 1
- Adding Criteria to INDEX() and MATCH() - Part 2
- Return an Associated Value Using INDEX() and MATCH() - Part 1
- Return an Associated Value Using INDEX() and MATCH() - Part 2
- Conditional Formatting Using MATCH() - Part 1
- Conditional Formatting Using MATCH() - Part 2
- CLEAN - Intro
- FIND - Intro
- MID - Extract Numbers Between Hyphens
- PROPER - Intro
- REPLACE - Intro
- REPLACE - Phone Area Codes
- REPLACE - Insert Hyphens In Your Serial Number
- REPLACE - Extract Last Name
- REPLACE - Clear Everything Before the Hyphen
- REPLACE - Insert New Code within Old Part Numbers
- SUBSTITUTE - Intro
- SUBSTITUTE - Add a Comma after the Surname
- SUBSTITUTE - Remove Second Hyphen
- SUBSTITUTE - Count Text Occurrences in a Cell
- SUBSTITUTE - Report Name
- TEXT - Intro
- TRIM - Intro
- VLOOKUP - A TAX TABLE WITH APPROXIMATE MATCH
- VLOOKUP - SUM MULTIPLE COLUMNS WITH DATA VALIDATION DROP DOWN MENUS
- VLOOKUP - MULTIPLE CRITERIA
- FILTER
- LAMBDA
- LET
- RANDARRAY
- SEQUENCE
- SORT
- SORTBY
- UNIQUE
- XLOOKUP
- XLOOKUP - More Examples
- How to use the XLOOKUP function in Excel with 7 Examples!
- LAMBDA Function in Excel - Create Custom Functions in Excel
-
Advanced - Pivot Tables
- Refresh All
- Refresh External Data
- Import from Access database
- Change Data Source
- Use a customized style in another workbook
- Show the Classic Pivot Table Layout
- Predetermined number formatting
- Keep Column Widths upon Refresh
- Automatically Refresh a Pivot Table
- StdDevp - Standard Deviation Population
- VarP - Variance Population
- See all Pivot Items
- Show a unique or distinct count in a Pivot Table
- Percentage of Parent Row Total
- Percentage of Parent Column Total
- Percentage of Parent Total
- Rank Smallest to Largest
- Rank Largest to Smallest
- Index
- CASE STUDY: Percentage of Revenue Margins
- Shortcuts to Grouping
- Group by Half Years
- Group by a Date that starts on a Monday
- Grouping by a custom date
- Grouping by a Fiscal Year and Quarter
- Errors when Grouping by Dates
- Group 2 Pivot Tables in the same Workbook
- Fixing the problem of counting Grouped sales
- Display dates that have no data
- CASE STUDY: Quarterly Comparative Report
- CASE STUDY: Min and Max Bank Balance Report
- Override a Custom List sort
- Sort row from A-Z and sales from Z-A
- Sort new Items added to your data source
- Clear a sort
- Sort Largest to Smallest Grand Totals
- Shortcuts to filters
- Keep or hide selected items
- Filter by Text wildcards
- Filter by multiple fields
- Apply multiple filters
- Filter by multiple values
- Include new Items in manual filter
- Clear filters with one click
- Add a filter for the column items
- CASE STUDY: Top 5 Expense Report
- CASE STUDY: Top 25 Percent of Channel Partners
- Creating a custom Slicer style
- Copy a custom Slicer style into a new workbook
- Use one Slicer for two pivot tables
- Lock the workbook but not the Slicer
- Interactive employee photos with Slicers!
- CASE STUDY: Base, Best and Worst Case Slicer Forecast
- Solve Order for Calculated Items
- List Calculated Field & Item formulas
- Remove a Calculated Field temporarily
- Order of operations
- CASE STUDY: Creating a Profit & Loss Pivot Table Report
- Shortcuts to formatting a Pivot Chart
- Link a Pivot Chart title to a pivot cell
- Copy a second Pivot Chart
- Put a Pivot Chart on a separate page with F11
- Insert Pivot Chart straight from the data source
- Paste Pivot Chart to your email as a picture
- Paste a Pivot Chart to PowerPoint & make live updates
- Chart Do's and Dont's
- Use Slicers to change Chart types
- Pivot Chart workaround to creating an interactive Scatter graph
- CASE STUDY: Profit & Loss Pivot table Report with Graphs
- Conditionally Format only cells that contain - For Bonuses
- Conditionally Format only Top or Bottom ranked values - Top 3 sales per year
- Conditionally Format values that are above or below the average - For Promotions
- Use a formula to determine which cells to Conditionally Format
- Use selected cells to Conditionally Format multiple fields
- All cells showing values to Conditionally Format multiple fields
- Control Conditional Formatting with Slicers
- Show Text in the Pivot Table Values area with Conditional Formatting
- Conditionally Formatting Blank Cells
- CASE STUDY: Accounts Receivable Ageing Report Matrix
- Intro to GETPIVOTDATA
- Create a custom report with GETPIVOTDATA
- Reference Dates with GETPIVOTDATA
- Data Validation with GETPIVOTDATA
- Shortfalls of GETPIVOTDATA
- Grand Totals to the left of the Pivot Table
- CASE STUDY: Live forecasting with GETPIVOTDATA
- CASE STUDY: Channel analysis with GETPIVOTDATA
- Adding the Developer Tab
- Record a simple Macro to Refresh a Pivot Table
- Date Filter Macro
- Different Pivot Table views Macro
- Top 10 Macro
- Add Macro to Quick Access Toolbar
- Reducing file memory by copying existing Pivot Table
- Reducing file memory by deleting the data source
- Reducing file memory by saving file as XLSB
- Reducing file memory by keeping data in Access
- Compatibility Issues with Excel 2007 and Excel 2010
- Sharing a Pivot Table via OneDrive
- Frequency Distribution with a Pivot Table
- Interactive Balance Sheet Pivot Table
- Sales Forecasting with Calculated Fields
- Consolidate with a Pivot Table
- Break Even Model with a Pivot Table
- Several Slicer custom styles for you to use
- Monthly Sales Manager Performance
- Reconciling customer payments
-
Advanced - Power Pivot
- Download Workbooks - 1. IMPORT/LOAD DATA
- Download Workbooks - 2. TABLE RELATIONSHIPS
- Download Workbooks - 3. PIVOT TABLES & SLICERS
- Download Workbooks - 4. MEASURES & CALCULATED COLUMNS
- Power Pivot Cheat Sheet
- Power Pivot Cheat Sheet
- [JULY 2018 UPDATE] Power Pivot is now available in all versions of Excel
- Installing Power Pivot in Excel 2010
- Download Link for Power Pivot in Excel 2010
- Enabling Power Pivot in Excel 2013, 2016, 2019 and Office 365
- Intro to DAX Formulas
- Intro to DAX Formulas: Measures vs Calculated Columns - Part 1
- Intro to DAX Formulas: Measures vs Calculated Columns - Part 2
- DAX Syntax
- Date and Time Functions
- Time Intelligence Functions
- Filter Functions
- Information Functions
- Logical Functions
- Math and Trig Functions
- Statistical Functions
- Text Functions
- Other Functions
- DISTINCTCOUNT() - Create a "Unique Order Dates" Measure
- SUM() - Create a "Total Sales" Measure
- Combine 2 Measures to get "Average Sales Per Date"
- CALCULATE() - Filter & Show Individual Product Sales
- CALCULATE() - Show Largest Sales Values
- Calculated Column - Extract Years from Order Date
- CALCULATE() - Group Years
- Link a Calendar Table
- Sort Month Dates Into The Correct Order
- Add a Hierarchy to the Calendar
- Combine a Calculated Column with a Measure - Net Profit Analysis
-
Advanced - Power Query
- Download Workbooks
- Power Query Cheat Sheet - Getting Started with Power Query
- Power Query Cheat Sheet - M Functions
- Introduction
- Query Editor Overview
- Excel 2010 & 2013 Add-In Download Link
- Installing Power Query in Excel 2013
- Installing Power Query in Excel 2010
- Trim
- Format Dates and Values
- Parsing URLs (Split Columns by Delimiter)
- Split Text Fields (Split Columns by Delimiter & Number of Characters)
- Group By
- Unpivot Columns
- Pivot Columns
- Split Columns into Other Columns with Delimiters
- Filter Your Data & Add a "Year" Column
- Sort Your Data
- Transform v Add Column
- Add Column From Examples
- Group and Rank Items
- Modulo
- FROM FOLDER: Consolidate Workbooks - Part 1
- FROM FOLDER: Consolidate Workbooks - Part 2
- FROM FOLDER: Extract Data from Forms
- FROM WORKBOOK: Extract & Consolidate Data Based on Multiple Criteria
- FROM WORKBOOK: Extract & Consolidate Data from Multiple Worksheets
- Merge - Joins Introduction
- Merge - Full Outer Join (all rows from both)
- Merge - Left Outer Join (all from first, matching from second)
- Merge - Right Outer Join (all from second, matching from first)
- Merge - Inner Join (only matching rows)
- Merge - Left Anti Join (rows only in first)
- Merge - Right Anti Join (rows only in second)
- BONUS EXAMPLE: Merge - Left Outer
- BONUS EXAMPLE: Merge - Full Outer Join
- BONUS EXAMPLE: Merge - Right Anti Join
- M Overview
- M Functions Cheat Sheet
- M Function List using #Shared
- Using M Functions
- Your Assignment - Create Custom Columns Using M Functions!
-
Advanced - Power BI
- Download Workbooks - 1. POWER BI DESKTOP - FUNDAMENTALS
- Download Workbook - 2. REAL WORLD EXAMPLE - NBA Website Links
- Download Workbooks - 3. POWER BI DESKTOP - ADVANCED TIPS
- Power BI Cheat Sheet
- Overview of Power BI Course
- Power BI Overview
- Power BI High Level Flow
- Install Power BI Desktop and Sign Up
- Install Power BI Desktop and Sign Up - URL LINKS
- Get Data (Power Query Overview)
- Data & Model (Power Pivot Overview)
- Report (Power View Overview)
- The Big Picture - Your First Power BI Solution!
- Get Data
- How to Get More Data & Edit Queries
- Data, Model & Relationships
- Adding Relationships Manually
- Report Visualization
- More Report Visualizations
- Report Visualization Format and Analytics
- Ask a Question
- Your Assignment - Create a Power BI Dashboard!
- Real World Example: NBA Statistics
- Get and Clean Data From Multiple Web Sources
- Modelling Data - Add Relationships
- Report Visualization with Multiple Charts
- Publish to Power BI Website and Create Dashboards from Existing Reports
- Power BI Website Features
- Introduction to our Dashboard's Data Setup
- Use the Bookmarks feature to show/hide a panel of Slicers
- Use the Drill through feature to drill down on specific data
- Drill down on data using Date Hierarchy
- Use the Analytics feature to Forecast future data points on a Line chart
- Use the Format painter to copy formats
- Use Bookmarks to Filter to specific data for your presentation
- Advanced Editor display options for M code
-
Advanced - Dashboards
- 2.1 Thinking Outside the Cell
- 2.2 Why Develop Differently
- 2.3 Inserting the Camera Tool
- 2.4 Camera Tool Demo
- 2.5 Development Principles
- 4.1 Lookup Functions
- 4.2 VLookup
- 4.3 Index Match
- 4.4 Combination
- 4.5 Array Formulas
- 4.6 Array Formulas Demo
- 4.7 Array Formula Review
- 5.1 Introduction to Excel Tables
- 5.2 Inserting an Excel Table
- 5.3 Working with Tables
- 5.4 Excel Table Chart Example
- 5.5 Excel Table Rules
- 6.1 Sorting Functions
- 6.2 Filters and SUMPRODUCT
- 6.3 Filtering on Excel Tables
- 6.4 Aggregation with Excel Tables
- 6.5 Summary
- 7.1 Installing the Developer Tab
- 7.2 Excel Controls
- 7.3 Form Controls Demo
- 7.4 Form Control Basics
- 7.5 Scrollable Tables
- 9.1 Introduction to Interactive Legends
- 9.2 Setting Up The Interactive Legend
- 9.3 Perfecting the Interactive Legend
- 9.4 Maintaining the Interactive Legend
- 10.1 Introduction
- 10.2 Setting up the Interactive Toggle
- 10.3 Formatting the Interactive Toggle
- 10.4 Maintaining the Interactive Toggle
- 11.1 Introduction
- 11.2 Setting Up The Interactive Dashboard
- 11.3 Formatting the Interactive Dashboard
- 11.4 Maintaining the Interactive Dashboard
- 12.1 Visual Peception
- 12.2 Gestalts Law
- 12.3 Preattentive Attributes
- 12.4 The Problem with Pie Charts
- 12.5 Data Viz vs Infographics
- 15.1 Introduction to Infographics in Excel
- 15.2 Progress Meter
- 15.3 Donut Chart Demo
- 15.4 Waffle Unit Chart Demo
- 15.5 Bringing it Together with the Camera Tool - Demo
- Introduction to the Analysis of Health Systems Dashboard
- Problem Description
- Form Control Scroll Bar Mechanism
- Create The Main Chart Using The LARGE, XLOOKUP, VLOOKUP & REPT Formulas
- Drill Down On Your Data With The LEFT, INDEX, REPT Formulas
- Create Top & Bottom Charts With The LARGE & XLOOLUP Formulas
- Dashboard Maintenance
- Course Outline
- Gannt Chart VBA Dashboard Overview
- Rollover pop-ups explained using VBA
- Lay out the data with the SUMIFS Formula
- Bring the data into the Gannt Chart Dashboard using the INDEX Formula
- Lay out the Gannt Chart Dashboard using Conditional Formatting
- Create the Legend using Conditional Formatting
- Set up the KPI Stacked Column Chart
- Design the Rollover pop-up using the INDEX formula and the Camera Tool
- Create the Rollover pop-up using VBA & Conditional Formatting
- Show the Rollover pop-up using VBA
- Test & Modify the Rollover pop-up using VBA
- Format the Rollover pop-up using VBA
-
Advanced - Charts
- Area Chart: Highlight Chart Sections
- Add an Interactive Vertical Column in Your Excel Line Chart
- Add Marker Options in a Chart
- Overlap Charts
- Add Trendlines to Charts
-
Advanced - Macros & VBA
- Getting Started With Macros & VBA
- Common VBA Programming Concepts You Can Use Today
- 5 Awesome Worksheet Macros
- Intro to VBA
- Exercise Files
- Downloadable Workbook
- What Is VBA?
- Object Structure
- Developer Tab
- Intro To VBA Window
- Immediate Window Object Ref
- Shorthand Object Ref
- Object Props Methods
- Download Workbook
- Worksheet References
- Worksheet Select Method
- Worksheets Name Property
- Worksheets Count Property
- Worksheets Add Method
- Worksheets Print Method
- Worksheets Delete Method
- Download Workbook
- Range Object Intro
- Selecting a Range
- Range Value Property
- Copy Paste Methods
- Reference Other Worksheet Cell
- Download Workbook
- Differences between Relative & Absolute References
- Active Sheet Object
- Active Cell Ref
- Current Region Property
- Offset Command
- What is a Module
- Creating a Procedure
- Adding VBA Code to your Procedure
- Running a Procedure
- Procedure Button
- Calling Procedures
- VBA Comments
- Saving VBA Code
- Download Workbooks
- What are Variables
- Declaring Variables
- Using a Variable
- Common Data Types
- String Data Type
- Integer & Long Data Type
- Boolean Type
- Download Workbooks
- IF Statements
- ElseIf and Else Statements
- Understanding Loops
- Do While Loop
- For Each Loop & Debug
- Downloadable Workbook
- PROJECT #1: Intro
- PROJECT #1: Create a VBA User Form
- PROJECT #1: Adding Controls
- PROJECT #1: Control Properties
- PROJECT #1: Project Type Combo Box
- PROJECT #1: Employee Combo Box
- PROJECT #1: Date Default
- PROJECT #1: Start Time Button
- PROJECT #1: Show User Form with a Button
- Downloadable Workbook
- PROJECT #2: Intro
- PROJECT #2: Submit Button Employee Sheet
- PROJECT #2: Transfer Data to a Worksheet
- PROJECT #2: Calculate Call Duration Formula
- PROJECT #2: Generate Unique Call ID Procedure
- PROJECT #2: Call Procedure From User Form
- PROJECT #2: Validate User Form Data with a Message Box
- PROJECT #2: Clear Data Button with a Loop
- Downloadable Workbook
- PROJECT #3: Intro
- PROJECT #3: Creating Print Report Form
- PROJECT #3: Opening a New Workbook Template
- PROJECT #3: Looping Controls Worksheets
- PROJECT #3: Copy & Paste Data to a New Workbook
- PROJECT #3: Clean Up Your VBA Code (Screen Updating)
- Downloadable Workbook
- PROJECT #4: Intro
- PROJECT #4: Create Temp Sheet - 01
- PROJECT #4: Create Temp Sheet - 02
- PROJECT #4: Create Call Stats
- PROJECT #4: Call Stats Initialize
- PROJECT #4: Create Send Email
- Using Excels PROPER() Function on Text
- Create Consistency with Excels UPPER() Function
- Paste Special Values
- Replace Meaningless Data with Excels CHOOSE() Function
- Extract Date Values Using Excels TEXT() Function
- Downloadable Workbook
- Dashboard Overview
- Preparing the Data Using Format As An Excel Table
- Creating a Drop Down Menu with Data Validation
- Looking Up Data with Excels VLOOKUP() Function
- Cleaning Up Data with Excels IF() Function
- INDEX() and MATCH() an Alternative to VLOOKUP()
- Adding the Order History Table
- Formatting Orders as a Table
- Using Excels Advanced Filter Feature
- Record a Macro for Advanced Filter
- Filter Order Records On Change of Customer with VBA
- Modify the VBA Filter Code
- Downloadable Workbooks
- Why Use Pivot Tables
- Summarizing Order Info with Pivot Tables
- Prepare Pivot Table for Customer Filter
- Creating a VBA Procedure for your Pivot Table
- Declaring VBA Variables for your Pivot Table
- Assigning VBA Variables to your Pivot Table
- Connecting the Filter to the Pivot Table with VBA
- Update Pivot Chart Based on Customer Selected with VBA
- Fix Customers with No Orders Error with VBA
-
Advanced - Analysis & Financial Modeling
- Download Workbooks - 1. Financial Modeling Introduction Course
- Downloadable Financial Modeling Practice Templates
- Financial Modeling Cheat Sheet
- Quick Overview
- What is a Financial Model?
- Financial Model Design
- Scenario Analysis
- Documentation
- Cell References
- IF Formula
- AND Formula
- OR Formula
- Nested Formulas
- Conditional Formatting
- Data validation
- Inputs
- Revenue
- Expenses
- Profit and Loss
- Cashflow
- Adding Scenarios
- Charts
- Conditional Formatting
- Protect Workbook
- Download Workbooks - 2. Financial Modeling Intermediate Course
- Overview of the Intermediate Financial Modeling Course
- Financial Model Design Principles
- Aggregate Functions
- Lookup Functions
- Forecasting Functions
- Mixed References and Named Ranges
- External File Links
- Building Error Checks
- Goal Seek
- WACC (Weighted Average Cost of Capital)
- NPV (Net Present Value) & IRR (Internal Rate of Return)
-
Microsoft Word
- Downloadable Word Documents to Practice - Introduction
- Open a New Word Document and Templates
- Tabs, Ribbons and Groups in Word
- Zoom, Rulers & Search your Word document
- Edit the Word Document with Fonts & Styles
- Insert Pictures & Icons in Word
- Insert Shapes and a Text Box in Word
- Review your Word document with Spelling, Word Count & Thesaurus
- Layout your Word document with Double Spaces & Margins
- Save, Print & Export your Word File
- Close, Re-Open & Pin your Word document
- Change the Views in Word
- Table of Contents & Smart Lookup in Word
- Print Settings in Word
- Using Mail Merge to Create Dynamic Emails in Word
- Using Mail Merge to Create Dynamic Labels in Word
- Downloadable Word Documents to Practice - Advanced Techniques
- Convert Speech to text (Dictate) in Word
- Convert an Image with Text to Word
- Drawing and Inking Tools in Word
- Icons, Photos & Illustrations in Word
- Insert Online Video in Word
- Screenshot into Word
- Compress Word Document
- Save Word Document as PDF
- Open PDF in Word
- Resume Assistant with LinkedIn in Word
- Transform Document to Web Page in Word
- Translate a Word Document
- Dark Mode in Word
- Editor - Proofreading in Word
- Focus Mode in Word
- Immersive Reader in Word
- How to Insert Page Numbers in Word
- Side by side view in Word
- Thumbnail view in Word
-
Microsoft Outlook
- Setting Up Outlook with Accounts
- Tabs, Ribbons and Groups in Outlook
- Navigation Bar in Outlook
- Organizing Outlook with Favorites and Folders
- Additional Options inside Outlook Tabs
- Reading, Writing and Receiving Emails
- Attaching Items in Outlook Mails
- The View Tab in Outlook
- Create a Rule to move emails to a folder
- Insert a screen shot from Excel
-
Microsoft PowerPoint
- Downloadable PowerPoint Slides - Introduction
- Open a New PowerPoint Presentation and Templates
- Tabs, Ribbons and Groups in PowerPoint
- Edit your First PowerPoint Slide and Designing the Slide
- Exploring Home Tab and Updating in PowerPoint
- Using Buttons in PowerPoint
- Insert Pictures in PowerPoint
- Presenting your Slides in PowerPoint
- Animating your Slides in PowerPoint
- Save, Print & Export your PowerPoint Presentation
- Close, Re-Open & Pin your PowerPoint Presentation
- Downloadable PowerPoint Slides - Advanced Tecniques
- Design Ideas in PowerPoint
- Templates in PowerPoint
- Animation Images in PowerPoint
- Remove Image Background in PowerPoint
- Selection Pane in PowerPoint
- Instant Slideshow in PowerPoint
- Create a Video Recording in PowerPoint
- Transitions & Morph in PowerPoint
- Link to Excel in PowerPoint
- Chart Animations in PowerPoint
- SmartArt in PowerPoint
- Duplicate Items in PowerPoint
- Ink Equation in PowerPoint
- Screen Recording in PowerPoint
- Filler Text in PowerPoint
- Translate Text in PowerPoint
- Add-ins in PowerPoint
- Compress Media in PowerPoint
- Insights in PowerPoint
- Recover Files in PowerPoint
-
Microsoft Teams
- Microsoft Teams Course Overview
- Links to set up Microsoft Teams
- [PDF Download] Microsoft Teams Cheat Sheet
- Introduction to Microsoft Teams
- Free and Paid versions
- Web or Desktop versions?
- Managing Teams and Members
- Inviting Members
- Managing Channels
- Chat
- Collaboration with Word, Excel, PowerPoint...
- Voice & Video Calls
- Adding More Apps
- Activity
- Search bar
- Settings
- Installing the Desktop version
- Multiple Organizations
- Teams Mobile app
- Meetings
-
Microsoft OneNote
- DOWNLOAD LINKS
- Get Started with OneNote
- Organize Notebooks in OneNote
- Settings and View Tab in OneNote
- Work with Multiple Accounts in OneNote
- Tell Me In OneNote in OneNote
- Adding Text, Tags & Videos in OneNote
- Insert Tables, Files, Printout, Draw & Audio in OneNote
- Draw & Ink Tools in OneNote
- Search Tool in OneNote
- OneNote Web Clipper
- Share Notebooks and Pages in OneNote
- Print Pages in OneNote
- OneNote online
- OneNote 2016
-
Advanced - Access
- Course Topics and Flow
- Download Exercise - Northwind Access Database
- Download Exercise - Modules 5 & 6 only
- Cheat Sheet - Getting Started with Access
- Opening Microsoft Access
- Access Quick Access Toolbar
- Working with the Access Ribbon
- Access Object Panel
- Access File Tab
- Access Security Prompt
- Understanding the Purpose of Access Tables
- Building Relationships between Access Tables
- Using Access Queries to Select Specific Data
- Building a User Interface with Access Forms
- Reporting on Access Data with Access Reports
- Automate Access Tasks with Macros and VBA
- Working in Datasheet View within an Access Table
- Sorting the Datasheet View
- Filtering the Datasheet View with Filter by Selection
- Filter the Datasheet View with Advanced Filter
- Preview the "Student Course" Database Tables
- Creating an Access Database
- Designing Access Tables in Design View
- Adding Fields and Defining Common Data Types in an Access Table
- Field Size Property
- Field Caption Property
- Default Value Property
- Required Field Property
- Input Mask Property
- Custom Input Mask
- Working with the Lookup Wizard Data Type
- Edit a Table Field Drop Down
- Adding Field Descriptions
- Setting the Table's Primary Key Field
- Adding Records in the Datasheet View
- Understanding Access Table Relationships
- Creating Access Table Relationships
- Setting Up "Better" Table Relationships
- Setting the Relationship Properties
- Table Relationships Cascade Update/Delete
- Working with Sub Datasheets in Tables
- Creating Table Relatioships with the Lookup Wizard
- Creating an Access Select Query
- Adding Criteria to an Access Select Query
- Using AND Conditions in an Access Query
- Using OR Conditions in an Access Query
- Another OR Condition
- Sorting Data within an Access Select Query
- Multi-Level Query Sort
- Working with Date Criteria in an Access Select Query
- Using the "Between" Operator
- Access Query Tip -- Using Table Fields within Query Criteria
- Using Wildcards in Query Criteria
- Access Query Tip --- DATA TYPE MISMATCH
- Saving an Access Query
- Creating a Calculated Field in an Access Query
- Using the MONTH() and MONTHNAME() Functions
- Using the IF() Function in a Query Calculated Field
- Finding the Difference Between Two Dates Using the DateDiff() Function
- Working with an Access Total Query
- Grouping and Summarizing Data with a Total Query
- Adding a Calculated Field to a Total Query
- Saving a Total Query
- Total Query Exercise -- Post in the QA Section
- Total Query Example -- Products Table
- Summarizing Data with a Crosstab Query
- Introduction to Access Action Queries
- Update Access Table Data with an Update Query
- Update Table Data with a Calculation
- Saving an Action Query
- Creating a New Table with an Access Make Table Query
- Deleting Table Data with an Access Delete Query
- Appending Records to an Exisiting Table with an Access Append Query
- Parameter Query Preview
- Creating a Single Parameter
- Saving the Parameter Query
- Creating Date Parameters
- Creating Multiple Parameters
- Using Wildcards in Parameters
- Run a Parameter with a Shortcut
- Starting with a Blank Form
- Adding Form Fields
- Moving Form Fields
- Resizing Form Fields
- Aligning Form Fields
- Spacing Form Fields
- Saving a Form
- Adding, Deleting and Editing Records
- Sorting Form Records
- Filtering Form Records using Filter by Selection
- Filtering Form Records using Advanced Filter
- Introduction to Form Controls
- Adding a Header and Footer
- Creating Calculated Form Fields
- Working with Sub Forms
- Working with the Option Group Control
- Adding the Tab Control to a Form
- Adding Buttons to a Form
- Formatting Field Controls
- Creating Separation with the Line Control
- Changing the Form Background color
- Preview an Access Switchboard
- Start the Switchboard Manager
- Adding Buttons to the Switchboard
- Fomatting the Switchboard
- Modify the Switchboard
- Preview Filtering Query Data with a Form
- Setting up the Query
- Setting up the Form
- Clean Up the Combo Box Control
- Creating the Form Button to Run the Query
- Adding Form Reference Criteria to the Query
- Running the Query
- Creating a Blank Report
- Adding Fields
- Field Layout
- Working with Report Sections
- Format Fields
- Report Margins
- Format Painter
- Header & Footer
- Report Saved
-
Excel Resources
- [PDF DOWNLOAD] 333 Excel Keyboards Shortcuts Templates for Windows & Mac
- Downloadable Practice Workbook
- Cell Formatting Keyboard Shortcuts
- Drag & Drop Keyboard Shortcuts
- Formulas Keyboard Shortcuts
- Macros & VBA Keyboard Shortcuts
- Frequent Keyboard Shortcuts
- Function Key Keyboard Shortcuts
- Making Selections Keyboard Shortcuts
- Ribbon Tab Keyboard Shortcuts
- Cell Navigation Keyboard Shortcuts
- Inside Ribbon Keyboard Shortcuts
- Other Keyboard Shortcuts
- Pivot Table Keyboard Shortcuts
- Power BI Keyboard Shortcuts
- Power Pivot Keyboard Shortcuts
- 101 Most Popular Excel Formulas
- 101 Ready To Use Excel Macros
- Academy Welcome Pack + T-Shirt
- Free Workshop: 19 Secret Excel Productivity Tips!
- FINANCIAL MODELING: Getting Started
- POWER BI: Various Visualizations You Can Use!
- ACCESS: Getting Started With Access
- FORMULAS: Top 9 Formula Tips!
- FORMULAS: VLOOKUP, INDEX, MATCH, IF, IFERROR, SUMIF, SUMIFS!
- CHARTS & GRAPHS: Excel Charts Helper Guide!
- MACROS & VBA: 5 Awesome Worksheet Macros
- MACROS & VBA: Getting Started with Macros & VBA
- MACROS & VBA: Common VBA Programming Concepts You Can Use Today
- PIVOT TABLES: Getting Started with Pivot Tables
- PIVOT TABLES: 5 Speedy Steps to an Excel Pivot Table
- POWER QUERY: Getting Started with Power Query (Get & Transform)
- POWER QUERY: M Functions
- POWER PIVOT: Getting Started with Power Pivot
- SQL: Logical Ordering & Keywords
- POWER AUTOMATE: Flows Cheat Sheet
- POWER APPS: Main Components
- SHAREPOINT: Customizing SharePoint Sites
-
Webinar Replays