[vc_row full_width=”false” row_responsive_large=”” row_responsive_medium=”” row_responsive_small=”” row_responsive_extra_small=”” enable_row_sc=”” type=”ww-custom” enable_row_engle=”” height_engle=”60px” engle_border_width=”0″ enable_engle_duplicate=”” engle_uplicated_height=”60px” engle_duplicated_border_width=”0″ enable_engle_style2=”false” engle_position_style2=”engle-bottom-style1″ height_engle_style2=”60px” engle_color_style2=”#81d742″ enable_engle_duplicated_style2=”false” engle_duplicated_height_style2=”60px” enable_parallax=”” parallax_speed=”0.8″ bg_video_transparent=”0″ disable_parallax_mobile=”” loop=”” autoplay=”” muted=”” controls=”” show_btn=”” lax_layer1_align=”lax_left_top” lax_layer2_align=”lax_left_top” lax_layer3_align=”lax_left_top” lax_layer4_align=”lax_left_top” lax_layer5_align=”lax_left_top” lax_layer6_align=”lax_left_top” lax_layer7_align=”lax_left_top” lax_layer8_align=”lax_left_top” css=”.vc_custom_1429732675907{background-color: #7da86d !important;}” engle_duplicated_position_style2=”engle-bottom-style1″ engle_duplicated_color_style2=”#ffffff”][vc_column][vc_empty_space height=”50px”][/vc_column][/vc_row][vc_row full_width=”false” row_responsive_large=”” row_responsive_medium=”” row_responsive_small=”” row_responsive_extra_small=”” enable_row_sc=”” enable_row_engle=”” height_engle=”60px” engle_border_width=”5px” enable_engle_duplicate=”” engle_uplicated_height=”60px” engle_duplicated_border_width=”5px” enable_engle_style2=”false” height_engle_style2=”60px” enable_engle_duplicated_style2=”” engle_duplicated_height_style2=”60px” enable_parallax=”” parallax_speed=”0.8″ bg_video_transparent=”0″ disable_parallax_mobile=”” loop=”” autoplay=”” muted=”” controls=”” show_btn=”” lax_layer1_align=”lax_left_top” lax_layer2_align=”lax_left_top” lax_layer3_align=”lax_left_top” lax_layer4_align=”lax_left_top” lax_layer5_align=”lax_left_top” lax_layer6_align=”lax_left_top” lax_layer7_align=”lax_left_top” lax_layer8_align=”lax_left_top” type=”ww-custom” engle_position=”engle-bottom-left” engle_duplicated_position_style2=”engle-top-style1″ engle_position_duplicate=”engle-bottom-right” engle_position_style2=”engle-bottom-style1″ engle_color_style2=”#7da86d”][vc_column][vc_empty_space height=”50px” el_class=”mobile_hide”][/vc_column][vc_column width=”1/3″ column_responsive_large=”” column_responsive_medium=”” column_responsive_small=”” column_responsive_extra_small=”” image_transition=”” el_class=”my_sidebar” css=”.vc_custom_1436968296664{padding-right: 100px !important;}”][vc_widget_sidebar sidebar_id=”cs-2″][/vc_column][vc_column width=”2/3″ el_class=”my_sidebar_content” column_responsive_large=”” column_responsive_medium=”” column_responsive_small=”” column_responsive_extra_small=”” image_transition=””][vc_custom_heading text=”You can learn Microsoft Excel!” google_fonts=”font_family:Raleway%3A100%2C200%2C300%2Cregular%2C500%2C600%2C700%2C800%2C900|font_style:400%20regular%3A400%3Anormal”][vc_column_text]You can greatly improve your knowledge of Excel! I will help you! Watch my videos and step by step you will start to unlock the mysteries of Microsoft Excel![/vc_column_text][vc_column_text]
Videos
[/vc_column_text][/vc_column][vc_column][vc_custom_heading text=”Click any of the links below to watch the video!” google_fonts=”font_family:Raleway%3A100%2C200%2C300%2Cregular%2C500%2C600%2C700%2C800%2C900|font_style:400%20regular%3A400%3Anormal”][vc_column_text]
- Word Game in Excel
- whack-a-merged-cell
- Weighted Average
- Video 00174 Ranking Values into Tiers in Excel
- Video 00173 Dynamically Combine Data From Excel Tables
- Video 00172 Unique Values for Data Validation Drop Down
- Video 00171 Create Christmas Lights Using Excel Sheets
- Video 00167 Sliding Formula Ranges
- Video 00166 Count Groups Above or Below Targets
- Video 00163 Creating a Weighted Random Dataset in Excel
- Video 00162 Excel Formula Calculates Value of Chess Pieces
- Video 00161 Extract Matrix Non Blanks Into 1 Column
- Video 00160 Sum Values From Qualifying Mini Tables
- Video 00159 Create unique and sorted text list
- Video 00158 Keyword Data Validation List
- Video 00156 One Complex Formula or Helper Formulas?
- Video 00153 All Possible Pairs from List of Names
- Video 00151 Custom Formats, VBA, and Nerds!
- Video 00150 Sequential Keyword Search Dog Chases Squirrel
- Video 00149 Alphabetize Challenge (Oz001)
- Video 00148 Insert Rows & Cascade Numbers
- Video 00147 Conditionally Add Checkboxes using VBA
- Video 00142 Horizontal list to Vertical list (layered transpose)
- Video 00139 Beyond 3D Formulas
- Video 00137 Vlookup_Returns Multiple Values
- Video 00135 Cali Data Cleanup
- Video 00122 Normalizing Exported Data
- Video 00121_Crazy String Manipulation!
- Video 00120 Is the solution benefit worth the cost
- Video 00119 Excel Helps to Determine the Closest Super Bowls
- Video 00114_Cleanup Data From Internet
- Video 00081 Count and find different types of Excel errors
- Video 00073 Helping Dean Pelton with his menu in Excel
- Video 00070 Use array formula to solve an algebra equation
- Video 00069 Are my Excel formulas dragged down far enough?
- Video 00067 What you see may not be what you get
- Video 00064 Solution_Customized and Sorted Data Validation List
- Video 00062 Learn Excel: Add Sporadic Totals
- Video 00058 Filter Out Number (digits in any order)
- Video 00057 Find the Monday before the oldest date
- Video 00044 Array Formulas_Example2_EXACT LEFT_functions
- Video 00043 Formulas_Array Formulas_Example1_LEN_function
- Video 00042 Why would I need an array formula?
- Video 00037 Formulas_Adding numbers in Excel
- Video 00036 Intro_WORKING-WITH-SHEETS
- Video 00035 Solution_Dynamic array HYPERLINK
- Video 00033 Solution_identify rows if any in same group meet condition_V2
- Video 00032 Solution_identify rows if any in same group meet condition
- Video 00031 DATA VALIDATION restrict values entered into a cell
- Video 00030 Create a HYPERLINK in Microsoft Excel
- Video 00029 OFFSET function with combo box
- Video 00028 OFFSET function introduction
- Video 00027 COUNT functions in Excel
- Video 00026 Financial Functions_FUTURE VALUE part 2
- Video 00025 Financial Functions_FUTURE VALUE
- Video 00024 Intro_Working with DATE and TIME_in Excel
- Video 00023 TEXT TO COLUMNS to parse data
- Video 00020 Use a FILTER to hide rows
- Video 00019 Pivot Table: How to Group Dates
- Video 00018 SORT_DATA in Excel
- Video 00017 VLOOKUP Introduction Part2
- Video 00016 VLOOKUP introduction
- Video 00015 Pivot Table: How to use a PIVOT FILTER
- Video 00014 Pivot Table: Extend the data range
- Video 00013 Pivot Table: Introduction
- Video 00012 SUMPRODUCT_Part4 this OR that
- Video 00011 SUMPRODUCT_Part3 How it really works!
- Video 00010 SUMPRODUCT_Intro_Part2
- Video 00009 FIND-and-SEARCH Excel functions
- Video 00008 Features_Basic_FIND
- Video 00007 Intro_HOW-TO-ENTER-DATA
- Video 00006 Intro_NAVIGATION
- Video 00005 Intro_EXCEL-FORMULAS
- Video 00004 Intro_Excel2010_WINDOW
- Video 00003 Intro_Excel2010_RIBBON
- Video 00002 SUMPRODUCT_function Part1
- Variable Sized Groups Within Each Column
- Valentine’s Day in Microsoft Excel
- Using Microsoft Excel for your hockey pool
- unstacking-data-with-chandeep/
- Unstacking Data with Oz du Soleil
- UDF Rollover Jordan Goldmeier
- Standard Deviation in Excel
- Sorted Data Validation List
- Rounding with a twist
- Robert Gascon’s Shortest Formula Challenge
- Retro 1980 Games & Correlation
- Retrieve 1st Code for Selected City When Description is not blank
- Rearranging Data
- Power Query solution: partial match count with a condition
- Power Query Challenge – What Did They Order from the Menu?
- Old School Helper Columns
- Normalize Data using Excel Get & Transform
- mmult function
- Look for keywords inside of a column of text values
- Learn VBA UDF
- Kevin’s Formula Challenge
- How Many Unique Visitors To Site Each Day?
- How many unique List 1 names found in List 2?
- Flirting with Volatility
- Flatten the Curve
- Extract Largest Number (Power Query & Flash Fill solutions)
- Excel Pivot Tables Analyze Taco Data!
- Excel Beer Game
- DSUM gymnastics
- Data Disaster: non normalized data
- CELL Function Adventure
- Calculate Hours from Messy Text using Power Query
- Calculate Hours from Messy Text
- CAGR in Microsoft Excel
- awkward-data/power-query-solution
- Auditing & Editing M code (Power Query)
- All Combinations Using Power Query
- aggregating text part 2
- Aggregating Text
- 3D Objects
- 00127 All Combinations No Formulas No VBA
[/vc_column_text][/vc_column][vc_column el_class=”clear-it” column_responsive_large=”” column_responsive_medium=”” column_responsive_small=”” column_responsive_extra_small=”” image_transition=””][vc_empty_space height=”50px”][/vc_column][/vc_row][vc_row full_width=”false” row_responsive_large=”” row_responsive_medium=”” row_responsive_small=”” row_responsive_extra_small=”” enable_row_sc=”” type=”ww-custom” enable_row_engle=”” height_engle=”60px” engle_border_width=”0″ enable_engle_duplicate=”” engle_uplicated_height=”60px” engle_duplicated_border_width=”0″ enable_engle_style2=”” engle_position_style2=”engle-bottom-style1″ height_engle_style2=”60px” enable_engle_duplicated_style2=”false” engle_duplicated_height_style2=”60px” enable_parallax=”” parallax_speed=”0.8″ bg_video_transparent=”0″ disable_parallax_mobile=”” loop=”” autoplay=”” muted=”” controls=”” show_btn=”” lax_layer1_align=”lax_left_top” lax_layer2_align=”lax_left_top” lax_layer3_align=”lax_left_top” lax_layer4_align=”lax_left_top” lax_layer5_align=”lax_left_top” lax_layer6_align=”lax_left_top” lax_layer7_align=”lax_left_top” lax_layer8_align=”lax_left_top” css=”.vc_custom_1429736303669{background-color: #7da86d !important;}” engle_duplicated_position_style2=”engle-bottom-style1″ engle_duplicated_color_style2=”#89bde2″][vc_column][vc_empty_space height=”50px”][/vc_column][/vc_row][vc_row full_width=”false” row_responsive_large=”” row_responsive_medium=”” row_responsive_small=”” row_responsive_extra_small=”” enable_row_sc=”” enable_row_engle=”” height_engle=”60px” engle_border_width=”5px” enable_engle_duplicate=”” engle_uplicated_height=”60px” engle_duplicated_border_width=”5px” enable_engle_style2=”false” height_engle_style2=”60px” enable_engle_duplicated_style2=”” engle_duplicated_height_style2=”60px” enable_parallax=”” parallax_speed=”0.8″ bg_video_transparent=”0″ disable_parallax_mobile=”” loop=”” autoplay=”” muted=”” controls=”” show_btn=”” lax_layer1_align=”lax_left_top” lax_layer2_align=”lax_left_top” lax_layer3_align=”lax_left_top” lax_layer4_align=”lax_left_top” lax_layer5_align=”lax_left_top” lax_layer6_align=”lax_left_top” lax_layer7_align=”lax_left_top” lax_layer8_align=”lax_left_top” type=”ww-custom” engle_position=”engle-bottom-left” engle_duplicated_position_style2=”engle-top-style1″ engle_position_duplicate=”engle-bottom-right” engle_position_style2=”engle-bottom-style1″ engle_color_style2=”#7da86d” css=”.vc_custom_1436201635805{background-color: #89bde2 !important;}” el_class=”about_info”][vc_column][vc_empty_space height=”50px” el_class=”mobile_hide”][/vc_column][vc_column width=”1/3″ column_responsive_large=”” column_responsive_medium=”” column_responsive_small=”” column_responsive_extra_small=”” image_transition=””][vc_column_text]
VIDEO TUTORIALS
You can learn Microsoft Excel![/vc_column_text][vc_empty_space][vc_button title=”CLICK HERE” type=”btn btn-default” button_block=”” href=”/videos/”][/vc_column][vc_column width=”1/3″ column_responsive_large=”” column_responsive_medium=”” column_responsive_small=”” column_responsive_extra_small=”” image_transition=””][vc_widget_sidebar sidebar_id=”cs-6″][/vc_column][vc_column width=”1/3″ column_responsive_large=”” column_responsive_medium=”” column_responsive_small=”” column_responsive_extra_small=”” image_transition=””][vc_column_text]
GET EXCEL SPREADSHEET TIPS!
Unlock the secrets and be more productive.[/vc_column_text][vc_button title=”CLICK HERE” type=”btn btn-default” button_block=”” href=”/tips/”][/vc_column][vc_column el_class=”clear-it” column_responsive_large=”” column_responsive_medium=”” column_responsive_small=”” column_responsive_extra_small=”” image_transition=””][vc_empty_space height=”50px”][/vc_column][/vc_row][vc_row full_width=”false” row_responsive_large=”” row_responsive_medium=”” row_responsive_small=”” row_responsive_extra_small=”” enable_row_sc=”” type=”ww-custom” enable_row_engle=”” height_engle=”60px” engle_border_width=”0″ enable_engle_duplicate=”” engle_uplicated_height=”60px” engle_duplicated_border_width=”0″ enable_engle_style2=”” engle_position_style2=”engle-bottom-style1″ height_engle_style2=”60px” enable_engle_duplicated_style2=”false” engle_duplicated_height_style2=”60px” enable_parallax=”” parallax_speed=”0.8″ bg_video_transparent=”0″ disable_parallax_mobile=”” loop=”” autoplay=”” muted=”” controls=”” show_btn=”” lax_layer1_align=”lax_left_top” lax_layer2_align=”lax_left_top” lax_layer3_align=”lax_left_top” lax_layer4_align=”lax_left_top” lax_layer5_align=”lax_left_top” lax_layer6_align=”lax_left_top” lax_layer7_align=”lax_left_top” lax_layer8_align=”lax_left_top” css=”.vc_custom_1429735734076{background-color: #7da86d !important;}” engle_duplicated_position_style2=”engle-bottom-style1″ engle_duplicated_color_style2=”#0f2229″][vc_column][vc_empty_space height=”50px”][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
[/vc_column_text][/vc_column][/vc_row]