{"id":126,"date":"2024-03-16T21:09:35","date_gmt":"2024-03-16T21:09:35","guid":{"rendered":"https:\/\/rayerden.com\/index.php\/my-screencast\/"},"modified":"2024-08-15T16:32:43","modified_gmt":"2024-08-15T16:32:43","slug":"my-screencast","status":"publish","type":"page","link":"https:\/\/www.rayerden.com\/index.php\/my-screencast\/","title":{"rendered":"MY SCREENCASTS"},"content":{"rendered":"\n    \n    <section class=\"u-clearfix u-section-2\" id=\"sec-bb34\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <div data-interval=\"5000\" data-u-ride=\"carousel\" class=\"u-carousel u-slider u-slider-1\" id=\"carousel-e371\">\n          <ol class=\"u-absolute-hcenter u-carousel-indicators u-carousel-indicators-1\">\n            <li data-u-target=\"#carousel-e371\" class=\"u-active u-grey-30\" data-u-slide-to=\"0\"><\/li>\n            <li data-u-target=\"#carousel-e371\" class=\"u-grey-30\" data-u-slide-to=\"1\"><\/li>\n            <li data-u-target=\"#carousel-e371\" class=\"u-grey-30\" data-u-slide-to=\"2\"><\/li>\n            <li data-u-target=\"#carousel-e371\" class=\"u-grey-30\" data-u-slide-to=\"3\"><\/li>\n            <li data-u-target=\"#carousel-e371\" class=\"u-grey-30\" data-u-slide-to=\"4\"><\/li>\n            <li data-u-target=\"#carousel-e371\" class=\"u-grey-30\" data-u-slide-to=\"5\"><\/li>\n            <li data-u-target=\"#carousel-e371\" class=\"u-grey-30\" data-u-slide-to=\"6\"><\/li>\n          <\/ol>\n          <div class=\"u-carousel-inner\" role=\"listbox\">\n            <div class=\"u-active u-carousel-item u-container-style u-image u-slide u-image-1\" data-image-width=\"1600\" data-image-height=\"1001\" style=\"background-image: url(&quot;https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/Data-Mining-Techniques-15.jpg&quot;);\">\n              <div class=\"u-container-layout u-container-layout-1\"><\/div>\n            <\/div>\n            <div class=\"u-carousel-item u-container-style u-image u-slide u-image-2\" data-image-width=\"1200\" data-image-height=\"675\" style=\"background-image: url(&quot;https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/sql-nedir.png&quot;);\">\n              <div class=\"u-container-layout u-container-layout-2\"><\/div>\n            <\/div>\n            <div class=\"u-carousel-item u-container-style u-image u-slide u-image-3\" data-image-width=\"1920\" data-image-height=\"1080\" style=\"background-image: url(&quot;https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/Data-Science-Exercises.jpg&quot;);\">\n              <div class=\"u-container-layout u-container-layout-3\"><\/div>\n            <\/div>\n            <div class=\"u-carousel-item u-container-style u-image u-slide u-image-4\" data-image-width=\"900\" data-image-height=\"500\" style=\"background-image: url(&quot;https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/Microsoft-Access-Microsoft-Office-dev-Database-Veritaban-Proje-Tasarm-Yaptrma.jpg&quot;);\">\n              <div class=\"u-container-layout u-container-layout-4\"><\/div>\n            <\/div>\n            <div class=\"u-carousel-item u-container-style u-image u-slide u-image-5\" data-image-width=\"1000\" data-image-height=\"616\" style=\"background-image: url(&quot;https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/shutterstock_488322949-19.jpg&quot;);\">\n              <div class=\"u-container-layout u-container-layout-5\"><\/div>\n            <\/div>\n            <div class=\"u-carousel-item u-container-style u-image u-slide u-image-6\" data-image-width=\"512\" data-image-height=\"288\" style=\"background-image: url(&quot;https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/unnamed3.jpg&quot;);\">\n              <div class=\"u-container-layout u-container-layout-6\"><\/div>\n            <\/div>\n            <div class=\"u-carousel-item u-container-style u-slide\">\n              <div class=\"u-container-layout u-container-layout-7\">\n                <img decoding=\"async\" class=\"u-image u-image-default u-image-7\" src=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/08\/ChatGPT_1.jpeg\" alt=\"\" data-image-width=\"392\" data-image-height=\"220\">\n              <\/div>\n            <\/div>\n          <\/div>\n          <a class=\"u-absolute-vcenter u-carousel-control u-carousel-control-prev u-spacing-5 u-text-grey-30 u-carousel-control-1\" href=\"#carousel-e371\" role=\"button\" data-u-slide=\"prev\">\n            <span aria-hidden=\"true\">\n              <svg viewBox=\"0 0 477.175 477.175\"><path d=\"M145.188,238.575l215.5-215.5c5.3-5.3,5.3-13.8,0-19.1s-13.8-5.3-19.1,0l-225.1,225.1c-5.3,5.3-5.3,13.8,0,19.1l225.1,225\n                    c2.6,2.6,6.1,4,9.5,4s6.9-1.3,9.5-4c5.3-5.3,5.3-13.8,0-19.1L145.188,238.575z\"><\/path><\/svg>\n            <\/span>\n            <span class=\"sr-only\">Previous<\/span>\n          <\/a>\n          <a class=\"u-absolute-vcenter u-carousel-control u-carousel-control-next u-spacing-5 u-text-grey-30 u-carousel-control-2\" href=\"#carousel-e371\" role=\"button\" data-u-slide=\"next\">\n            <span aria-hidden=\"true\">\n              <svg viewBox=\"0 0 477.175 477.175\"><path d=\"M360.731,229.075l-225.1-225.1c-5.3-5.3-13.8-5.3-19.1,0s-5.3,13.8,0,19.1l215.5,215.5l-215.5,215.5\n                    c-5.3,5.3-5.3,13.8,0,19.1c2.6,2.6,6.1,4,9.5,4c3.4,0,6.9-1.3,9.5-4l225.1-225.1C365.931,242.875,365.931,234.275,360.731,229.075z\"><\/path><\/svg>\n            <\/span>\n            <span class=\"sr-only\">Next<\/span>\n          <\/a>\n        <\/div>\n      <\/div>\n    <\/section>\n    <section class=\"u-clearfix u-section-3\" id=\"sec-251f\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <h1 class=\"u-align-center u-text u-text-default u-text-1\">EXCEL SCREENCASTING<br>\n          <span style=\"font-size: 1.5rem;\">Below videos illustrate various concepts and methods that can be performed in MS Excel.&nbsp;<\/span>\n        <\/h1>\n      <\/div>\n    <\/section>\n    <section class=\"u-align-center u-clearfix u-section-4\" id=\"sec-0337\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <p class=\"u-text u-text-1\">Index Function Demo in Excel<br>In this sample I present how to use Index function where VLOOKUP function fails to work for more complex lookup tasks. \n        <\/p>\n        <div class=\"u-expanded-width-sm u-expanded-width-xs u-video u-video-1\">\n          <div class=\"embed-responsive embed-responsive-1\">\n            <iframe style=\"position: absolute;top: 0;left: 0;width: 100%;height: 100%;\" class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/AbSFMgo9-bI?mute=0&amp;showinfo=0&amp;controls=0&amp;start=0\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/section>\n    <section class=\"u-align-center u-clearfix u-section-5\" id=\"carousel_63af\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <p class=\"u-text u-text-1\">Time Value of Money Excel Application<br>This video displays how Excel VBA programming can be used to cerate a simple application for the user to perform some financial calculations for personal finance. They could be borrowing decision, loan or mortgage payment plan, saving plans etc. \n        <\/p>\n        <div class=\"u-expanded-width-sm u-expanded-width-xs u-video u-video-1\">\n          <div class=\"embed-responsive embed-responsive-1\">\n            <iframe style=\"position: absolute;top: 0;left: 0;width: 100%;height: 100%;\" class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/9VOcSOEm7so?mute=0&amp;showinfo=0&amp;controls=0&amp;start=0\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/section>\n    <section class=\"u-align-center u-clearfix u-section-6\" id=\"carousel_4b23\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <p class=\"u-text u-text-1\">Simple XLOOKUP in MS Excel<br>This screencast talks about how to do a simple XLOOKUP in Excel. \n        <\/p>\n        <div class=\"u-expanded-width-sm u-expanded-width-xs u-video u-video-1\">\n          <div class=\"embed-responsive embed-responsive-1\">\n            <iframe style=\"position: absolute;top: 0;left: 0;width: 100%;height: 100%;\" class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/hl3VNimB4j4?mute=0&amp;showinfo=0&amp;controls=0&amp;start=0\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/section>\n    <section class=\"u-align-center u-clearfix u-section-7\" id=\"carousel_925a\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <p class=\"u-text u-text-1\">XLOOKUP Horizontal<br>This video shows how to ue the XLOOKUP function in Excel in horizontal manner with a sample data. \n        <\/p>\n        <div class=\"u-expanded-width-sm u-expanded-width-xs u-video u-video-1\">\n          <div class=\"embed-responsive embed-responsive-1\">\n            <iframe style=\"position: absolute;top: 0;left: 0;width: 100%;height: 100%;\" class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/Tu5uVhvbgUM?mute=0&amp;showinfo=0&amp;controls=0&amp;start=0\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/section>\n    <section class=\"u-align-center u-clearfix u-section-8\" id=\"carousel_d724\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <p class=\"u-text u-text-1\">XLOOKUP in Reverse Order<br>This video decribes how to use XLOOKUP function to obtain the values that are on the left side of the lookup field unlike VLOOKUP function. \n        <\/p>\n        <div class=\"u-expanded-width-sm u-expanded-width-xs u-video u-video-1\">\n          <div class=\"embed-responsive embed-responsive-1\">\n            <iframe style=\"position: absolute;top: 0;left: 0;width: 100%;height: 100%;\" class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/8hs0sIH4vQo?mute=0&amp;showinfo=0&amp;controls=0&amp;start=0\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/section>\n    <section class=\"u-align-center u-clearfix u-section-9\" id=\"carousel_fd5c\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <p class=\"u-text u-text-1\">XLOOKUP_INDEX_MATCH<br>This video compares XLOOKUP vs. INDEX_MATCH function. \n        <\/p>\n        <div class=\"u-expanded-width-sm u-expanded-width-xs u-video u-video-1\">\n          <div class=\"embed-responsive embed-responsive-1\">\n            <iframe style=\"position: absolute;top: 0;left: 0;width: 100%;height: 100%;\" class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/l3VlXoRJx_E?mute=0&amp;showinfo=0&amp;controls=0&amp;start=0\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe>\n          <\/div>\n        <\/div>\n        <p class=\"u-text u-text-2\">Excel with ChatGPT Assistance<br>\n          <br>\n        <\/p>\n        <div class=\"u-expanded-width-sm u-expanded-width-xs u-video u-video-2\">\n          <div class=\"embed-responsive embed-responsive-2\">\n            <iframe style=\"position: absolute;top: 0;left: 0;width: 100%;height: 100%;\" class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/Gl0CKzVw5AM?mute=0&amp;showinfo=0&amp;controls=0&amp;start=0\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe>\n          <\/div>\n        <\/div>\n        <p class=\"u-text u-text-3\">Business Intelligence Dashboard in Excel<br>\n          <br>\n        <\/p>\n        <div class=\"u-expanded-width-sm u-expanded-width-xs u-video u-video-3\">\n          <div class=\"embed-responsive embed-responsive-3\">\n            <iframe style=\"position: absolute;top: 0;left: 0;width: 100%;height: 100%;\" class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/Bcd1ZtUJSSk?mute=0&amp;showinfo=0&amp;controls=0&amp;start=0\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe>\n          <\/div>\n        <\/div>\n        <p class=\"u-text u-text-4\">ChatGPT Excel VBA Samples<br>\n          <br>\n        <\/p>\n        <div class=\"u-expanded-width-sm u-expanded-width-xs u-video u-video-4\">\n          <div class=\"embed-responsive embed-responsive-4\">\n            <iframe style=\"position: absolute;top: 0;left: 0;width: 100%;height: 100%;\" class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/qT9lUYtQJfc?mute=0&amp;showinfo=0&amp;controls=0&amp;start=0\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe>\n          <\/div>\n        <\/div>\n        <p class=\"u-text u-text-5\">Power BI Data Visualization Example <\/p>\n        <div class=\"u-expanded-width-sm u-expanded-width-xs u-video u-video-5\">\n          <div class=\"embed-responsive embed-responsive-5\">\n            <iframe style=\"position: absolute;top: 0;left: 0;width: 100%;height: 100%;\" class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/1MhqQ-nk-tM?mute=0&amp;showinfo=0&amp;controls=0&amp;start=0\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe>\n          <\/div>\n        <\/div>\n        <p class=\"u-text u-text-6\">Excel Dynamic Range Update for Pivot Table <\/p>\n        <div class=\"u-expanded-width-sm u-expanded-width-xs u-video u-video-6\">\n          <div class=\"embed-responsive embed-responsive-6\">\n            <iframe style=\"position: absolute;top: 0;left: 0;width: 100%;height: 100%;\" class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/jLNsLqoUY9Y?mute=0&amp;showinfo=0&amp;controls=0&amp;start=0\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe>\n          <\/div>\n        <\/div>\n        <p class=\"u-text u-text-7\">Excel Power Query Demo <\/p>\n        <div class=\"u-expanded-width-sm u-expanded-width-xs u-video u-video-7\">\n          <div class=\"embed-responsive embed-responsive-7\">\n            <iframe style=\"position: absolute;top: 0;left: 0;width: 100%;height: 100%;\" class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/IXx4JgODH48?mute=0&amp;showinfo=0&amp;controls=0&amp;start=0\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe>\n          <\/div>\n        <\/div>\n        <p class=\"u-text u-text-8\">Excel Macro to Copy File Names <\/p>\n        <div class=\"u-expanded-width-sm u-expanded-width-xs u-video u-video-8\">\n          <div class=\"embed-responsive embed-responsive-8\">\n            <iframe style=\"position: absolute;top: 0;left: 0;width: 100%;height: 100%;\" class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/0BD8AwFMOL4?mute=0&amp;showinfo=0&amp;controls=0&amp;start=0\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/section>\n    <section class=\"u-clearfix u-custom-color-1 u-section-10\" id=\"sec-8656\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <h1 class=\"u-text u-text-default u-text-1\"> www.rayerden.com<\/h1>\n        <div class=\"u-social-icons u-spacing-10 u-social-icons-1\">\n          <a class=\"u-social-url\" title=\"facebook\" target=\"_blank\" href=\"https:\/\/www.facebook.com\/ray.erden1\/\"><span class=\"u-icon u-social-facebook u-social-icon u-icon-1\"><svg class=\"u-svg-link\" preserveAspectRatio=\"xMidYMin slice\" viewBox=\"0 0 112 112\" style=\"\"><use xlink:href=\"#svg-84a6\"><\/use><\/svg><svg class=\"u-svg-content\" viewBox=\"0 0 112 112\" x=\"0\" y=\"0\" id=\"svg-84a6\"><circle fill=\"currentColor\" cx=\"56.1\" cy=\"56.1\" r=\"55\"><\/circle><path fill=\"#FFFFFF\" d=\"M73.5,31.6h-9.1c-1.4,0-3.6,0.8-3.6,3.9v8.5h12.6L72,58.3H60.8v40.8H43.9V58.3h-8V43.9h8v-9.2\nc0-6.7,3.1-17,17-17h12.5v13.9H73.5z\"><\/path><\/svg><\/span>\n          <\/a>\n          <a class=\"u-social-url\" title=\"twitter\" target=\"_blank\" href=\"https:\/\/twitter.com\/unbiasedview\"><span class=\"u-icon u-social-icon u-social-twitter u-icon-2\"><svg class=\"u-svg-link\" preserveAspectRatio=\"xMidYMin slice\" viewBox=\"0 0 112 112\" style=\"\"><use xlink:href=\"#svg-7cfd\"><\/use><\/svg><svg class=\"u-svg-content\" viewBox=\"0 0 112 112\" x=\"0\" y=\"0\" id=\"svg-7cfd\"><circle fill=\"currentColor\" class=\"st0\" cx=\"56.1\" cy=\"56.1\" r=\"55\"><\/circle><path fill=\"#FFFFFF\" d=\"M83.8,47.3c0,0.6,0,1.2,0,1.7c0,17.7-13.5,38.2-38.2,38.2C38,87.2,31,85,25,81.2c1,0.1,2.1,0.2,3.2,0.2\nc6.3,0,12.1-2.1,16.7-5.7c-5.9-0.1-10.8-4-12.5-9.3c0.8,0.2,1.7,0.2,2.5,0.2c1.2,0,2.4-0.2,3.5-0.5c-6.1-1.2-10.8-6.7-10.8-13.1\nc0-0.1,0-0.1,0-0.2c1.8,1,3.9,1.6,6.1,1.7c-3.6-2.4-6-6.5-6-11.2c0-2.5,0.7-4.8,1.8-6.7c6.6,8.1,16.5,13.5,27.6,14\nc-0.2-1-0.3-2-0.3-3.1c0-7.4,6-13.4,13.4-13.4c3.9,0,7.3,1.6,9.8,4.2c3.1-0.6,5.9-1.7,8.5-3.3c-1,3.1-3.1,5.8-5.9,7.4\nc2.7-0.3,5.3-1,7.7-2.1C88.7,43,86.4,45.4,83.8,47.3z\"><\/path><\/svg><\/span>\n          <\/a>\n          <a class=\"u-social-url\" title=\"instagram\" target=\"_blank\" href=\"https:\/\/www.instagram.com\/erdenray\/\"><span class=\"u-icon u-social-icon u-social-instagram u-icon-3\"><svg class=\"u-svg-link\" preserveAspectRatio=\"xMidYMin slice\" viewBox=\"0 0 112 112\" style=\"\"><use xlink:href=\"#svg-5397\"><\/use><\/svg><svg class=\"u-svg-content\" viewBox=\"0 0 112 112\" x=\"0\" y=\"0\" id=\"svg-5397\"><circle fill=\"currentColor\" cx=\"56.1\" cy=\"56.1\" r=\"55\"><\/circle><path fill=\"#FFFFFF\" d=\"M55.9,38.2c-9.9,0-17.9,8-17.9,17.9C38,66,46,74,55.9,74c9.9,0,17.9-8,17.9-17.9C73.8,46.2,65.8,38.2,55.9,38.2\nz M55.9,66.4c-5.7,0-10.3-4.6-10.3-10.3c-0.1-5.7,4.6-10.3,10.3-10.3c5.7,0,10.3,4.6,10.3,10.3C66.2,61.8,61.6,66.4,55.9,66.4z\"><\/path><path fill=\"#FFFFFF\" d=\"M74.3,33.5c-2.3,0-4.2,1.9-4.2,4.2s1.9,4.2,4.2,4.2s4.2-1.9,4.2-4.2S76.6,33.5,74.3,33.5z\"><\/path><path fill=\"#FFFFFF\" d=\"M73.1,21.3H38.6c-9.7,0-17.5,7.9-17.5,17.5v34.5c0,9.7,7.9,17.6,17.5,17.6h34.5c9.7,0,17.5-7.9,17.5-17.5V38.8\nC90.6,29.1,82.7,21.3,73.1,21.3z M83,73.3c0,5.5-4.5,9.9-9.9,9.9H38.6c-5.5,0-9.9-4.5-9.9-9.9V38.8c0-5.5,4.5-9.9,9.9-9.9h34.5\nc5.5,0,9.9,4.5,9.9,9.9V73.3z\"><\/path><\/svg><\/span>\n          <\/a>\n          <a class=\"u-social-url\" target=\"_blank\" data-type=\"YouTube\" title=\"YouTube\" href=\"https:\/\/www.youtube.com\/channel\/UCNN_MT-0jUwoeMo5MLTZRxw\"><span class=\"u-icon u-social-icon u-social-youtube u-icon-4\"><svg class=\"u-svg-link\" preserveAspectRatio=\"xMidYMin slice\" viewBox=\"0 0 112 112\" style=\"\"><use xlink:href=\"#svg-09d5\"><\/use><\/svg><svg class=\"u-svg-content\" viewBox=\"0 0 112 112\" x=\"0\" y=\"0\" id=\"svg-09d5\"><circle fill=\"currentColor\" cx=\"56.1\" cy=\"56.1\" r=\"55\"><\/circle><path fill=\"#FFFFFF\" d=\"M74.9,33.3H37.3c-7.4,0-13.4,6-13.4,13.4v18.8c0,7.4,6,13.4,13.4,13.4h37.6c7.4,0,13.4-6,13.4-13.4V46.7 C88.3,39.3,82.3,33.3,74.9,33.3L74.9,33.3z M65.9,57l-17.6,8.4c-0.5,0.2-1-0.1-1-0.6V47.5c0-0.5,0.6-0.9,1-0.6l17.6,8.9 C66.4,56,66.4,56.8,65.9,57L65.9,57z\"><\/path><\/svg><\/span>\n          <\/a>\n          <a class=\"u-social-url\" target=\"_blank\" data-type=\"LinkedIn\" title=\"LinkedIn\" href=\"https:\/\/www.linkedin.com\/in\/ray-erden-m-a-business-economics-71b3a43\"><span class=\"u-icon u-social-icon u-social-linkedin u-icon-5\"><svg class=\"u-svg-link\" preserveAspectRatio=\"xMidYMin slice\" viewBox=\"0 0 112 112\" style=\"\"><use xlink:href=\"#svg-12ad\"><\/use><\/svg><svg class=\"u-svg-content\" viewBox=\"0 0 112 112\" x=\"0\" y=\"0\" id=\"svg-12ad\"><circle fill=\"currentColor\" cx=\"56.1\" cy=\"56.1\" r=\"55\"><\/circle><path fill=\"#FFFFFF\" d=\"M41.3,83.7H27.9V43.4h13.4V83.7z M34.6,37.9L34.6,37.9c-4.6,0-7.5-3.1-7.5-7c0-4,3-7,7.6-7s7.4,3,7.5,7\n            C42.2,34.8,39.2,37.9,34.6,37.9z M89.6,83.7H76.2V62.2c0-5.4-1.9-9.1-6.8-9.1c-3.7,0-5.9,2.5-6.9,4.9c-0.4,0.9-0.4,2.1-0.4,3.3v22.5\n            H48.7c0,0,0.2-36.5,0-40.3h13.4v5.7c1.8-2.7,5-6.7,12.1-6.7c8.8,0,15.4,5.8,15.4,18.1V83.7z\"><\/path><\/svg><\/span>\n          <\/a>\n        <\/div>\n      <\/div>\n    <\/section>\n    \n    \n    \n  \n","protected":false},"excerpt":{"rendered":"<p>Previous Next EXCEL SCREENCASTING Below videos illustrate various concepts and methods that can be performed in MS Excel.&nbsp; Index Function Demo in ExcelIn this sample I present how to use Index function where VLOOKUP function fails to work for more complex lookup tasks. Time Value of Money Excel ApplicationThis video displays how Excel VBA programming &hellip; <a href=\"https:\/\/www.rayerden.com\/index.php\/my-screencast\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;MY SCREENCASTS&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-126","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/pages\/126","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/comments?post=126"}],"version-history":[{"count":13,"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/pages\/126\/revisions"}],"predecessor-version":[{"id":219,"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/pages\/126\/revisions\/219"}],"wp:attachment":[{"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/media?parent=126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}