If you like this video, here's my entire playlist of Excel tutorials: Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it's easier to read and use, and more. Page Setup Options Learn about page setup options, fitting print jobs on a page, headers and footers, and other ways to customize print jobs. Building Combination Line and Area Charts When you want to graph 3 line series, but only want 2 in focus most of the time. The Ribbon Identify the terminology and elements of the Ribbon. Learn how to use Excel in exactly 30 minutes starting with the very basics for the complete beginner and then move to more intermediate features such as charts, mail merges and reports.
Formula Auditing Learn to work with formula auditing tools including tracing precedent and dependent cells and formula evaluation. The full Excel 2016 Tutorial is available from here:. All of our trainers are Microsoft Certified. Subscribe to this channel so that you do not miss out on the new videos on this series. Please subscribe to our Youtube channel and check out our website to browse all of our training,.
And your sought-after can help you impress your employer and improve your career prospects. Building Line Charts How to create an effective line chart through careful manipulation of chart elements to enhance its story telling ability. Data Validation Lists Use to restrict users ability to enter invalid data in cells by providing them with a drop down list of valid options. Formula Anatomy Understanding Excel Formula Anatomy Cell Referencing Learn about working with absolute and relative cell referencing, and techniques for copying formulas. This online course is suitable for anyone who wants to learn Excel. Formatting Format cells by selecting fonts and color fills to make information more attractive.
Styles Learn how to apply built-in number styles and create your own custom styles packages. No prior knowledge of Excel is required. Formatting PivotTables Learn to control formatting and other options in PivotTables. Appending Tables Appending tables is the process of stacking them vertically to create long tables that can be used to feed business intelligence solutions and PivotTables. Choose from our Microsoft Office training classes from beginner classes to advanced topics in a wide range of applications. Building Bar Charts How to create an effective bar chart by reducing ink and noise that distract from the story. Understanding Time Understand how time works in Excel, and how to change from whole numbers into time increments and back again.
Over 51,000 people like you have learned practical, actionable Excel skills from this online course to help them work smarter every single day. You then get a personalized syllabus to show you which lessons to focus on, saving you time and accelerating your learning. Learn about other mathematical calculations in Excel. See the future of online research without ever leaving the program, using Smart Lookup. All this coupled with a detailed review of the recent user interface changes means you'll be an expert with these new versions in no time at all. Naming Ranges Learn about creating named ranges, and the benefits of doing so.
Thank you for your support! If you are using an older version than 2010, your interface will differ slightly to what is shown in the videos. Microsoft Office training from New Horizons will help you or your team effectively utilize all the features of Microsoft Office products, and set you or your team up for Microsoft certifications, if desired. Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. Basic Math Utilize basic mathematics including multiplication and division in Excel. Recording Macros Learn to record basic Excel macros to automate your actions instead of doing them manually. This helps support the channel and allows us to continue to make videos like this. Because most businesses use Excel, learning how to use the application efficiently opens up more opportunities for employment and career advancement.
Whether you are expanding your current Microsoft Office skill set, embarking on a new career, or working toward a big promotion, Learn iT! These videos provide an up-close and detailed look at what makes the latest editions of Microsoft Word, Excel, and PowerPoint the most advanced versions yet. Importing Data from a Text File Importing data from a text file into an Excel table using Power Query. If you already have some experience with Excel, you can take a placement test to find out which areas are your strengths, and which are your weaknesses. Building Column Charts Learn how to create an effective column chart by reducing ink and 'noise' that distract from the main messages. Microsoft Excel is the most commonly used spreadsheet application.
Data Validation Learn how to use Data Validation to ensure that users enter valid data in input cells. Conditional Formats with Custom Rules Learn to create custom conditional formatting rules based on formulas. Learn how to use conditional formatting and other formatting features in Excel. The course is compatible with Office 365 and Excel for Windows 2019, 2016, 2013, 2010. Contact me if you have such a need. Universally used in office settings, knowledge of Microsoft Office tools are a must for anyone in today's job market. Sorting Learn to sort data in Excel by a single column or by multiple columns.