Are you over 18 and want to see adult content?
More Annotations
A complete backup of https://neindiana.com
Are you over 18 and want to see adult content?
A complete backup of https://gravitymedia.com
Are you over 18 and want to see adult content?
A complete backup of https://princesscruises.de
Are you over 18 and want to see adult content?
A complete backup of https://apk4game.mobi
Are you over 18 and want to see adult content?
A complete backup of https://aspadecoracion.com
Are you over 18 and want to see adult content?
A complete backup of https://abahouse.co.jp
Are you over 18 and want to see adult content?
A complete backup of https://foroalphas.com
Are you over 18 and want to see adult content?
A complete backup of https://dhis.org
Are you over 18 and want to see adult content?
A complete backup of https://bildungsspender.de
Are you over 18 and want to see adult content?
A complete backup of https://stussy.com
Are you over 18 and want to see adult content?
A complete backup of https://zyexcellent.com
Are you over 18 and want to see adult content?
A complete backup of https://aspenmp.com
Are you over 18 and want to see adult content?
Favourite Annotations
A complete backup of www.amarujala.com/photo-gallery/entertainment/bollywood/shilpa-shetty-raj-kundra-welcome-their-second-child
Are you over 18 and want to see adult content?
A complete backup of www.cbssports.com/nba/news/lakers-to-waive-demarcus-cousins-clear-path-to-sign-markieff-morris-after-buyout
Are you over 18 and want to see adult content?
A complete backup of mundo.sputniknews.com/sociedad/202002211090551853--labios-tatuados-y-cortes-en-la-espalda-espeluznantes-det
Are you over 18 and want to see adult content?
A complete backup of www.superhaber.tv/izmir-bombasi-nasil-yapilir-izmir-bombasi-tarifi-iste-gelinim-mutfakta-bugunku-tatlinin-m
Are you over 18 and want to see adult content?
Text
EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel. ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner. VIDEO LESSON: BEGINNER’S INTRODUCTION TO EXCEL Video Lesson: Beginner’s Introduction to Excel. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go oversome
INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. EXCEL TEMPLATES TO HELP WITH BUDGET MANAGEMENT The Personal Budget Worksheet. Vertex42 has developed a budget management template to help you track and organize your personal finances. You can use the Personal Budget Worksheet to assess your spending and check if it’s within the allocated budget. This template even has a field for discretionary spending, so you can trackyour expenses in
EXCEL 2016: IFS FUNCTION MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel. ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner. VIDEO LESSON: BEGINNER’S INTRODUCTION TO EXCEL Video Lesson: Beginner’s Introduction to Excel. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go oversome
INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. EXCEL TEMPLATES TO HELP WITH BUDGET MANAGEMENT The Personal Budget Worksheet. Vertex42 has developed a budget management template to help you track and organize your personal finances. You can use the Personal Budget Worksheet to assess your spending and check if it’s within the allocated budget. This template even has a field for discretionary spending, so you can trackyour expenses in
EXCEL 2016: IFS FUNCTION MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
GETTING STARTED
The goal of Excel Exposure is to be an easy reference for Excel users of all skill levels helping you to develop and refine your skills, become more efficient, gaining self-confidence, and, saving time! Since creating the site in 2011 it has evolved to be one of the leading free Excel training platforms available.MASTER WORKBOOK
The workbook should work as intended with Microsoft Excel 2010, 2013 and 2016, although the videos are recorded in MS Excel 2010. For those with Excel 2003 or earlier, there is an alternative .xls version at the bottom of this page. Download here: Excel Exposure Master Workbook 10-1-2019. Tip: Be sure to click ‘Enable Editing’ in the top ABOUT BEN – EXCEL EXPOSURE In addition to Excel Exposure’s online video lessons, I also offer Business & Finance Training workshops of varying length for online and/or on-site employee training. Please contact me directly via email or LinkedIn for more information: Preferred Email: Ben@ExcelExposure.com. Working on my new Excel Exposure course in my home-office (2/1/2019). HOMEPAGE | EXCEL EXPOSURE Unlock Your Inner Excel Ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career. VIDEO LESSON: BEGINNER’S INTRODUCTION TO EXCEL Video Lesson: Beginner’s Introduction to Excel. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go oversome
EXCEL EXPOSURE
Excel Exposure – Shortcuts Cheat Sheet. Thanks for submitting your email to receive the Excel Exposure Shortcuts Cheat Sheet! Feel free to print this cheat sheet out and keep it at your desk for easy reference! Click here to download the PDF of the Cheat Sheet. For a full listing of ALL Excel Shortcuts & Functions, check out the MasterWorkbook!
VIDEO LESSON: ADVANCED LOOKUP Video Lesson: Advanced Lookup – Index & Match. The versatility and usefulness of the Index and Match functions are cherished by Excel veterans, but many less experienced users have either not encountered them, or are a bit confused by the usage of the two. This Excel Video Lesson shows you how you can use the Index & Match functions to do EXCEL VIDEO LESSON: TEXT FUNCTIONS Excel Video Lesson: Text Functions. This video tutorial is a demonstration of the Experience Level 1 Text functions. Make sure to download the newest version of the Master Workbook that I updated earlier today to follow along. If playback doesn't begin shortly, try restarting your device. Videos you watch may be added to the TV'swatch history
PROTECTING AND HIDING INFORMATION AND FORMULAS Thanks again to Nick Williams at Acuity Training for this guest post!. When creating an Excel spreadsheet that is going to be sent on, particularly to those less Excel savvy, it can be useful to restrict certain functionality, as well as hide information and formulas. VBA WALKTHROUGH #2: MESSAGE ENCODER & DECODER VBA Walkthrough #2: Message Encoder & Decoder. This VBA macro is hopefully a bit more interesting than the last, and shows how I created a message encryptor/decryptor in Excel using VBA/macros. Download the Message Encryptor & Decryptor here to follow along with the video lesson. If playback doesn't begin shortly, try restartingyour device.
EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel. ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner. HOMEPAGE | EXCEL EXPOSURE Unlock Your Inner Excel Ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career. VIDEO LESSON: BEGINNER’S INTRODUCTION TO EXCEL Video Lesson: Beginner’s Introduction to Excel. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go oversome
INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. EXCEL TEMPLATES TO HELP WITH BUDGET MANAGEMENT The Personal Budget Worksheet. Vertex42 has developed a budget management template to help you track and organize your personal finances. You can use the Personal Budget Worksheet to assess your spending and check if it’s within the allocated budget. This template even has a field for discretionary spending, so you can trackyour expenses in
EXCEL 2016: IFS FUNCTION MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel. ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner. HOMEPAGE | EXCEL EXPOSURE Unlock Your Inner Excel Ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career. VIDEO LESSON: BEGINNER’S INTRODUCTION TO EXCEL Video Lesson: Beginner’s Introduction to Excel. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go oversome
INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. EXCEL TEMPLATES TO HELP WITH BUDGET MANAGEMENT The Personal Budget Worksheet. Vertex42 has developed a budget management template to help you track and organize your personal finances. You can use the Personal Budget Worksheet to assess your spending and check if it’s within the allocated budget. This template even has a field for discretionary spending, so you can trackyour expenses in
EXCEL 2016: IFS FUNCTION MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
COURSES – EXCEL EXPOSURE Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel.GETTING STARTED
The goal of Excel Exposure is to be an easy reference for Excel users of all skill levels helping you to develop and refine your skills, become more efficient, gaining self-confidence, and, saving time! Since creating the site in 2011 it has evolved to be one of the leading free Excel training platforms available. HOMEPAGE | EXCEL EXPOSURE Unlock Your Inner Excel Ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career. ABOUT BEN – EXCEL EXPOSURE In addition to Excel Exposure’s online video lessons, I also offer Business & Finance Training workshops of varying length for online and/or on-site employee training. Please contact me directly via email or LinkedIn for more information: Preferred Email: Ben@ExcelExposure.com. Working on my new Excel Exposure course in my home-office (2/1/2019).VBA / MACROS
Using macros in Excel requires knowledge of Visual Basic for Applications (VBA). In this video lesson you will get an introduction to how macros work within Excel and how to build them. The video lesson includes the following topics: – Setting up Excel workbooks to use Macros & VBA (filetype, menu and security settings). – . EXCEL ESSENTIALS COURSE Five hours of NEW Excel training from Excel Exposure! Payment below provides access to ALL videos and access to the exclusive Facebook group! Over $1,200 value now available for just $197! Email Ben@ExcelExposure.com for inquiries on bulk purchase discounts. First video in the course is FREE! VIDEO LESSON: ADVANCED LOOKUP Video Lesson: Advanced Lookup – Index & Match. The versatility and usefulness of the Index and Match functions are cherished by Excel veterans, but many less experienced users have either not encountered them, or are a bit confused by the usage of the two. This Excel Video Lesson shows you how you can use the Index & Match functions to do INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
EXCEL 2013: REAL WORLD EXAMPLES OF NEW FUNCTIONS Real World Examples of Excel 2013’s New Functions Microsoft included over 50 new functions with Excel 2013, and I wanted to walk you through a few real world examples of these new additions. You’ll soon be able to see how handy these extra toolsEXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel. ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner. HOMEPAGE | EXCEL EXPOSURE Unlock Your Inner Excel Ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career. VIDEO LESSON: BEGINNER’S INTRODUCTION TO EXCEL Video Lesson: Beginner’s Introduction to Excel. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go oversome
INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. EXCEL TEMPLATES TO HELP WITH BUDGET MANAGEMENT The Personal Budget Worksheet. Vertex42 has developed a budget management template to help you track and organize your personal finances. You can use the Personal Budget Worksheet to assess your spending and check if it’s within the allocated budget. This template even has a field for discretionary spending, so you can trackyour expenses in
PROTECTING AND HIDING INFORMATION AND FORMULAS Thanks again to Nick Williams at Acuity Training for this guest post!. When creating an Excel spreadsheet that is going to be sent on, particularly to those less Excel savvy, it can be useful to restrict certain functionality, as well as hide information and formulas. MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel. ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner. HOMEPAGE | EXCEL EXPOSURE Unlock Your Inner Excel Ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career. VIDEO LESSON: BEGINNER’S INTRODUCTION TO EXCEL Video Lesson: Beginner’s Introduction to Excel. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go oversome
INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. EXCEL TEMPLATES TO HELP WITH BUDGET MANAGEMENT The Personal Budget Worksheet. Vertex42 has developed a budget management template to help you track and organize your personal finances. You can use the Personal Budget Worksheet to assess your spending and check if it’s within the allocated budget. This template even has a field for discretionary spending, so you can trackyour expenses in
PROTECTING AND HIDING INFORMATION AND FORMULAS Thanks again to Nick Williams at Acuity Training for this guest post!. When creating an Excel spreadsheet that is going to be sent on, particularly to those less Excel savvy, it can be useful to restrict certain functionality, as well as hide information and formulas. MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
COURSES – EXCEL EXPOSURE Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel.GETTING STARTED
The goal of Excel Exposure is to be an easy reference for Excel users of all skill levels helping you to develop and refine your skills, become more efficient, gaining self-confidence, and, saving time! Since creating the site in 2011 it has evolved to be one of the leading free Excel training platforms available. HOMEPAGE | EXCEL EXPOSURE Unlock Your Inner Excel Ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career. ABOUT BEN – EXCEL EXPOSURE In addition to Excel Exposure’s online video lessons, I also offer Business & Finance Training workshops of varying length for online and/or on-site employee training. Please contact me directly via email or LinkedIn for more information: Preferred Email: Ben@ExcelExposure.com. Working on my new Excel Exposure course in my home-office (2/1/2019).VBA / MACROS
Using macros in Excel requires knowledge of Visual Basic for Applications (VBA). In this video lesson you will get an introduction to how macros work within Excel and how to build them. The video lesson includes the following topics: – Setting up Excel workbooks to use Macros & VBA (filetype, menu and security settings). – . EXCEL ESSENTIALS COURSE Five hours of NEW Excel training from Excel Exposure! Payment below provides access to ALL videos and access to the exclusive Facebook group! Over $1,200 value now available for just $197! Email Ben@ExcelExposure.com for inquiries on bulk purchase discounts. First video in the course is FREE! INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. VIDEO LESSON: ADVANCED LOOKUP Video Lesson: Advanced Lookup – Index & Match. The versatility and usefulness of the Index and Match functions are cherished by Excel veterans, but many less experienced users have either not encountered them, or are a bit confused by the usage of the two. This Excel Video Lesson shows you how you can use the Index & Match functions to do VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
EXCEL SHORTCUTS TO SAVE YOU TIME! CTRL + [DRAG SHEET Excel Shortcuts to Save You Time! Powered By: Navigation CTRL + Page Up Moves to the next sheet (right) in a workbook. CTRL + Page Down Moves to the previous sheet (left) in a workbook.EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel.GETTING STARTED
The goal of Excel Exposure is to be an easy reference for Excel users of all skill levels helping you to develop and refine your skills, become more efficient, gaining self-confidence, and, saving time! Since creating the site in 2011 it has evolved to be one of the leading free Excel training platforms available. ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner. EXCEL TEMPLATES TO HELP WITH BUDGET MANAGEMENT The Personal Budget Worksheet. Vertex42 has developed a budget management template to help you track and organize your personal finances. You can use the Personal Budget Worksheet to assess your spending and check if it’s within the allocated budget. This template even has a field for discretionary spending, so you can trackyour expenses in
INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. HOW TO RECOVER UNSAVED EXCEL FILES In order to recover an Excel file that you forget to save, follow the steps below. Go to the file tab and click on ‘Open’. Now click on the Recent Workbooks option on the top left. Now scroll to the bottom and click on ‘Recover Unsaved Workbooks’ button. Scroll throughthe list
INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel.GETTING STARTED
The goal of Excel Exposure is to be an easy reference for Excel users of all skill levels helping you to develop and refine your skills, become more efficient, gaining self-confidence, and, saving time! Since creating the site in 2011 it has evolved to be one of the leading free Excel training platforms available. ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner. EXCEL TEMPLATES TO HELP WITH BUDGET MANAGEMENT The Personal Budget Worksheet. Vertex42 has developed a budget management template to help you track and organize your personal finances. You can use the Personal Budget Worksheet to assess your spending and check if it’s within the allocated budget. This template even has a field for discretionary spending, so you can trackyour expenses in
INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. HOW TO RECOVER UNSAVED EXCEL FILES In order to recover an Excel file that you forget to save, follow the steps below. Go to the file tab and click on ‘Open’. Now click on the Recent Workbooks option on the top left. Now scroll to the bottom and click on ‘Recover Unsaved Workbooks’ button. Scroll throughthe list
INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
MASTER WORKBOOK
The workbook should work as intended with Microsoft Excel 2010, 2013 and 2016, although the videos are recorded in MS Excel 2010. For those with Excel 2003 or earlier, there is an alternative .xls version at the bottom of this page. Download here: Excel Exposure Master Workbook 10-1-2019. Tip: Be sure to click ‘Enable Editing’ in the top ABOUT BEN – EXCEL EXPOSURE In addition to Excel Exposure’s online video lessons, I also offer Business & Finance Training workshops of varying length for online and/or on-site employee training. Please contact me directly via email or LinkedIn for more information: Preferred Email: Ben@ExcelExposure.com. Working on my new Excel Exposure course in my home-office (2/1/2019). VIDEO LESSON: BEGINNER’S INTRODUCTION TO EXCEL Video Lesson: Beginner’s Introduction to Excel. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go oversome
VIDEO LESSON: ADVANCED LOOKUP Video Lesson: Advanced Lookup – Index & Match. The versatility and usefulness of the Index and Match functions are cherished by Excel veterans, but many less experienced users have either not encountered them, or are a bit confused by the usage of the two. This Excel Video Lesson shows you how you can use the Index & Match functions to do EXCEL VIDEO LESSON: TEXT FUNCTIONS Excel Video Lesson: Text Functions. This video tutorial is a demonstration of the Experience Level 1 Text functions. Make sure to download the newest version of the Master Workbook that I updated earlier today to follow along. If playback doesn't begin shortly, try restarting your device. Videos you watch may be added to the TV'swatch history
HOMEPAGE | EXCEL EXPOSURE Unlock Your Inner Excel Ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career. VIDEO LESSON: BASIC EXCEL FORMATTING TECHNIQUES Video Lesson: Basic Excel Formatting Techniques. 96 Comments / Formatting / By cobainbc15. Today’s video lesson goes through some of the basic formatting techniques in Excel 2010: – How to Use the Auto-Fill Drag Handle / Fill Series Options. – How to Use the Format Painter. – Freeze / Unfreeze Panes. – Sheet Formatting (ColoringTabs
INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. PROTECTING AND HIDING INFORMATION AND FORMULAS Thanks again to Nick Williams at Acuity Training for this guest post!. When creating an Excel spreadsheet that is going to be sent on, particularly to those less Excel savvy, it can be useful to restrict certain functionality, as well as hide information and formulas. VBA WALKTHROUGH #2: MESSAGE ENCODER & DECODER VBA Walkthrough #2: Message Encoder & Decoder. This VBA macro is hopefully a bit more interesting than the last, and shows how I created a message encryptor/decryptor in Excel using VBA/macros. Download the Message Encryptor & Decryptor here to follow along with the video lesson. If playback doesn't begin shortly, try restartingyour device.
EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel.GETTING STARTED
The goal of Excel Exposure is to be an easy reference for Excel users of all skill levels helping you to develop and refine your skills, become more efficient, gaining self-confidence, and, saving time! Since creating the site in 2011 it has evolved to be one of the leading free Excel training platforms available. ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner. EXCEL TEMPLATES TO HELP WITH BUDGET MANAGEMENT The Personal Budget Worksheet. Vertex42 has developed a budget management template to help you track and organize your personal finances. You can use the Personal Budget Worksheet to assess your spending and check if it’s within the allocated budget. This template even has a field for discretionary spending, so you can trackyour expenses in
INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. HOW TO RECOVER UNSAVED EXCEL FILES In order to recover an Excel file that you forget to save, follow the steps below. Go to the file tab and click on ‘Open’. Now click on the Recent Workbooks option on the top left. Now scroll to the bottom and click on ‘Recover Unsaved Workbooks’ button. Scroll throughthe list
INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel.GETTING STARTED
The goal of Excel Exposure is to be an easy reference for Excel users of all skill levels helping you to develop and refine your skills, become more efficient, gaining self-confidence, and, saving time! Since creating the site in 2011 it has evolved to be one of the leading free Excel training platforms available. ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner. EXCEL TEMPLATES TO HELP WITH BUDGET MANAGEMENT The Personal Budget Worksheet. Vertex42 has developed a budget management template to help you track and organize your personal finances. You can use the Personal Budget Worksheet to assess your spending and check if it’s within the allocated budget. This template even has a field for discretionary spending, so you can trackyour expenses in
INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. HOW TO RECOVER UNSAVED EXCEL FILES In order to recover an Excel file that you forget to save, follow the steps below. Go to the file tab and click on ‘Open’. Now click on the Recent Workbooks option on the top left. Now scroll to the bottom and click on ‘Recover Unsaved Workbooks’ button. Scroll throughthe list
INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
MASTER WORKBOOK
The workbook should work as intended with Microsoft Excel 2010, 2013 and 2016, although the videos are recorded in MS Excel 2010. For those with Excel 2003 or earlier, there is an alternative .xls version at the bottom of this page. Download here: Excel Exposure Master Workbook 10-1-2019. Tip: Be sure to click ‘Enable Editing’ in the top ABOUT BEN – EXCEL EXPOSURE In addition to Excel Exposure’s online video lessons, I also offer Business & Finance Training workshops of varying length for online and/or on-site employee training. Please contact me directly via email or LinkedIn for more information: Preferred Email: Ben@ExcelExposure.com. Working on my new Excel Exposure course in my home-office (2/1/2019). VIDEO LESSON: BEGINNER’S INTRODUCTION TO EXCEL Video Lesson: Beginner’s Introduction to Excel. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go oversome
VIDEO LESSON: ADVANCED LOOKUP Video Lesson: Advanced Lookup – Index & Match. The versatility and usefulness of the Index and Match functions are cherished by Excel veterans, but many less experienced users have either not encountered them, or are a bit confused by the usage of the two. This Excel Video Lesson shows you how you can use the Index & Match functions to do EXCEL VIDEO LESSON: TEXT FUNCTIONS Excel Video Lesson: Text Functions. This video tutorial is a demonstration of the Experience Level 1 Text functions. Make sure to download the newest version of the Master Workbook that I updated earlier today to follow along. If playback doesn't begin shortly, try restarting your device. Videos you watch may be added to the TV'swatch history
HOMEPAGE | EXCEL EXPOSURE Unlock Your Inner Excel Ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career. VIDEO LESSON: BASIC EXCEL FORMATTING TECHNIQUES Video Lesson: Basic Excel Formatting Techniques. 96 Comments / Formatting / By cobainbc15. Today’s video lesson goes through some of the basic formatting techniques in Excel 2010: – How to Use the Auto-Fill Drag Handle / Fill Series Options. – How to Use the Format Painter. – Freeze / Unfreeze Panes. – Sheet Formatting (ColoringTabs
INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. PROTECTING AND HIDING INFORMATION AND FORMULAS Thanks again to Nick Williams at Acuity Training for this guest post!. When creating an Excel spreadsheet that is going to be sent on, particularly to those less Excel savvy, it can be useful to restrict certain functionality, as well as hide information and formulas. VBA WALKTHROUGH #2: MESSAGE ENCODER & DECODER VBA Walkthrough #2: Message Encoder & Decoder. This VBA macro is hopefully a bit more interesting than the last, and shows how I created a message encryptor/decryptor in Excel using VBA/macros. Download the Message Encryptor & Decryptor here to follow along with the video lesson. If playback doesn't begin shortly, try restartingyour device.
EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel.GETTING STARTED
The goal of Excel Exposure is to be an easy reference for Excel users of all skill levels helping you to develop and refine your skills, become more efficient, gaining self-confidence, and, saving time! Since creating the site in 2011 it has evolved to be one of the leading free Excel training platforms available. ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner. EXCEL TEMPLATES TO HELP WITH BUDGET MANAGEMENT The Personal Budget Worksheet. Vertex42 has developed a budget management template to help you track and organize your personal finances. You can use the Personal Budget Worksheet to assess your spending and check if it’s within the allocated budget. This template even has a field for discretionary spending, so you can trackyour expenses in
INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. HOW TO RECOVER UNSAVED EXCEL FILES In order to recover an Excel file that you forget to save, follow the steps below. Go to the file tab and click on ‘Open’. Now click on the Recent Workbooks option on the top left. Now scroll to the bottom and click on ‘Recover Unsaved Workbooks’ button. Scroll throughthe list
INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel.GETTING STARTED
The goal of Excel Exposure is to be an easy reference for Excel users of all skill levels helping you to develop and refine your skills, become more efficient, gaining self-confidence, and, saving time! Since creating the site in 2011 it has evolved to be one of the leading free Excel training platforms available. ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner. EXCEL TEMPLATES TO HELP WITH BUDGET MANAGEMENT The Personal Budget Worksheet. Vertex42 has developed a budget management template to help you track and organize your personal finances. You can use the Personal Budget Worksheet to assess your spending and check if it’s within the allocated budget. This template even has a field for discretionary spending, so you can trackyour expenses in
INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. HOW TO RECOVER UNSAVED EXCEL FILES In order to recover an Excel file that you forget to save, follow the steps below. Go to the file tab and click on ‘Open’. Now click on the Recent Workbooks option on the top left. Now scroll to the bottom and click on ‘Recover Unsaved Workbooks’ button. Scroll throughthe list
INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
MASTER WORKBOOK
The workbook should work as intended with Microsoft Excel 2010, 2013 and 2016, although the videos are recorded in MS Excel 2010. For those with Excel 2003 or earlier, there is an alternative .xls version at the bottom of this page. Download here: Excel Exposure Master Workbook 10-1-2019. Tip: Be sure to click ‘Enable Editing’ in the top ABOUT BEN – EXCEL EXPOSURE In addition to Excel Exposure’s online video lessons, I also offer Business & Finance Training workshops of varying length for online and/or on-site employee training. Please contact me directly via email or LinkedIn for more information: Preferred Email: Ben@ExcelExposure.com. Working on my new Excel Exposure course in my home-office (2/1/2019). VIDEO LESSON: BEGINNER’S INTRODUCTION TO EXCEL Video Lesson: Beginner’s Introduction to Excel. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go oversome
VIDEO LESSON: ADVANCED LOOKUP Video Lesson: Advanced Lookup – Index & Match. The versatility and usefulness of the Index and Match functions are cherished by Excel veterans, but many less experienced users have either not encountered them, or are a bit confused by the usage of the two. This Excel Video Lesson shows you how you can use the Index & Match functions to do EXCEL VIDEO LESSON: TEXT FUNCTIONS Excel Video Lesson: Text Functions. This video tutorial is a demonstration of the Experience Level 1 Text functions. Make sure to download the newest version of the Master Workbook that I updated earlier today to follow along. If playback doesn't begin shortly, try restarting your device. Videos you watch may be added to the TV'swatch history
HOMEPAGE | EXCEL EXPOSURE Unlock Your Inner Excel Ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career. VIDEO LESSON: BASIC EXCEL FORMATTING TECHNIQUES Video Lesson: Basic Excel Formatting Techniques. 96 Comments / Formatting / By cobainbc15. Today’s video lesson goes through some of the basic formatting techniques in Excel 2010: – How to Use the Auto-Fill Drag Handle / Fill Series Options. – How to Use the Format Painter. – Freeze / Unfreeze Panes. – Sheet Formatting (ColoringTabs
INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. PROTECTING AND HIDING INFORMATION AND FORMULAS Thanks again to Nick Williams at Acuity Training for this guest post!. When creating an Excel spreadsheet that is going to be sent on, particularly to those less Excel savvy, it can be useful to restrict certain functionality, as well as hide information and formulas. VBA WALKTHROUGH #2: MESSAGE ENCODER & DECODER VBA Walkthrough #2: Message Encoder & Decoder. This VBA macro is hopefully a bit more interesting than the last, and shows how I created a message encryptor/decryptor in Excel using VBA/macros. Download the Message Encryptor & Decryptor here to follow along with the video lesson. If playback doesn't begin shortly, try restartingyour device.
EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel. HOMEPAGE | EXCEL EXPOSURE Unlock Your Inner Excel Ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career. ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner. VIDEO LESSON: BEGINNER’S INTRODUCTION TO EXCEL Video Lesson: Beginner’s Introduction to Excel. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go oversome
INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. EXCEL TEMPLATES TO HELP WITH BUDGET MANAGEMENT The Personal Budget Worksheet. Vertex42 has developed a budget management template to help you track and organize your personal finances. You can use the Personal Budget Worksheet to assess your spending and check if it’s within the allocated budget. This template even has a field for discretionary spending, so you can trackyour expenses in
EXCEL 2016: IFS FUNCTION PROTECTING AND HIDING INFORMATION AND FORMULAS Thanks again to Nick Williams at Acuity Training for this guest post!. When creating an Excel spreadsheet that is going to be sent on, particularly to those less Excel savvy, it can be useful to restrict certain functionality, as well as hide information and formulas. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel. HOMEPAGE | EXCEL EXPOSURE Unlock Your Inner Excel Ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career. ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner. VIDEO LESSON: BEGINNER’S INTRODUCTION TO EXCEL Video Lesson: Beginner’s Introduction to Excel. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go oversome
INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. EXCEL TEMPLATES TO HELP WITH BUDGET MANAGEMENT The Personal Budget Worksheet. Vertex42 has developed a budget management template to help you track and organize your personal finances. You can use the Personal Budget Worksheet to assess your spending and check if it’s within the allocated budget. This template even has a field for discretionary spending, so you can trackyour expenses in
EXCEL 2016: IFS FUNCTION PROTECTING AND HIDING INFORMATION AND FORMULAS Thanks again to Nick Williams at Acuity Training for this guest post!. When creating an Excel spreadsheet that is going to be sent on, particularly to those less Excel savvy, it can be useful to restrict certain functionality, as well as hide information and formulas. VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
GETTING STARTED
The goal of Excel Exposure is to be an easy reference for Excel users of all skill levels helping you to develop and refine your skills, become more efficient, gaining self-confidence, and, saving time! Since creating the site in 2011 it has evolved to be one of the leading free Excel training platforms available. HOMEPAGE | EXCEL EXPOSURE Unlock Your Inner Excel Ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.VBA / MACROS
Using macros in Excel requires knowledge of Visual Basic for Applications (VBA). In this video lesson you will get an introduction to how macros work within Excel and how to build them. The video lesson includes the following topics: – Setting up Excel workbooks to use Macros & VBA (filetype, menu and security settings). – . ABOUT BEN – EXCEL EXPOSURE In addition to Excel Exposure’s online video lessons, I also offer Business & Finance Training workshops of varying length for online and/or on-site employee training. Please contact me directly via email or LinkedIn for more information: Preferred Email: Ben@ExcelExposure.com. Working on my new Excel Exposure course in my home-office (2/1/2019).EXCEL EXPOSURE
We'll email you a "magic one click login" link. Install this app.Terms of Service
EXCEL ESSENTIALS COURSE Five hours of NEW Excel training from Excel Exposure! Payment below provides access to ALL videos and access to the exclusive Facebook group! Over $1,200 value now available for just $197! Email Ben@ExcelExposure.com for inquiries on bulk purchase discounts. First video in the course is FREE! VIDEO LESSON: ADVANCED LOOKUP Video Lesson: Advanced Lookup – Index & Match. The versatility and usefulness of the Index and Match functions are cherished by Excel veterans, but many less experienced users have either not encountered them, or are a bit confused by the usage of the two. This Excel Video Lesson shows you how you can use the Index & Match functions to do MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models.SITE POLICIES
Below you will find the privacy policies and related documentation: If there appears to be any part of the site that gives you concern in relation to any of these policies (or if you think there’s a violation), please reach out to Ben@ExcelExposure.com and let me know!EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel.GETTING STARTED
The goal of Excel Exposure is to be an easy reference for Excel users of all skill levels helping you to develop and refine your skills, become more efficient, gaining self-confidence, and, saving time! Since creating the site in 2011 it has evolved to be one of the leading free Excel training platforms available. VIDEO LESSON: BEGINNER’S INTRODUCTION TO EXCEL Video Lesson: Beginner’s Introduction to Excel. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go oversome
ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner.VBA IMPORTANT TIPS
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel. INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. HOW TO RECOVER UNSAVED EXCEL FILES In order to recover an Excel file that you forget to save, follow the steps below. Go to the file tab and click on ‘Open’. Now click on the Recent Workbooks option on the top left. Now scroll to the bottom and click on ‘Recover Unsaved Workbooks’ button. Scroll throughthe list
MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models.EXCEL EXPOSURE
Unlock your inner Excel ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.LESSON GUIDE
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel.GETTING STARTED
The goal of Excel Exposure is to be an easy reference for Excel users of all skill levels helping you to develop and refine your skills, become more efficient, gaining self-confidence, and, saving time! Since creating the site in 2011 it has evolved to be one of the leading free Excel training platforms available. VIDEO LESSON: BEGINNER’S INTRODUCTION TO EXCEL Video Lesson: Beginner’s Introduction to Excel. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go oversome
ALTERNATIVE TO MERGED CELLS (QUICK TIP) Here is a screenshot of how to find it / use it by right clicking on a range and going to ‘Format Cells’. Then click the Alignment tab as shown below (the Center Across Selection option): Voila! The text is centered across multiple cells without the need for merging them. You can also remove the gridlines in Excel to make it look a bit cleaner.VBA IMPORTANT TIPS
Check out the new course! Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel. INTRO TO FINANCIAL MODELING PART 3 In the cash row of the balance sheet the formula is. = Max (closing cash balance,0) This will ensure that if the cash balance is negative that it is not show here as a negative figure. In the overdraft row, insert. =-Min (closing cash balance,0) This will ensure that if it is a negative figure it will be shown here. HOW TO RECOVER UNSAVED EXCEL FILES In order to recover an Excel file that you forget to save, follow the steps below. Go to the file tab and click on ‘Open’. Now click on the Recent Workbooks option on the top left. Now scroll to the bottom and click on ‘Recover Unsaved Workbooks’ button. Scroll throughthe list
MICROSOFT EXCEL ERROR This is what you need to do to change the settings back again-. Go over to the File Menu and click on Options. In the Options window, choose the last tab, Trusted Centre. Now click on ‘ Trusted Center Settings ’. In the new window, choose ‘ Protected View ’. Unchecked all the options available and click OK. INTRODUCTION TO POWER PIVOT Introduction to Power Pivot. Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!!. Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models.VBA / MACROS
Using macros in Excel requires knowledge of Visual Basic for Applications (VBA). In this video lesson you will get an introduction to how macros work within Excel and how to build them. The video lesson includes the following topics: – Setting up Excel workbooks to use Macros & VBA (filetype, menu and security settings). – . HOMEPAGE | EXCEL EXPOSURE Unlock Your Inner Excel Ninja! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.EXCEL EXPOSURE
We'll email you a "magic one click login" link. Install this app.Terms of Service
HOW TO RECOVER UNSAVED EXCEL FILES In order to recover an Excel file that you forget to save, follow the steps below. Go to the file tab and click on ‘Open’. Now click on the Recent Workbooks option on the top left. Now scroll to the bottom and click on ‘Recover Unsaved Workbooks’ button. Scroll throughthe list
EXCEL ESSENTIALS COURSE Five hours of NEW Excel training from Excel Exposure! Payment below provides access to ALL videos and access to the exclusive Facebook group! Over $1,200 value now available for just $197! Email Ben@ExcelExposure.com for inquiries on bulk purchase discounts. First video in the course is FREE! PROTECTING AND HIDING INFORMATION AND FORMULAS Thanks again to Nick Williams at Acuity Training for this guest post!. When creating an Excel spreadsheet that is going to be sent on, particularly to those less Excel savvy, it can be useful to restrict certain functionality, as well as hide information and formulas. INTRODUCTION TO FINANCIAL MODELING Thanks to Nick Williams of Acuity Training (a provider of Excel courses in London and Manchester, UK) for providing this helpful series of posts on using Excel for financial modelling.. Introduction to Financial Modeling in Excel Who is the article aimed at? This series of five articles is designed for anyone who wants to learn how to build and / or manipulate financial models built in Excel. VIDEO LESSON: BASIC EXCEL FORMATTING TECHNIQUES Video Lesson: Basic Excel Formatting Techniques. 96 Comments / Formatting / By cobainbc15. Today’s video lesson goes through some of the basic formatting techniques in Excel 2010: – How to Use the Auto-Fill Drag Handle / Fill Series Options. – How to Use the Format Painter. – Freeze / Unfreeze Panes. – Sheet Formatting (ColoringTabs
VBA WALKTHROUGH #1: PURCHASE ORDER GENERATOR In this video lesson, I walk you through a Purchase Order Generator that I created using Excel and VBA. Throughout the video, the following topics are discussed: – How to create unique userforms which allow users to input information in a separate window. – Usage of VBA userform toolbox items such as Label, ListBox, TextBox, andButtons.
VIDEO LESSON: CONDITIONAL FORMATTING IN EXCEL Conditional Formatting can be very useful when presenting data in a spreadsheet, or for allowing information to jump out to you easily. In the following video lesson I go over the following uses of it: – Formatting based on numerical values (greater than, less than, between, etc). – Formatting based on text contained in cells.EXCEL EXPOSURE
Learn Excel Online!
Skip to content
* Home
* Excel Essentials
* Get Started
* Lesson Guide
* Master Workbook
* Press
* About
* Testimonials
* Partners
* Policies
LEARN EXCEL ONLINE
FREE & PREMIUM ONLINE EXCEL TRAINING! UNLOCK YOUR INNER EXCEL NINJA! At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career. Whether you’re looking to save time, reduce errors, or just feel confident in your technical skills, I’m here to help! I look forward to seeing your skills far surpass your wildestexpectations!
There are over 5 hours of free lessons on the site, so feel free todive right in…
UPDATE 7/11/2019 – EXCEL ESSENTIALS IS NOW AVAILABLE FOR EARLY ACCESS MEMBERS THROUGH AUGUST 15TH FOR ONLY $50!!! I’m so excited to be launching the course today! Click the button below for more info!!! UPDATE 7/1/2019 – NEW COURSE SITE POSTED TONIGHT WITH 1ST VIDEO! I will be uploading a new video for the Excel Essentials course based on the schedule on the site, with all videos be released by August 15th, 2019! Starting today, you can see the first video which will be FREE for everyone as a preview! MODULE 0 – VIDEO 1: WHAT IS EXCEL? In this first video lesson to the course, I show some examples of Excel usage via my acronym F. I. R. E. D. which will help you get an understanding of what Excel is and how it is typically used. It’s live at the bottom of the new course page: Please forgive my reclusiveness and excuse the dust as I’m launching some things regarding the new Excel Essentials course and changing the site a bit. I appreciate your patience and look forward to teachingyou Excel!
TO SIGN UP FOR THE NEW COURSE, CLICK HERE AND PUT YOUR EMAIL FOR THELATEST UPDATES!
OTHER NEWS – RECENT UPDATES 6/7/2019 – INTERACTIVE CHEAT SHEET WITH VIDEO RELEASED! FREE EXCEL TRAINING STARTS HERE For the free course, I’d recommend checking out the Lesson Guide which lists the lessons in the ideal order for viewing, especially if you plan on going through the course start to finish. Before watching the videos, make sure to download the Master Workbook full of great practice examples and tons of resources to follow along! Newest Free Lessons (most recent lesson – Sept 2018): Introduction to Financial Modeling – Part 1 Introduction to Financial Modeling – Part 2 Introduction to Financial Modeling – Part 3 Introduction to Financial Modeling – Part 4 WORKBOOK & REFERENCE – VIDEO LESSONS * BEGINNER’S INTRODUCTION TO EXCEL * BASIC FORMATTING TECHNIQUES * CONDITIONAL FORMATTING * NAMING RANGES AND CELLS * AUTO-FILTER AND ADVANCED DATA FILTERING * INTRODUCTION TO PIVOT TABLES * ADVANCED PIVOT TABLES – ROUND 1 * ADVANCED PIVOT TABLES – ROUND 2 * CREATING AND DESIGNING CHARTS (INCLUDING SPARKLINES) * DATA VALIDATION WITH IN-CELL DROP-DOWN LIST * FORMULA AUDITING & FORMULA EVALUATION * CELL REFERENCING – ABSOLUTE VS. RELATIVE * FIVE POWERFUL EXCEL TIPS * ERROR CHECKING AND DATA MONITORING * PROTECTING AND HIDING INFORMATION AND FORMULAS * EXCEL 2013: DATA MODEL TUTORIAL FUNCTION & FORMULA – VIDEO LESSONS * MATH & STATISTICAL FUNCTIONS (E.G. SUM, AVERAGE) * LOOKUP & REFERENCE FUNCTIONS (E.G. VLOOKUP, MATCH) * ADVANCED VLOOKUP EXAMPLES * ADVANCED INDEX & MATCH LOOKUP EXAMPLES * DATE & TIME FUNCTIONS (E.G. TODAY, MONTH) * Text Functions (e.g. LEN, CONCATENATE) * LOGICAL FUNCTIONS (E.G. IF, AND) * INFORMATION FUNCTIONS (E.G. CELL, ISNUMBER) * Excel 2013: Real World Examples of New Functions * EXCEL 2016: IFS FUNCTION MACROS / VBA – VIDEO LESSONS * INTRODUCTION TO MACROS & VBA PROGRAMMING * LEARN BY DOING: INTRO TO VBA VIA ADDING CHARTS EXAMPLE * VBA MACRO WALKTHROUGH #1: PURCHASE ORDER GENERATOR * VBA MACRO WALKTHROUGH #2: MESSAGE ENCODER & DECODER * VBA IMPORTANT TIPS EXCEL TUTORIALS, TRICKS & QUICK TIPS (NON-VIDEO LESSONS) * HOW TO RECOVER UNSAVED EXCEL FILES * INTRODUCTION TO POWER PIVOT * INTRODUCTION TO TABLES* WHAT-IF ANALYSIS
* GROUPING AND UNGROUPING ROWS / COLUMNS * ALTERNATIVE TO MERGED CELLS AND HOW TO REMOVE GRIDLINES * EXTRACT LIST FROM DATA WITH DUPLICATE VALUES REMOVED * EXCEL BOOK AND WEBSITE RECOMMENDATION LINKS 368 RESPONSES TO _LEARN EXCEL ONLINE_*
Anthony says:
June 19, 2019 at 4:23 am What a great resource. Link for the 75% off training offer did not work. Hoping you’ll honor that price…Reply
*
cobainbc15 says:
June 19, 2019 at 4:38 am Absolutely, and in case it isn’t obvious, course is slightly delayed but I hope to have an update video later today! I’ll look into thatlink too!
Reply
*
WENDY TOLBERT says:
June 15, 2019 at 3:43 pm Hi…love what you’re doing. Signed up for $50 early price but didn’t receive confirmation. Can you send manual confirmation?Reply
*
cobainbc15 says:
June 15, 2019 at 5:36 pmHey Wendy,
Sorry for the confusion, I didn’t want to bombard people’s inboxeswith updates.
I’m running slightly behind schedule in terms of getting everything finalized but the course is coming out beautifully. Look out for anupdate later today!
Also, glad you’re excited, I am tooCheers,
Ben
Reply
*
Gladys Ogidi says:
May 28, 2019 at 6:37 am Love this. Will love to enroll.Reply
*
Aimé says:
May 19, 2019 at 8:08 pm You’re saving people professional carrrers with your video tutorials and most comprehensive excel lessons. I really appreciate what you’re doing here and beyond!! Keep up the great work!!!Reply
*
Justin says:
March 10, 2019 at 4:30 pm Love this site, thank you!Reply
*
OLADIRAN, OLUSOLA ADEBAYO says: May 14, 2019 at 1:18 am It is very interesting and helpful. I appreciate this.Reply
*
Ankit Aneja says:
February 13, 2019 at 12:30 am I struggled with Excel during my MBA days, after going through your tutorials I wonder why? I feel sometime we complicate things unnecessarily. Thank you for keeping it simpleReply
*
Brittany says:
January 4, 2019 at 12:32 pm I took this for my MBA business analytics class last year and it was extremely helpful. I was definitely ahead of the curve when my class started and aced my way out after watching all of these videos. Thankyou for sharing!
Reply
*
Dave says:
December 27, 2018 at 11:39 amYour amazing
Reply
*
Anita says:
December 15, 2018 at 1:14 pm Thank you so much for this information!!!!!Reply
*
Rachel K Raymond says: November 8, 2018 at 3:01 pm I enjoy the practicality of these videos, no time wasted. Thanks.Reply
*
yuvraj says:
November 8, 2018 at 1:22 am you are awesome.. you made excel learning easy with your videos…thanks a lot.Reply
*
pankaj kumar verma says: November 4, 2018 at 10:42 pm Its amazing. First of all I would like to give big thanks for this website where we got a chance to learn a complete package of Excel . Keep it up. It’s really too good work brother. God bless you.Reply
*
Angie Skipton says:
November 4, 2018 at 7:54 pm Hi I am from Costa Rica and I am very grateful for this training you put online,.Thank you so much and God bless you.Reply
*
Aliha says:
October 20, 2018 at 8:53 am Ben, this is really very nice of you to make this website. I have learnt major excel skills through this website, which helps me a lotat my workplace.
I found you after searching for various excel websites and programs ongoogle.
I also have recommended excelexposure.com to a numberrrrrr of people to get benefited and enjoy free of cost on-going learning. I really really appreciate your work, and thankful for the resourcesyou have provided.
Reply
*
Tech lover says:
October 5, 2018 at 10:39 pm I’m currently in the Peace Corps and i was looking for ways to gain new skills and I figured learning Excel would be a great way to utilize my time, so after searching through so many online courses, I found Excelexposure.com and I’m highly impressed, it’s so easy to follow, I can always go back and review and go at my own pace, this is amazing, thank you Ben!!Reply
*
Morning Star Trickey says: September 29, 2018 at 12:24 am When I found your site it blew my mind! Thank you for this wonderful resource. This course is much easier to work with than many I have taken in ‘institutions’. Again, thank you!Reply
*
random thoughts says: September 25, 2018 at 5:34 amYou’re amazing
Reply
*
Mark says:
September 21, 2018 at 11:01 am Ben, as usual, great work!!! MarkReply
*
Jen says:
September 18, 2018 at 10:59 amWow
I’m so happy to have found your lessons. Thank you very much for taking the time to create and share theselessons.
Jen
Reply
*
Surat Ragini says:
August 27, 2018 at 2:08 am very good stuff for excel learningReply
*
srishti says:
August 11, 2018 at 10:32 pm I have just started the course and it’s amazing.Thank you sir!
Reply
*
Davai Nyet says:
June 11, 2018 at 11:36 am Hello dude, thank you so much for all of the videos! These help me immensely. I hope you continue doing these videos when you can.Reply
*
parul bansal says:
May 7, 2018 at 6:55 am very helpful videos sir!!!!Reply
*
Ilmari says:
April 18, 2018 at 4:24 pm Amazing stuff man. You do it with class, understandably clearly. I wish you continue your work so we can get some more complicatedlessons!
Reply
*
Loren says:
April 4, 2018 at 3:18 pm Wonderful course! I’ve been learning a lot, thank you for sharing your knowledge! Btw which software you use to record your videos? I’ve been looking for a good one!Reply
*
Gaudelia Elizabeth C Rueda says: February 25, 2018 at 7:14 pm thanks so much for sharing your knowledge am very interested to learnReply
*
irem says:
February 25, 2018 at 1:59 pm I loved your website!! hope you keep doing more videos on excelReply
*
SELA A says:
February 20, 2018 at 5:42 am Thank you so much. Very useful and easy to understand.Reply
*
NAGESH says:
February 19, 2018 at 12:49 pm Thanks and appreciate your efforts in structuring the training. do you suggest any similar course for MS word or PowerpointReply
*
Abdullah says:
February 15, 2018 at 4:11 amIts really helpful
Thank u so much
Reply
*
Laurie says:
January 29, 2018 at 9:10 pm Very helpful! Thank you indeed!!!Reply
*
Pankhuri says:
January 22, 2018 at 6:49 pm Hi, thanks for creating this website. I am going through it and I’m finding it quite useful.Reply
*
Annih says:
January 21, 2018 at 3:16 am very interesting lesson. great job. learnt so much in such a shorttime
Reply
*
Anonymous says:
January 8, 2018 at 11:03 am What about the planned lessons? When will they be out?Reply
*
cobainbc15 says:
January 10, 2018 at 2:01 pm Unfortunately, there’s no current planned timeline. I hope to get back into creating lessons soon, but my full-time job makes it a bit harder to find free time.Reply
*
Angelica says:
January 20, 2018 at 3:11 pm Thank you so much! Many of us really appreciate this!Reply
*
Bradley says:
January 4, 2019 at 10:23 am I am amazed that you took all the time to create the lessons you already have. Thanks for your efforts. They have made me a lot more comfortable and interested in my new line of work. I hope to see more videos at some point, but you’ve already helped more people than most!Reply
*
mathew says:
November 28, 2017 at 7:19 am This is a very nice resource – I noted no apparent, section on power query/get & transform. This is a very valuable tool, and does make my life with data and MI/BI so much easierReply
*
mathew says:
November 28, 2017 at 7:23 am I have since found power query within the power pivot section; but given the importance of power query, it might be wise to have a wholesection on this)
Reply
*
mo jo says:
November 23, 2017 at 3:52 pm Great job Ben! This is a great tutorial. Suggestion: Once I watched all (most) of your tutorials I would have loved a number of tasks that put into practice what I have learnt (with suggested solutions). Whilst I can do this myself I think it more beneficial if put together by someone who knows Excel + one would learn from your solutions.Reply
*
Alex says:
November 22, 2017 at 3:32 pm Fantastic! Really well done. Best Excel guide out there.Reply
*
Priya Iyengar says: November 19, 2017 at 4:25 am Hi am interested in this course.Reply
*
Joy Marie says:
November 8, 2017 at 4:16 am Hi, I am very interested for this excel courses?Reply
*
Beeni says:
November 2, 2017 at 6:58 am Excellent tutorials. Easy to follow and the Master Worksheet to accompany them is a great idea. Thank you very much for offering thesefree lessons !!
Reply
*
Jeff says:
October 3, 2017 at 2:39 pm I think this is the best excel refresher out there. Thanks so much for your time and dedication.Reply
*
Fede says:
October 3, 2017 at 8:19 am Hello I’m really happy to find this site! Now I find myself eager to start! But I wonder, am I going to need anything else than my computer with excel, I this practical o merely theoretical?Thanks,
Reply
*
Dejavu says:
January 11, 2018 at 7:26 pm I wonder – if you can check that just clicking on these links.Reply
*
Erick says:
October 3, 2017 at 1:54 am Hello. Thank you for putting time and effort to create such a brilliant work. Could you please advise when you will release the planned lessons? I can’t see to see your fantastic work.Thanks
Erick
Reply
*
Nitin Khapardey says: September 17, 2017 at 11:24 am Hello , Thanks for this course. Can you please tell me how to calculate mass, volume and density in spreadsheet?Reply
*
Sheila Mealer says:
September 17, 2017 at 8:58 am I am so excited that I found this web site training. My manager is grooming me for an advancement within my department and using excel is an important part. I can’t wait to get started, and get started onmy new adventure.
Reply
*
Rachael says:
September 16, 2017 at 4:46 am This is exciting I want to practice what I learnt and improve on mycareer
Reply
*
Frances Pitt says:
September 15, 2017 at 5:54 pm I am very interested in this excel programReply
*
imran khan says:
September 15, 2017 at 12:00 am how we can use comas ” in excelReply
*
Britteny Farmer says: September 1, 2017 at 4:52 pmHello –
I’m excited to start learning the excel program. This is opportunity will open many more doors for me in my career. Thank you!– Britteny
Reply
*
Bettye Gilkey says:
August 31, 2017 at 10:56 am As a retired corporate secretary, I’ve not kept my clerical skills current and desperately need to know Excel for employability in the marketplace. Please follow up on when class begins. Thanks much for your time and dedication!Reply
*
cobainbc15 says:
August 31, 2017 at 3:10 pmHi Betty,
Glad to hear that you’re interested in improving your Excel skills! All of the Excel lessons in the course are available online for free without any sign up requirements. I’d suggest checking out the Lesson Guide which has the lessons listed in the order they should be taken. Also, the Getting Started page is a good overview of how the course is set-up and meant to be utilized. Feel free to reach out with any other questions or suggestions.Cheers,
Ben
Reply
*
Corso Excel Online says: August 24, 2017 at 4:21 pm Thank you for that informations. I am an Italian Excel teacher and I found informations that I didn’t know. Thank You!Reply
*
Manjunath G S says:
August 11, 2017 at 1:02 am Your links work properly, Thank youReply
*
Chiraiya Sharma says: August 2, 2017 at 11:51 pm Thanks a lot dear. Keep up the good work. You really are a very kind &helping person.
Reply
*
asad says:
July 29, 2017 at 1:39 pm its very very helpful from at my work thank you so muchReply
*
Donna says:
July 25, 2017 at 6:20 am Thank you for the information very helpfulReply
*
Johnnie Woolard says: July 21, 2017 at 11:34 am Thank you for this valuable information. I used Excel many, many years ago but find I need more than just a brief refresher. This is going to be just what I need.Reply
*
Katz Vie says:
July 15, 2017 at 7:26 amThank you so much
Reply
*
Lakhan popandiya says: June 18, 2017 at 12:52 am Hi Ben, I have one query.. that how can I select cell in excel basedon cell border…
Reply
*
Tony Yahoo says:
August 28, 2017 at 8:09 am Control + W , then select no.Reply
*
Shanthi R says:
June 16, 2017 at 8:39 pm Your links are not working !!! It goes to “page not found tag”. I tried Advanced Pivot table-Round I and IIReply
*
Shanthi says:
June 16, 2017 at 8:38 pm Your links are not working !!! It goes to “page not found tag”. I tried Advanced Pivot table-Round I and IIReply
*
cobainbc15 says:
June 16, 2017 at 8:42 pm I’m on it! Thank you!!Reply
*
Lawrence mutumba says: June 13, 2017 at 1:26 pm I want to be an excel champion. How can u help mi?Reply
*
Charles Watson says: May 31, 2017 at 12:08 pm I am not sure what version I have but it’s what was put on my Apple when I bought it in 2013. I was working with a spreadsheet. Closed it and went to file to open another one. When I click on File Open Recent there is no listing. Only more. Click on that &it goes to online templates and of course there are none. I need to know how to get to my files. Can you help?Reply
*
Ashish Bhutada says: July 4, 2017 at 5:25 am Did you the excel file before closing it? You need to save the file on your device to open it next time or see in File Open Recent.Reply
*
Olatunji says:
May 30, 2017 at 7:25 am I stumbled on this and I found it quite interesting on account of the content. My Question: I would be working with excel spread sheet for generating quotation, do kindly guide on the aspect of excel to opt for considering my job description as stated above. Thanks inanticipation
Reply
*
Tihngang Cyril says: May 27, 2017 at 8:12 pm I will like to take this excel classes online how can I sign up ?Reply
*
Cecelyann Shelton says: May 23, 2017 at 1:55 pm I would like to take this free excel class. How do I register?Reply
*
Kausik Karmakar says: May 22, 2017 at 12:24 amDear Sir/Madam,
I want to be a excel champion..Please help me..Reply
*
Mandy Power says:
May 11, 2017 at 2:12 am How do I register for this courseReply
*
Genesis Te Huna says: May 10, 2017 at 7:08 pmHow do i register?
Reply
*
Elia mpondo says:
May 7, 2017 at 8:12 amGood
Reply
*
mocdstudio says:
May 5, 2017 at 12:47 am Thank you for sharing this useful information related to excel . Really this is awesome blog.Reply
*
Imtiyaz Ahmad Khan says: May 4, 2017 at 6:38 am Hello to Ben C-It is incredible to have available the list of different excel era guide.A question i am not finding a solution eg as we manually work/write on cash book then as per ledger folio we find different accounts and posting it on each respective personal accounts in the ledger,a ledger containing different columns from main cash book.now how it is possible that here from main C.B master excel sheet ( not in fixed ) some specified data whether all along or in breaks also auto exist in different each personal excel sheet ledger account without the efforts of copy paste posting.besides access,data base or tally/filter,software IS there any way to do such job..Kindly intimate me about how? Best Wishes Imtiyaz khanReply
*
Ahmer says:
May 4, 2017 at 2:21 amDear Sir,
Please see here below mentioned query for your easy understanding. I want to see the result in column E7 when i filter data in column A3 (Column E7) Vendor Name: (column A3) Vendor Name Abdul Aziz Fahad Al Hajri Est Ali-Ahmed-Al-Kanfari Gen. Co. Est. Amtar Al-Watan Const. & Dev. Est. Arab Al-Tamuz for Cont. Est. Arkal Est. for Cont.Danat Al-Rayan
Gray Falcon
Reply
*
Mweru anslem says:
May 3, 2017 at 9:38 am Thanks this is so helpful, am to work in a pharmacy, but on the side of tallying on pc but I have less knowledge on tallying, please someadvice, thank you!!
Reply
*
Imtiyaz khan says:
May 3, 2017 at 12:24 pm Hello to Free Excel Training.I am new to excel,If you put the free all excel era training in a simple way as a skill booster and enable me to generate a knowledge little by little perfectly.best wishes ImtiyazKhan
On Wed, May 3, 2017 at 9:09 PM, Free Excel Training! wrote: > Mweru anslem commented: “Thanks this is so helpful, am to work in a > pharmacy, but on the side of tallying on pc but I have less knowledge on > tallying, please some advice, thank you!!” >Reply
*
Aarti Arora says:
April 29, 2017 at 4:56 am Pls snd some more information on online excel classes as. I’m very much interested in learning excelReply
*
John L. Nelson says: April 24, 2017 at 8:09 am I am beginner level at best, however I need immediate (urgent) help to do a specific excel task. I need to consolidate 2 columns into one, then prepare add email addresses in preparation to export to Gmail. I have absolutely no problem paying you for your help. John Nelson… 713-943-0083Reply
*
Asit Waghani says:
April 25, 2017 at 11:53 amHello
I can help, please send me details…Reply
*
Reynaldo Mumme says: April 12, 2017 at 11:56 pm In other words, how can i search for forums that match what I want toread about?
Reply
*
Ben - Excel Exposure says: April 14, 2017 at 10:15 am Sorry, but I don’t quite understand your question.Reply
*
Anonymous says:
April 16, 2017 at 12:31 pm hello,i need help regarding excel, kindly help me outReply
*
Yesham says:
April 16, 2017 at 12:33 pm i need help regarding excel please help me outReply
*
Anonymous says:
April 12, 2017 at 3:51 am how can i do make index in excelReply
*
anupama tola says:
April 11, 2017 at 9:38 pm Want to learn Microsoft excelReply
*
cheryll says:
April 4, 2017 at 7:23 amgood
Reply
*
Curtissiz says:
April 3, 2017 at 8:34 pmbyqwevu
Reply
*
voma says:
April 3, 2017 at 12:01 am How we calculate using Microsoft excel?Reply
*
Rv says:
April 3, 2017 at 11:34 am apply this formula in excel spreadsheet where you want total.. Example … =sum(E1:E10) and press enter now you can get total amount from E1to E10
Reply
*
Anju Sreenivasan says: April 1, 2017 at 10:52 pm Pls details in excel online classReply
*
Excel VBA Tutorials says: July 25, 2017 at 3:38 am Thank you for sharing this useful information related to excel . Really this is awesome blog.Reply
*
Debbie says:
April 1, 2017 at 6:38 am I can not thank you enough for these free lessons. I am a working mom with two jobs and i dont have time or money to take classes outside the home. My boss is very advanced in Excel and it was hard for me to keep up. Your lessons have been a huge blessing and has taken alot of stress off of me. Thank you so much for sharing your time andknowledge!
Reply
*
Rv says:
April 3, 2017 at 11:36 am contact on Rajveer.jca@gmailReply
*
Wendy says:
March 29, 2017 at 7:48 pm I am interested to know more about the use of Excel and it’sformulas
Reply
*
Hafiz Mohsin Ali Khan says: March 24, 2017 at 10:52 amHi
I need to revised my excel with advance level my boss syed hurr recommended me this site may he live long for ever. Aameen.Reply
*
Jonathan Bloomfield says: March 23, 2017 at 4:53 am Do you have this but for 2016 versionReply
*
Silambarasan says:
March 19, 2017 at 11:31 am Pls details in excel online classReply
*
Viresh Sharma says:
March 18, 2017 at 9:26 pm Pl detail of excel online classesReply
*
Ahmed Islam says:
March 8, 2017 at 10:23 pm Very useful and i m recommended to all accounts .Reply
*
Ram sandhikar says:
March 4, 2017 at 2:36 am Looking to learn advance excel with macrosReply
*
Cheryl Pilcher says: March 3, 2017 at 10:14 am I need exposure to excel.but have to start at very beginning. Only one at work who’s too old to have had it in school. Age 55 and uncomfortable at work. not sure where to beginReply
*
uche says:
March 1, 2017 at 9:00 am When to learn hw to use excelReply
*
Antoinette Dauphin says: February 17, 2017 at 3:28 amI need help
Reply
*
Anonymous says:
February 21, 2017 at 3:03 pm Trying to make a booklet, when I have two pages on the screen, what do I do if I only want to change one of them without messing up theother?
Reply
*
divya says:
February 9, 2017 at 10:35 am As I’m nt able to either view or download video.. can u plzz suggestme.
Reply
*
Quentin Dunlop says: February 14, 2017 at 12:59 am You right click on the cell and click format cell. Next on the numbers tab, select custom. In the box that says general, remove that text, and insert the following in its place: ###,###,###,###,###.#######. This should give you the formatting you are looking for.Reply
*
Vipan says:
February 1, 2017 at 9:17 pmsir,
how can i write a value of amount 256,258.65 in excel in lieu of2,56,258.65
Reply
*
Vipan says:
February 1, 2017 at 9:20 pm what is formula, or function in window 2010.Reply
*
Imtiyaz Ahmad Khan says: January 25, 2017 at 10:24 am Hello Mr Ben and members-Self auto copy paste posting of each personal ledger accounts of specified data whether all along or with breaks not fixed way and continued process as an auto out reflection from Main master excel sheet containing a continuing data so to save extra efforts from it for copy paste posting to respective personal ledger accounts.What we write here should also auto exist in the each personal ledger/ac’s.what is way and how. Thanks with regardsImtiyaz khan
Reply
*
Imtiyaz Ahmad Khan says: January 25, 2017 at 8:01 am With regards to all the members.Kindly deliver free excel posts with training guide and expert advise to the solutions.Best Wishes ImtiyazKhan
Reply
*
12p1674 says:
January 23, 2017 at 1:36 am Is the advanced excel course similar to the CA- itt training excelsyllabus?
Reply
*
Jo says:
January 21, 2017 at 10:55 am Hi for Excel 2007 which path should I follow? thanks JReply
*
Rachael says:
January 17, 2017 at 11:44 am Hi, I just graduated with an associate degree In accounting. I would like to learn more specific to the job.Reply
*
Vaishali Vinerkar says: January 17, 2017 at 3:24 am Hi I would like to join online courseReply
*
olokunboro akinsanmi says: January 16, 2017 at 5:16 am pls i want to learn some basic aspects of excel and formulasReply
*
Mukisa Julius says:
January 15, 2017 at 2:46 am I Want More Guid On Excel Training Daily Am At Work With LittleComputer Skills
Reply
*
Shelene Kumar says:
January 12, 2017 at 8:14 pm Hi there please let me know how do I register with doing an excel beginner to intermediate courses thanks.Reply
*
Caroline says:
January 3, 2017 at 4:53 am I would like to know about the advanced Excel formating with the formulas. Can you let me know the online free course materialReply
*
chakminateur says:
February 7, 2017 at 2:04 pmBonsoir
pour excel je vous recommande cette chaine : https://www.youtube.com/channel/UCO_WB7GnmErcbQfUib1wjEA ce que j’aime dans cette chaine de 1 – une nouvelle chaine de 2 – ils mettent des les cours sous forme d’une playlist de 3 – les videos de 3-6 minutes, et c’est bien ils vous montrent en bref chaque point et vous pouvez continuer les point à votre rythme voilà.Reply
*
muhammad ishaq says: December 31, 2016 at 3:06 pmthank you
Reply
*
Tanay says:
December 25, 2016 at 12:43 pm Hi I want to take an online excel course please can you guide . I want to learn all the things including macros.Reply
*
Dominic says:
December 8, 2016 at 6:20 am Hi! I need to take an online course in excel, kindly guide me,Thanks,
Dominic
Reply
*
Edith Christian says: November 29, 2016 at 2:24 pm Hi I want to take an online excel course please can you guide . It’s the first time I will taking that course.Reply
*
Lee Wilson says:
November 30, 2016 at 9:36 am I am also interested in an online excel course….beginners!Reply
*
Kavitha t.v says:
November 29, 2016 at 4:42 amGood,thanks
Reply
*
Saleh Uddin says:
November 13, 2016 at 2:45 amGood
Reply
*
Anonymous says:
November 10, 2016 at 6:30 am Your tutorials are very helpful, i have tried several others and i had a hard time understanding them. Thanks a lot!!!Reply
*
Muhammad Riaz ul hasan says: October 28, 2016 at 9:44 pm Pl iwant to take excle basics computerReply
*
Shar says:
October 27, 2016 at 3:47 am I’ve had a look but cant find any lessons on doing Percentages%, is this something you have done and if not something you will do?Reply
*
Subhankar saha says: October 23, 2016 at 3:01 am I want to learn onlineReply
*
Yanga Thetha says:
October 21, 2016 at 8:12 am I’d recommend checking out the Lesson Guide which lists the lessons in the ideal order for viewing, especially if you plan on going through the course start to finish. As a side note, I recently received the 2016 Microsoft MVP Award for Excel in April 2016, the fourth year in a row! Thanks so much to all of you for making the sitesuch a success!
Reply
*
Kevin o sullivan says: October 19, 2016 at 4:10 am Would love to learn how to use excel. Is there any recognition with this online course as im trying to move up in work and need thisbehind me
Reply
*
worldsaparttogether says: October 18, 2016 at 5:59 pm So thankful for this website. Learning excel while traveling in Costa Rica, pretty awesome!Reply
*
Naveen Kumar says:
January 6, 2017 at 11:08 pm Nice pic sir please advise more Excell learningReply
*
linkirani says:
October 9, 2016 at 3:56 amHiiii
I m also interested to learn advanced excel kindly guide me sirReply
*
Shailina Rasyani says: January 10, 2017 at 5:04 pm Hey I want learn online excel can u guide me plzReply
*
Shad says:
September 26, 2016 at 7:08 pmIt is very useful
Reply
*
Paulina says:
September 25, 2016 at 7:44 am I am very interested to take on line training of excel, please guideme
Reply
*
Abdul Rahman says:
September 25, 2016 at 2:46 amHello sir,
I interested in learing MS EXCELL online programe could you please give me the details for joining the programe classes.Reply
*
Kavi says:
September 23, 2016 at 7:06 am I need to join plz guide. MeReply
*
Anonymous says:
September 21, 2016 at 4:44 am 1. I want to know the difference between two date and time, followingis the format:
Say two cells a1 & b1, a1 = 09/16/2016 T 06:11:37.924 and b1 = 09/16/2016 T 06:11:37.924 2. from above example i want to separate date and time in twodifferent cells.
Reply
*
Ananya says:
September 6, 2016 at 8:28 pm I am interested in this training programe could you please guide me about the same. Whats is the processReply
Reply
*
vasu says:
September 7, 2016 at 5:16 am I am very interested to take on line training of excel, please guideme
Reply
*
Praveen says:
August 29, 2016 at 6:43 pm I want to learn about advance Excel. Can you guide me. I am reallyinterested.
Reply
*
rohin says:
August 25, 2016 at 6:44 am i want knwlge about excel formulas lik vlookup hlookup pivots etc .with certificate .. give me infoReply
*
Anonymous says:
August 20, 2016 at 10:24 pm good program for us thunk uReply
*
Krishna prasad Ghimire says: August 19, 2016 at 10:07 pm I Need Learn More Knowledge On Excel But How….Reply
*
Anonymous says:
July 26, 2016 at 5:13 amHi
Want to join an online excell course . Please provide more information regarding the process .Reply
*
Go Daddy says:
October 21, 2016 at 4:54 pm Buy a book and install excelReply
*
bina bhatia says:
July 22, 2016 at 2:54 pm Pls provide the material where I can learn thisReply
*
Saijyothi says:
July 20, 2016 at 9:24 am Hi I want to join advanced excel training with VBA macros. My email id saijyothisv@gmail.com Do let me know the places in Bangalore.Reply
*
David Hughes says:
July 3, 2016 at 5:32 am I am interested in training could you please make download available.Reply
*
Anonymous says:
July 3, 2016 at 5:30 am I am interested in downloading videos. Could you supply the linkplease
Reply
*
Anonymous says:
July 8, 2016 at 2:44 amno sorry
Reply
*
Amrit Simkhada says: June 29, 2016 at 3:30 am I want to take this advance excel training what is the process???Reply
*
Cindy Cotton says:
June 18, 2016 at 7:52 am Hello interested in this course . Where can I get the link to download the videos? Thanks!!!!Reply
*
subhodeep says:
June 19, 2016 at 12:41 am i am also interested but want link of videos , let me also know if you get the link of videosReply
*
Subhodeep says:
June 18, 2016 at 2:42 am can you tell me from where can i download the video of the abovetutorials
Reply
*
Kevin says:
June 17, 2016 at 6:41 am Just wondering when your ‘Job Industry Specific’ lesson plans willbe available.
Reply
*
Christopher Navarro says: June 7, 2016 at 1:26 am I’m very interested in learning all about Excel because a lot of warehouse jobs I’m interested in require knowledge of this specific program. Please email me more information on how to get started.-Chris Navarro
Reply
*
Yadhuraj Reddy
says:
June 5, 2016 at 8:15 am I wants to learn more about excel http://www.excel-formulas.in/p/excel-vba-tutorial.html i was referring this website since i had interestReply
*
Anonymous says:
May 31, 2016 at 8:57 am Very helpful!!! explanations are very clear and understandable. Manythanks.
Reply
*
Akhilesh Shukla says: May 26, 2016 at 12:54 pm One of the best websites over the internet for excel. I would recommend to my friends.Reply
*
Anonymous says:
May 8, 2016 at 5:57 am Great Lessons, really appreciate it!!!Reply
*
caroline says:
April 26, 2016 at 3:30 pm I whant to learn more about excel spreadsheet every thing step by stepReply
*
Anonymous says:
April 30, 2016 at 10:14 am How to calculate the hours of waitingEg :
From
Date IN Time OUT Time 1-Apr-16 10:20 PM 11:45 PMto
Date IN Time OUT Time 2-Apr-16 5:30 AM 7:30 AMReply
*
Anonymous says:
May 19, 2016 at 4:01 am how to clculate my balance auto matically if i put cash remaining balance collect tell me process e.gMid SiM SR Date M.Sim Amount Cash Balance 1 16-5-16 30 3000 200 28002 17-5-16 300 ?
3 18-5-16 500 ?
how to automatically balance comes out?Reply
*
Rahul says:
June 12, 2016 at 12:30 am What I am getting that you want to calculate remaining balance. For have to apply formula–Example-
Total amount- 5000
Expence- 940
What is total remaining balance ??Formula is…
Put = in balance cell then put bracket start ( and drage left arrow to total amount put minus – then right arrow to expence cell then bracket close ) and tab. Will automatically show remaining amount.Reply
*
Ali says:
April 15, 2016 at 7:48 pm I want to learn basic computer skill and Excel for my small businessReply
*
N.Magesh says:
April 4, 2016 at 11:14 am Sir I need ms excel real time courseReply
*
James says:
March 25, 2016 at 8:03 pm So glad I found this site. I’ve been using excel pivot tables, formulas, and QA processes for a while but I’m slowly realizing the power of VBA. Looking forward to leaning in to your lessons.Reply
*
JRK PRASAD says:
March 18, 2016 at 10:35 amDear Sir,
I am Prasad. I got a query! I need to record Intime and Out time of Staff. When I enter in in time cell, Out time should Automatically calculate and get reflected in the out time cell without any further entry in the out time column. Is there any procedure Sir. If so please share me in the form of PPTplease
Reply
*
Jrk Prasad
says:
March 18, 2016 at 10:42 amDear Sir,
I am Prasad. I got a query! I need to record Intime and Out time of Staff. When I enter in in time cell, Out time should Automatically calculate and get reflected in the out time cell without any further entry in the out time column. Is there any procedure Sir. If so please share me in the form of PPTplease.
Reply
*
Rijin says:
March 7, 2016 at 11:33 pm I have an excel sheet of a company in this the persinal protective items are taken by the employees are added like cover all glasses .and from that i want to take only one item taken by all employee and create a list how can i do thatReply
*
Yadhuraj says:
January 9, 2016 at 10:27 pm i am interested to this lessonReply
*
orangefunbook says: January 9, 2016 at 10:30 pm I wants to learn more about excel http://www.excel-formulas.in/p/excel-vba-tutorial.html i was referring this website since i had interest.
Reply
*
webi jotham says:
December 28, 2015 at 12:02 am Am interested for the lessonsReply
*
Kaitlyn McLeish says: December 22, 2015 at 5:13 pm Loved it. Really interesting stuff. Thanks for taking the time towrite it
Reply
*
anju arora says:
December 22, 2015 at 7:26 am Need your help in excel formulas, Retrieving the Column Header of the Next Non-Blank Cell in a RowReply
*
Shanna says:
December 12, 2015 at 3:01 pm I am really impress with the quality. Keep up the great work. Does it have any for word, powerpoint and access ? It will be great as I am looking for the software for a reasonable price to put on my newcomputer.
Reply
*
Saah Maxwell Tosah says: November 30, 2015 at 8:44 am Thanks for all that you are doing to help learners. I am interested in doing some of the courses that you offer in excel.Maxwell
Reply
*
Anonymous says:
November 13, 2015 at 2:32 amupdate me
Reply
*
charity says:
October 23, 2015 at 6:13 am im intrested plz i want to learn exelReply
*
Mary says:
October 23, 2015 at 12:58 pm Need to learn exel. this was very interesting. Require classes.ThanksReply
*
Alisha Kasey says:
November 13, 2016 at 6:09 am I need to learn excell for my job position.Reply
*
arun says:
October 20, 2015 at 11:12 pm I want to learn basic xlReply
*
mark says:
October 13, 2015 at 7:29 am i love this site… i need to learn tooReply
*
Michael says:
September 30, 2015 at 2:58 am Please I would like to join your classes, what should I do to get thatopportunity
Reply
*
Becky colvin says:
September 28, 2015 at 9:32 pm I need to learn excel. I know a little. How do I get classesReply
*
Anonymous says:
September 16, 2015 at 6:55 am great, big up!!!!!!!Reply
*
Debbie Wayman says:
November 27, 2015 at 11:09 am I am interested. How do I get started?Reply
*
Gaurang modi says:
September 11, 2015 at 1:02 am Online Excel Training Course CD for available to advanceexcel..
Reply
*
Saicharan reddy N says: August 26, 2015 at 11:47 am Wanted to lean excel at reasonable price or if it is earn n learn alsoI preferable
Reply
*
Juliet feitelberg says: August 26, 2015 at 9:53 am Can u email me info for beginners course on excel the free course uhave thanks
Reply
*
Linda Coleman says:
August 24, 2015 at 9:36 am I am interested in learning more about this classReply
*
Nancye Pope says:
August 9, 2015 at 7:39 pm Interested in taking courseReply
*
eden says:
August 7, 2015 at 9:27 am Nice site.very helpful for novice like me.ill definitely go through all the videos! Thank you sir BenReply
*
Savita m says:
July 11, 2015 at 8:20 am I am interested in this courseReply
*
Luke says:
June 24, 2015 at 9:00 am Great! Thank you Reddit for sending me here. I can’t wait to see more lessonsReply
*
Cheang Keng Chai says: June 23, 2015 at 10:08 pm I would like to find out more for the excel courseReply
*
Lee Owens says:
June 14, 2015 at 10:22 pm Is Your Lesson combo FREE or not? Are they available right now?Reply
*
Alisha Kasey says:
June 13, 2015 at 10:34 pm I AM Interested In Taking This Class.Reply
*
www.celsias.com says: June 9, 2015 at 1:45 am Founded in 1913, the German company Claas is a market leader in Europe and one of the biggest manufacturers of combine harvesters in the world. Some health benefits that you can get by using this device arepreventing illness,
obesity, reducing tension and enhancing the immune system. And, rural broadband access today is as critical as roads, hospitals,clean water, etc.
Reply
*
Shahbuddin says:
June 8, 2015 at 12:31 pm Want to learn excel .any one can help me 9844519871Reply
*
Anonymous says:
August 10, 2015 at 3:42 pm Noup!! Only U!! Just do it!!Reply
*
yanni sarwon says:
June 1, 2015 at 9:00 am I want to be great at excel.Reply
*
Alison says:
May 18, 2015 at 12:20 pm I need to learn excel!Reply
*
dawn says:
May 4, 2015 at 8:53 pm I am very interested in this courseReply
*
Washington D. Dalamo says: April 29, 2015 at 7:58 am I am very much interested in doing this courseReply
*
Gerson Thomas Willie Damaseb says: April 26, 2015 at 9:27 pm I want to start with the traing as soon as possible.Reply
*
Vj says:
April 21, 2015 at 5:59 am I don’t have finance background, is the above planned excel course alone is enough for me to get job in finance analyst sort of roles?Reply
*
hamsa says:
April 18, 2015 at 2:15 am I want to learn exel please helpReply
*
varneishs says:
April 11, 2015 at 3:04 am I need to learn excel. Please help.Reply
*
Midstokke.85.Alison@aol.com says: March 23, 2015 at 10:18 am I am interested in taking this course.Thank You.
Reply
*
Elsie dyke says:
March 13, 2015 at 4:03 am Am interested thanks.Reply
*
Anonymous says:
February 14, 2015 at 5:25 amDear Sir ,
You have done excellent work for new users , I really appreciate yourworking.
This web is very helpful and useful for students and practical userseven ,
Great Working !
Reply
*
Dorian says:
February 10, 2015 at 11:11 amHey,
Thanks for all the videos. Just want to let you know Advanced Pivot Tables – Round 2 does not have an HD video up.Thanks again
Reply
*
Button says:
February 8, 2015 at 8:59 am I need to learn more about excel. I use it often but need it for analysis purposes at work. Can you help?Reply
*
Prabhuram varadharajan says: February 7, 2015 at 2:56 amHi,
I am interested in learning online course on excel. Do mail me thedetails.
Regards
Prabhuram
Reply
*
ateasweet says:
January 30, 2015 at 8:03 pm This really got me through there practice makes perfect cant wait to get data and information recorded too become more proficient.Reply
*
Tina Young says:
January 11, 2015 at 6:32 am Seeking online line help to learn any and all I can about using Excel..My new Job is requiring it to move up in my career which I’m trying to do..I don’t even know the basic please help I learn fast.Reply
*
Antay says:
January 5, 2015 at 7:29 am its great excel tutorialReply
*
Theresa Rosen says:
December 30, 2014 at 3:37 pm Need basic office skillsReply
*
Mani Seo says:
December 11, 2014 at 6:35 am I am from india , once i get place from here , more likee person , i am only . http://www.bangalorewebzone.comReply
*
Anonymous says:
November 28, 2014 at 2:59 pm Great resource! I’m also interested in FP&A and VBA lessons and plan to refer your website to my new associate/interns at my firm. Any plans to continue development of lessons?Reply
*
chrissykovalick says: November 4, 2014 at 7:55 am Need to learn fast for a jobReply
*
Anonymous says:
October 31, 2014 at 6:58 am I like ur lessons & enjoy them. thanks NaomiReply
*
Gail Vincelette says: October 6, 2014 at 8:39 amHi,
I am looking for a beginners course for the excel program. I need this for my job as they use the excel program quite often. I would very much appreciate if you could help me out with this.Thank You
Gail Vincelette
Reply
*
Levi says:
June 26, 2014 at 4:55 pm Very much look forward to the accounting & finance lesson plan! Any ETA on the release date?Reply
*
Ben - Excel Exposure says: July 15, 2014 at 1:38 pmHey Levi,
Sorry, things have been a bit busy here as I just moved across countryrecently.
I’ll try to record / get that lesson up soon, but I’m not sure exactly when unfortunately. Glad you like the site!Cheers,
Ben
Reply
*
Grant says:
August 6, 2014 at 12:16 pm I’m also very interested in this lesson (financial planning and analysis and accounting). Thanks so much for all the work you put into this site. It has helped me immensely.Reply
*
marilyn burgos says: August 30, 2014 at 1:29 am hi ,,,i am working in airline business and task primarily on annual leave processing for all pilot/cabin crew .. it is a repetitive process and am thinking of automate some of the process to make me effective thru excel. what do you think is the best excel technique to use for this application?thanksReply
*
Anonymous says:
May 25, 2014 at 3:40 am Thanks man, this is greatReply
*
Anonymous says:
March 8, 2014 at 3:48 am hi Ben I Have question related to workday.intl function in this function when i need the no of workdays which exclude the holiday’s but when i got the result I’m getting its surprising this farmula does not deduct the total no of holidays date wise why is it so.Reply
*
Marl Kens says:
March 7, 2014 at 9:49 am Hey, I just seen that sometimes this website shows an 403 server error. I thought you would be keen to know. ThanksReply
*
Raghavendra V B says: February 11, 2014 at 4:08 am Great webiste for excel beginners.. looking forward for more advance excel lessons whica can cover more advanced , complex formulas ,macros etc
Reply
*
Anonymous says:
January 29, 2014 at 6:19 pm Looking Forward for Accounting/Finance Related Tutorial.Reply
*
Mahesh says:
January 25, 2014 at 2:53 am Hey Ben, This is really a great help:)Reply
*
mekala kumar says:
January 7, 2014 at 9:34 am Excellent website. A lot of useful details here. I¡¦m providing it to some friends and also referring to in wonderful. And of course, thanks in your sweat! https://www.accounting-guru.net/features.htmlReply
*
Laura Selko says:
December 27, 2013 at 5:21 pm I’d like to learn more about excel.Reply
*
vigrxsoldinstores.unblog.frsays:
December 19, 2013 at 8:17 am Spot on with this write-up, I honestly feel this web site needs a great deal more attention. I’ll probably be back again to read through more, thanks for the advice!Reply
*
1 says:
December 8, 2013 at 5:09 am-1′
Reply
*
Sean W. says:
December 3, 2013 at 5:48 am Hi Ben, thanks for all the work you’ve done here. Helped improve my Excel chops immensely.Regards
Reply
*
SAQIB HUSSAIN LOHAR says: November 20, 2013 at 1:00 pmAssalam Alaikum
I am enjoying excel because of your great tutorials, really great jobThanks
Reply
*
Anonymous says:
October 15, 2013 at 7:30 am great site. congratsReply
*
casius says:
October 12, 2013 at 7:29 am as i said before this excel tutorial is pure magic:) but i really wait for accounting/finance applied excel ,when we can expect those ones?Reply
*
Sharon zeffiro says: October 6, 2013 at 10:31 am I can’t wait to try this! I need to learn this for a job.Reply
*
Abhishek Gulati says: October 2, 2013 at 1:48 pm Add Some Examples of HLOOKUP also.Reply
*
kishor says:
September 18, 2013 at 3:22 am please send me to my emailReply
*
Srikanth Perinkulam says: August 7, 2013 at 11:42 pm This is brilliant! Appreciate the efforts. Thanks.Reply
*
stephanie says:
July 31, 2013 at 10:23 am Hi, thank you so much for this excel free training, I am about to start a new job and I needed to brush up on my knowledge. Thank youReply
*
zubair says:
July 16, 2013 at 1:40 am Thank you for a wonderful resourceReply
*
RAGHAVENDHRA REDDY says: July 15, 2013 at 2:51 am VERY VERY USEFUL BEN…tHANKS ALOTReply
*
Mahmut Kaya says:
July 12, 2013 at 10:38 pm Thank you for all the time and effort you put into these videos. It is greatly appreciated!Reply
*
Anonymous says:
June 24, 2013 at 3:49 pmWonderful!
Reply
*
Ryan says:
June 3, 2013 at 12:44 pm awesome course, thank you!Reply
*
Anonymous says:
June 2, 2013 at 9:57 am you deserve the award; the material is organized and you present very well too (because i found i really learn something useful from you)Reply
*
Anonymous says:
May 29, 2013 at 6:05 am thank you so much for your time and such a great free excel trainingprogram.
Reply
*
rj says:
May 28, 2013 at 1:00 am im interested in taking this course. i wntd learn from beginner to master course. thnx. n great videos, keep uploading.Reply
*
Kevin says:
May 26, 2013 at 2:56 pm Great stuff! Thank you so muchReply
*
Moses Mwangi says:
May 25, 2013 at 6:16 pm Much appreciation for this great work, I was requesting if you can send me this tutorials for excel training which can be helpful to me, am Moses from Nairobi Kenya in Africa, am am a procurement student.Reply
*
Archchana says:
May 25, 2013 at 2:06 am This Website is amazing. How can I learn job specific financial excel elements? I am a finance student and it would be great if I couldlearn that too.
Reply
*
soesoemaung says:
May 20, 2013 at 9:27 amHow to lean
Reply
*
Wikidordrecht.nl says: May 16, 2013 at 11:42 pm I haven’t been on excelexposure.com in a while, just returned today.Reply
*
Asad says:
May 14, 2013 at 6:04 amHi
I’ve an issue.
I have a below data file and want to use Vlookup. But the data I want to fetch is conditional. Company City Charges CreditCustomer Contracted Ace Mumbai Prepaid No Yes Pace Delhi Collect Yes Yes Race Chennai Prepaid No No Ace Delhi Prepaid No Yes With regards to the above table we have n number of companies in varioud cities across the world and hence not sure how to apply a conditional Vlook up. From the above table, I would want to know if the company Ace located in Delhi is contracted with us. Kindly note that this customer has its branches connected with us throughout the world. Could you please suggest me some idea, would really be a big help!Thank you!
Reply
*
Ben - Excel Exposure says: May 15, 2013 at 2:34 amHey Asad,
I’ve created a working copy of the situation you mentioned. I did it using a COUNTIFS formula (which may or may not have been the most efficient choice, but it’s late and I’m heading to bed soon).Here’s the file:
http://excelexposure.files.wordpress.com/2013/05/asad-lookup-help.xlsx You could also accomplish this by using a ‘helper column’ in column A which could combine the company/city into one name using a formula like =B1&C1 which would come up as AceMumbai, and then you could do a vlookup on AceMumbai to see if it’s contracted. Either way works, but I hope that helps.Cheers,
Ben
Reply
*
Asad says:
May 15, 2013 at 10:40 amHello Ben
That definitely was a big help!Thanks a lot dear!
Reply
*
Anonymous says:
May 14, 2013 at 4:42 am This is utterly brilliant…and I haven’t even scratched the surface yet. Thanks so much.Reply
*
Ravi says:
May 14, 2013 at 3:53 am This is the BEST free educational service site. Thank YouReply
*
Anonymous says:
May 4, 2013 at 1:29 am i have a data where the cell value a1=praveen, but the rest of details of his name like contact number, email id, location are in different cells like b2,c3,d1. i want to bring all together. pls gide how?Reply
*
casius says:
April 27, 2013 at 6:07 pm Ben,one word ,AMAZING! thanks for unselfishly sharing precious knowledge and helping many people! Im looking forward to plan lessons-Financial planning and analysis,hope it’s gonna be soonposted:)
Reply
*
fattie says:
April 19, 2013 at 10:26 pm Thank you so much for your website and dedication, you surely deserve the MVP prize! Glad you are safe after what happened in Boston!Reply
*
cehv8 says:
April 19, 2013 at 7:03 am Hi there I am so glad I found your website, I really found you by accident, while I was searching on Aol for something else, Nonetheless I am here now and would just like tosay many
thanks for a incredible post and a all round enjoyable blog (I also love the theme/design), I don’t have time to read it all at the minute but I have book-marked it and also added your RSS feeds, so when I have time I will be back to read more, Please do keep up the excellent work.Reply
*
neelima says:
April 16, 2013 at 5:01 am Plz I want to know how to learn exalReply
*
Marivel Root says:
April 14, 2013 at 4:20 pm Congratulations! for winning/voted as the MVP – great job!!!Reply
*
MaxK says:
April 13, 2013 at 5:09 pm Ben, thanks so much and congratulations on the Microsoft MVP award! The content and examples are very very helpful and the presentation is crisp, precise. Very well deserved award! Would like to see an example combining pivot table and macros which takes data from different sheets to create charts. Thanks again!Reply
*
RAVI says:
April 12, 2013 at 3:05 am Hi Mr.Ben i have a query i have my monthly data plan in that i have to choose 3 maximum sales figure and as well as top 3 count i am facing a problem when i use countif it shrink my criteria it count only specfic given range and for the max when i use max fuction every time i have to hide my top 1 data after search is there any method pls help me out becouse my teacher i also doesn,t know. ram shyam ghyanshyam12 21 56
16 16 48
18 64 26
Reply
*
Kaul Ank says:
April 9, 2013 at 7:05 am Great step. There are so many excel websites these days but your content especially the videos are simply awesome. I am gonna followyour video channel.
Reply
*
Shina Gulati says:
April 9, 2013 at 6:35 am Hey. I would like to learn Financial Planning and Analysis using Excel. Could you let me know when are the planned courses takingplace?
Reply
*
sana ali says:
April 9, 2013 at 3:20 am beginer excel i want to lernReply
*
sana ali says:
April 9, 2013 at 3:18 am i want 2 lern excel plzgive me hintReply
*
patron says:
April 8, 2013 at 11:28 pm will this course prepare me for the excel certification?Reply
*
mahmud says:
April 8, 2013 at 9:00 pm it would be better for me if i had the link of vedio download. can anybody tell where is the download link?Reply
*
Anonymous says:
August 8, 2013 at 5:48 pm You’re able to download the video on Vimeo(where the video is hosted) in multiple formats. Click the vimeo icon at the lower right hand corner of a video and then you will find a download link below the video and description on Vimeo’s website.Reply
*
Bassou aalam says:
April 5, 2013 at 4:32 pm I like the sound of your tutorial As nearly certified prince2project manager I found out that is crucial to learn excel I hope you can help on thisMany thanks
Reply
*
Bassou aalam says:
April 5, 2013 at 4:52 pmHow do I
Go to you cite
Reply
*
Ben - Excel Exposure says: April 5, 2013 at 6:06 pmHi Bassou,
You’re already on the site. Just click any of the lessons above (or up top where it says ‘Lesson Guide’ for a listing of videos bydifficulty).
Hope that helps.
Ben
Reply
*
Bishnu Pradip Basyal says: April 15, 2013 at 11:02 am thank u sir editing this many usable things ,it makes us easy on mywork
Reply
*
Tyesh says:
April 4, 2013 at 4:51 pm I would like enroll as wellReply
*
Ben - Excel Exposure says: April 5, 2013 at 10:16 amHey Tyesh,
Sorry but I responded to Araceli below by email, but I’ll respond here in case others are wondering: You actually aren’t required to ‘enroll’ in order to see any of the videos/training material on the website. All of the lessons are listed in the homepage as well as the Lesson Guide (which groups them in order by difficulty). If you’d like to be listed on the student roster at University of Reddit, you can go to my course page and sign up for the course (but again, this is not required, although is good for communications). Try clicking Getting Started at the top if you’re still unsure aboutthe course format.
Hope that helps.
Cheers,
Ben
Reply
*
Araceli says:
April 3, 2013 at 5:24 pm I would like to enroll asap!Reply
*
Monika Barley says:
March 26, 2013 at 6:24 pm I would like to enrol on this course please.Reply
*
Laura Jayne says:
March 26, 2013 at 4:45 am Hi please can I enrol on this courseReply
*
Victor Anderson says: March 25, 2013 at 1:36 pm How do a round a decimal to the nearest quarter.i.e. 7.725 to 7.75
Reply
*
Ben - Excel Exposure says: March 26, 2013 at 1:15 pmHey Victor,
Assuming your variable that you’re trying to round is in A1, you’d use the following formula: =ROUND(A1/0.25,0)*0.25 I tried it with some examples and it works fine. Let me know if you have any other questions.Cheers,
Ben
Reply
*
Safiq says:
July 17, 2017 at 5:31 am thanks mr. Ben. it’s a great job for me and already i have benefited. I am with you Mr. Ben.Reply
*
Manuel says:
March 14, 2013 at 4:04 am Mach doch ma auf deutsch!!!Reply
*
Manuel says:
March 14, 2013 at 4:05 am but thanks, english is ok tooReply
*
nushig says:
March 11, 2013 at 11:09 am Been out of touch with Excel for a couple of years now, this has really refreshed my knowledge as well as learning new stuff aswell. One thing will you be covering data modelling in Excel. Predicting data, forecasting etc. ThanksReply
*
Ahmad Lukman Nulhakim says: March 11, 2013 at 4:17 am Excellent lessons!!!Reply
*
Manoranjan Sahoo says: March 6, 2013 at 8:49 am I want to learn advance excel with best examplesReply
*
Audrey Bennett says: March 4, 2013 at 4:35 am I need to learn excel for job applucations. Help!Reply
*
Artist Eloise Gale says: March 2, 2013 at 7:28 pm I would like to participate in your online excel course please.Regards
Eloise Gale
Reply
*
Bob Thomas says:
February 25, 2013 at 11:30 am These training modules are fantastic! I’ve been using Excel for years without really tapping into any of it’s more advanced features, and your training does a terrific job of providing quick, simple modules that are enormously helpful. Many thanks and great job!Reply
*
ajit says:
February 24, 2013 at 2:08 pm Hey mate Ben, I would like to congratulate you for your noble work. Please keep me posted with the future topic.Reply
*
prakash says:
February 16, 2013 at 1:30 amHi
I am doing simple agency business and i made entry for bills sold to my buyers in a sheet row wise 7 bills 7 rows each having ref no 1,2,3, and so on till 7. Now whenever i get payment i separate col in fornt of that ref no like ch no., chq date and amt. and i do enter the payment enrty in the same sheet. then i do bill amt – payment amt which comes to 0 hence payment for that bill is fully recd. Now today i got the joint payment for 3 bills with 5 cheques how i will do the entry i am facing problem. need your help.Reply
*
Beckham says:
February 12, 2013 at 2:46 pm I’ve got one for you. I know that there is a way to have Excel pull information from a database on the internet and to have excel update that information whenever you open the sheet, but what if you want it to pull from weekly reports? Is there a way to have Excel automatically recognize that there is a new document to pull information from and to have that information placed in a new sheetautomatically?
Reply
*
janitha95 says:
January 30, 2013 at 5:19 pm Thanks so much for all of your hard work. I look forward to digging into the lessons and becoming more than just an advanced beginner.Reply
*
shibu Purushothaman says: January 30, 2013 at 11:17 amnice
Reply
*
kandice says:
January 29, 2013 at 2:46 pm im interested in taking this course, but when you complete the course do u get a certificate?Reply
*
Anonymous says:
March 14, 2013 at 4:02 am of course not. Stupid!!!!Reply
*
venkat0249 says:
January 28, 2013 at 1:47 pm Very helpful course!!! I have been looking for something just like this for a long time. Atlast i found it here. many thanksReply
*
JD says:
January 28, 2013 at 12:30 am What a great course. I have been looking for something just like this.Reply
*
Anonymous says:
January 25, 2013 at 9:04 pm Hi, got a question. How can I copy data from one worksheet to another worksheet without using a copy/paste? using only a formula..Reply
*
Ben - Excel Exposure says: January 25, 2013 at 9:19 pm You can refer directly to the sheet. For example if Sheet1 has all the information you want, on sheet2 in cell A1 you can put=Sheet1!$A$1
And it will show the value that’s there, you could drag this down and across and it would show you what’s in those cells. (Now problems can come about when you start changing sheet1 depending onhow it’s setup).
You can also use INDIRECT() and/or OFFSET() functions to make sure it’s always pointing to cell A1. Hope that helps. Feel free to email me if you have further questions..Reply
*
Anonymous says:
April 3, 2013 at 12:23 pm ben i try =sheet1!$A$1 its awosome thanks.Reply
*
Quinten says:
January 25, 2013 at 7:02 pm Thank you for great videos!Reply
*
Mario Reto says:
January 24, 2013 at 3:35 pm Ben, thanks so much for these! Skimmed and they look great, can’t wait to fully watch when I have time later this week! CheersReply
*
Leon says:
January 24, 2013 at 12:25 pm How soon will the ideal order list be available? Definitely looking forward to these lessons and I’m a stickler for structured order.Reply
*
Ben - Excel Exposure says: January 24, 2013 at 1:06 pmHey Leon,
Just posted the Lesson Guide, as requested. You can see the link to it at the top of the page.Cheers,
Ben
Reply
*
Anonymous says:
January 23, 2013 at 10:40 pm MUCH APPRECIATED. THANK YOU!!!!!!!!!!!!!!!!Reply
*
Anonymous says:
January 23, 2013 at 2:52 am you’re awesome man. Greatly appreciate the great post!Reply
*
Dan says:
January 22, 2013 at 3:53 pm Man, this is really awesome. Will you be taking donations or anything? This is the kind of thing I love to contribute to.Reply
*
Anonymous says:
January 22, 2013 at 9:52 am how can a particular cell contain only 16 digits, and that also beginwith zero
Reply
*
Ben - Excel Exposure says: January 22, 2013 at 1:08 pm That would likely require custom formatting. If you’d like to email me, I can help you more easily.Reply
*
Anonymous says:
January 19, 2013 at 11:15 pm I found your instructional videos very helpful.Reply
*
Anonymous says:
January 16, 2013 at 11:19 pm Very nice, the pace is excellent. Keep up the great work!Reply
*
Anonymous says:
January 12, 2013 at 10:44 pm its very useful thanks a lotReply
*
Anonymous says:
January 10, 2013 at 2:10 am LOVE this! Thank you so much for taking the time to put this together for fellow Excellers!Reply
*
chip says:
January 9, 2013 at 7:28 pm I have an intermediate Excel test coming soon and I am hoping that by going over all of this, it will help me pass. I thought I knew Excel until I started going over this information. This has really helped mea lot.
Reply
*
Michelle says:
January 6, 2013 at 1:51 am Thank you, thank you, thank you!Reply
*
Bharath says:
January 5, 2013 at 4:40 pmThanks a lot!!!!!
Reply
*
Nadir says:
January 5, 2013 at 3:10 am i realy appreciate your Noble deedReply
*
www.katie-holland.com says: February 7, 2014 at 9:34 am Time to face the music armed with this great information.Reply
*
Anonymous says:
January 4, 2013 at 4:46 am Very good. I learned a lot.Reply
*
Kam says:
December 26, 2012 at 8:24 pmExcellent lessons
Reply
*
Jawed says:
December 23, 2012 at 8:53 am This is a great website with a lot of new information regarding Excel.Great Job !!!!
Reply
*
noob says:
December 20, 2012 at 11:12 am keep it coming this is awesomeReply
*
web data software says: December 18, 2012 at 5:18 pm Very quickly this website will be famous among all blog viewers, due to it’s pleasant articlesReply
*
Anonymous says:
December 13, 2012 at 3:55 pm thanks a lot !!! all the lessons were very helpful !!Reply
*
Anonymous says:
December 10, 2012 at 11:45 am Wow! very interesting and helpful site, thanks for sharing!Reply
*
Anonymous says:
December 6, 2012 at 6:13 am this is so great! Thank you very muchReply
*
Andres Lozano says:
November 15, 2012 at 9:34 pm Thank you for helping me improve my excel skills and knowledge! Iappreciate it!
Reply
*
mefeadman says:
November 14, 2012 at 12:49 amDear Ben,
I wanna thank you for your excellent excel course! you have changed mylife!
Reply
*
Victor Anderson says: November 13, 2012 at 10:36 pm This site is awesome. Thank you so much.Reply
*
Ali says:
November 8, 2012 at 1:36 am Interested in your planned lessons. When may i expect them?Reply
*
Anonymous says:
November 7, 2012 at 9:31 pm This is exactly what I have been looking for – thank you for providing the content and guidanceReply
*
Vicki says:
November 5, 2012 at 8:45 pm This is an amazing site !! Thank you !!!Reply
*
denise says:
November 1, 2012 at 3:00 pm Thanks for all the great information. Its very useful. Great workReply
*
John says:
October 29, 2012 at 10:37 am how does one write an “IF Function” in excel for a range…for example, if CELL C25 was equal to or less than 1 and equal to or greater than -1, the result would be 200%. how would the IF equation be written? I tried IF(c25=-1,200%,0%)Reply
*
Ben - Excel Exposure says: October 29, 2012 at 3:07 pm The IF statement you wrote would only work if it was equal to -1. For what you want, I think this formula should work just fine: =IF(AND(C25>=-1, C25<=1),200%,0%) That formula checks to see if C25 is greater than or equal to -1 AND whether C25 is less than or equal to 1 (using the AND() function).Hope that helps!
Reply
*
Anonymous says:
October 17, 2012 at 9:31 pm I like your instructions very much!! Thank you!Thanks,
MJ
Reply
*
Jim says:
October 11, 2012 at 2:01 am How much does your course cost? I’m interested in starting at the beginner level and advancing at least to the intermediate level.Thanks, Jim
Reply
*
Ben - Excel Exposure says: October 14, 2012 at 9:17 pmHi Jim,
The course is completely free. Go ahead and click on any of the links in the lesson plan above and it will take you to the relatedlesson/post.
Hope you enjoy it!
Reply
*
Steve says:
October 9, 2012 at 3:28 am Woah! very useful stuff, I am blown away. I will certainly review thisover and over again
Reply
*
sreedevi Ranjit, bangalore says: October 3, 2012 at 2:01 am very useful one.Every body can learn excel easily using this tutorialReply
*
Anonymous says:
September 30, 2012 at 6:21 pm Thanks for all the great information, you rock!Reply
*
bishal says:
September 22, 2012 at 6:45 pm great step,appreciate it !!!Reply
LEAVE A REPLY CANCEL REPLY This site uses Akismet to reduce spam. Learn how your comment data isprocessed .
*
MICROSOFT MVP PROFILE Microsoft MVP Ben Currier " data-medium-file="https://i1.wp.com/excelexposure.com/wp-content/uploads/2019/05/mvp.png?fit=300%2C121&ssl=1" data-large-file="https://i1.wp.com/excelexposure.com/wp-content/uploads/2019/05/mvp.png?fit=640%2C259&ssl=1" srcset="https://i1.wp.com/excelexposure.com/wp-content/uploads/2019/05/mvp.png?w=1125&ssl=11125w,
https://i1.wp.com/excelexposure.com/wp-content/uploads/2019/05/mvp.png?resize=300%2C121&ssl=1300w,
https://i1.wp.com/excelexposure.com/wp-content/uploads/2019/05/mvp.png?resize=768%2C311&ssl=1768w,
https://i1.wp.com/excelexposure.com/wp-content/uploads/2019/05/mvp.png?resize=1024%2C414&ssl=1 1024w" data-lazy-loaded="1" sizes="(max-width: 300px) 100vw, 300px">*
ABOUT THIS SITE
Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel. The site includes video lessons, tutorials and information to help improve your Excel skills. As of Summer 2019, there is both paid and free training available.*
ADVERTISEMENT:
*
LEARN EXCEL ONLINE:
* Home
* Excel Essentials
* Get Started
* Lesson Guide
* Master Workbook
* Press
* About
* Testimonials
* Partners
* Policies
*
Excel Exposure LLC - Littleton, CO - (404)913-9235 Excel Exposure Site Policies – Privacy& Other
Proudly powered by WordPress. Excel Exposure uses cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it. I will never use your information for any nefarious purposes, pinky swear!I Understand!Privacy & OtherPolicies
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0