Excel: Beginning to Expert - Complete Course (updated)

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Microsoft Excel 2019 Complete Course. New topics added as new features arrive.

This Microsoft Excel course was recorded with the latest version of Excel 365 to ensure it is up to date with all the latest features and enhancements. However it works great with 2016, 2010 and 2013 versions.

Enroll now to get over 9 hours and over 70 lessons of professional training!

Enroll now to go from a beginner in Excel to an Intermediate user ready to tackle most day to day work in Excel. Microsoft Excel is one of the most popular spreadsheet and business productivity tools in the world. I will be your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Excel saving you months and even years of frustration.

Stop struggling through your daily tasks at work or wishing you had the skills to advance. Now you can quickly and easily go from beginner to intermediate step-by-step with clear video lessons and easy to use practice files designed just for this course.

When you have finished this course you will be able to perform the most popular Excel functions and features and have the confidence to take on new challenges, responsibilities and opportunities. Here are a few of the highly sought after skills you will acquire in Excel:

  • Create attractive and effective spreadsheets

  • Sort and format large sets of data

  • Create and format tables quickly

  • Master useful functions like SUM, VLOOKUP, IF, AVERAGE, and many others

  • Create dynamic Pivot Tables and Pivot Charts

  • Automate your tasks with Macros

  • Secure workbooks and worksheets

  • Use conditional formatting to highlight data

Enroll now and take the next step in making a real difference in your career and income potential. You are only a few clicks away from your new future!

Who this course is for:

  • Anyone who wants to improve their Microsoft Excel skills

Expected Outcomes

  1. Move around efficiently in Excel Understand how to use the Excel interface and Ribbon Effectively use the Status Bar Use the many help features in Excel Enter data quickly and effeciently Create formulas and use built-in functions Calculate dates and times Quickly format text, numbers, percentages, and currency Create conditional formatting such as data bars and highlighted text based on rules Create and format tables easily Create slicers to quickly filter table data Create and format shapes, images, and SmartArt to enhance your data Quickly "best fit" columns and rows Easily shift, insert, and move any data in rows or columns Use a wide rang of tools to prpare data for looking professional when printed Create insightful charts and control every aspect of layout and detail Freeze rows and or columns for better views of worksheet data View multiple worksheets or multiple workbooks ata the same time Moving, copying, grouping, and formating worksheets and worksheet tabs Undertand how to use the powerful IF, Vlookup and other Power Functions Use security and Sharing features Sort any column and sort multiple items at the same time Automatically insert subtotal data Filter out any item or data Quickly find and replace data Split data such and City, State, Zip between columns for better sorting Remove duplicate data easily Create drop down "pick lists" Use validation tools to only accept specific data in specified cells Create pivot table with ease Create pivot charts and change them quickly Use dozens of Excel hacks, short cuts, tricks, and tips! Show more Show less Requirements You should generally understand how to use the mouse and keyboard You will need access to Excel 2010, 2013, 2016 or Excel 365 version Description Microsoft Excel 2019 Complete Course. New topics added as new features arrive. This Microsoft Excel course was recorded with the latest version of Excel 365 to ensure it is up to date with all the latest features and enhancements. However it works great with 2016, 2010 and 2013 versions. Enroll now to get over 9 hours and over 70 lessons of professional training! Enroll now to go from a beginner in Excel to an Intermediate user ready to tackle most day to day work in Excel. Microsoft Excel is one of the most popular spreadsheet and business productivity tools in the world. I will be your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Excel saving you months and even years of frustration. Stop struggling through your daily tasks at work or wishing you had the skills to advance. Now you can quickly and easily go from beginner to intermediate step-by-step with clear video lessons and easy to use practice files designed just for this course. When you have finished this course you will be able to perform the most popular Excel functions and features and have the confidence to take on new challenges, responsibilities and opportunities. Here are a few of the highly sought after skills you will acquire in Excel: Create attractive and effective spreadsheets Sort and format large sets of data Create and format tables quickly Master useful functions like SUM, VLOOKUP, IF, AVERAGE, and many others Create dynamic Pivot Tables and Pivot Charts Automate your tasks with Macros Secure workbooks and worksheets Use conditional formatting to highlight data Enroll now and take the next step in making a real difference in your career and income potential. You are only a few clicks away from your new future! Who this course is for: Anyone who wants to improve their Microsoft Excel skills Show more Show less Course content 16 sections • 72 lectures • 9h 38m total length Expand all sections Getting familiar with Excel 10 lectures • 46min Using the exercise files Preview 00:22 Introducing Excel Preview 03:14 Using the Menu System 11:00 Using the Quick Access Toolbar Preview 04:15 Understanding Workbooks and Worksheets 05:54 Using the Formula Bar 02:41 Using the Status Bar 03:54 Using Navigation Tools Preview 07:37 Using Short Cut Menus and the Mini Toolbar 03:25 Using Excel help 03:09 Introduction to Excel 2 questions Entering Data in Excel 5 lectures • 24min Exploring data entry and editing techniques 06:39 Entering data with AutoFill 06:07 Working with dates and times 06:14 Using Undo and Redo 02:35 Adding Comments 02:52 Entering data 2 questions Creating Formulas and Functions 7 lectures • 54min Creating Formulas and Functions 12:47 Copying a formula into an adjacent cell Preview 03:29 Calculating Year to date totals 02:56 Creating a percent change formula 03:43 Working with absolute and relative references 10:54 Auto Sum and Auto Average 08:18 Other popular Excel functions 12:01 Creating Formulas and Functions 2 questions Formatting Excel data 8 lectures • 1hr 40min Fonts and Styles 14:22 Adjusting Columns and Rows 05:16 Align and Merge 04:28 Designing Borders 08:15 Exploring Numeric and special formats 12:52 Using Conditional Formatting 12:50 Creating and Customizing tables 17:50 Inserting Shapes 24:00 Adjusting Columns or Rows 2 questions Layout Features 4 lectures • 29min Insert and Delete Rows and Columns 06:45 Hiding and Un-hiding Rows and Columns 04:38 Moving Copying and Inserting Data 09:58 Find and Replace 07:17 Layout Features 2 questions Preparing for Printing 3 lectures • 27min Page Layout View 15:38 Page Break Preview 04:54 Page Setup 06:42 Creating Charts 4 lectures • 35min Creating Charts 07:40 Chart Types 11:21 Format Charts and Elements 07:16 Sparklines 08:14 View Options 3 lectures • 14min Freezing and Unfreezing Panes 04:59 Splitting Screens 03:57 Outlining 05:26 View Multiple Worksheets and Workbooks 3 lectures • 37min Viewing Multiple Workbooks and Worksheets 09:21 Working With Sheets 06:37 Linking Worksheets and Workbooks with Formulas 21:08 IF Functions and VLOOKUP 4 lectures • 24min If functions and VLOOKUP 06:00 VLOOKUP Approximate 06:02 VLOOKUP Exact with Function Assistance 05:47 IF Family Functions 06:06 6 more sections Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses Tim Wright has been an Instructional Designer for 10 years and an Educator for over 20 years. Mr. Wright developed and taught a nationally recognized course taught in San Francisco and New York City. Mr. Wright has a BFA Film School degree, a Secondary Education degree, and a Masters of Science degree in Technology Education. As a consultant, Mr. Wright's clients include the Pennsylvania Veterans Affairs Dept., the Los Angeles Fire Dept, and the National Emergency Training Center in Bethesda Maryland. Mr. Wright believes that anything can be learned if taught correctly. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67813a7988c853da',m:'5238f2301170034ed3ab29b865b4877622e4be58-1627843579-1800-AeTHIRzMPEK4JQzu6AU6+JoY8smI9u4ynIuODRw1CsbVpLMEFrtNpFoJ6TaVqD/Ij7u/KAHNynnGrc1oTnPLIe5na18womzgzB0aF4o0mOWFdZMCecU5q1rEAgqFLNFyMW9WCMvOrXrxgtT0otGRzY6mhSTlaJgNxE2dD15g7nDVzyGHz9nMpxy0kbkfEVpI1w==',s:[0x6675349ce1,0xd82b162f8e],}})();
  2. Understand how to use the Excel interface and Ribbon Effectively use the Status Bar Use the many help features in Excel Enter data quickly and effeciently Create formulas and use built-in functions Calculate dates and times Quickly format text, numbers, percentages, and currency Create conditional formatting such as data bars and highlighted text based on rules Create and format tables easily Create slicers to quickly filter table data Create and format shapes, images, and SmartArt to enhance your data Quickly "best fit" columns and rows Easily shift, insert, and move any data in rows or columns Use a wide rang of tools to prpare data for looking professional when printed Create insightful charts and control every aspect of layout and detail Freeze rows and or columns for better views of worksheet data View multiple worksheets or multiple workbooks ata the same time Moving, copying, grouping, and formating worksheets and worksheet tabs Undertand how to use the powerful IF, Vlookup and other Power Functions Use security and Sharing features Sort any column and sort multiple items at the same time Automatically insert subtotal data Filter out any item or data Quickly find and replace data Split data such and City, State, Zip between columns for better sorting Remove duplicate data easily Create drop down "pick lists" Use validation tools to only accept specific data in specified cells Create pivot table with ease Create pivot charts and change them quickly Use dozens of Excel hacks, short cuts, tricks, and tips! Show more Show less Requirements You should generally understand how to use the mouse and keyboard You will need access to Excel 2010, 2013, 2016 or Excel 365 version Description Microsoft Excel 2019 Complete Course. New topics added as new features arrive. This Microsoft Excel course was recorded with the latest version of Excel 365 to ensure it is up to date with all the latest features and enhancements. However it works great with 2016, 2010 and 2013 versions. Enroll now to get over 9 hours and over 70 lessons of professional training! Enroll now to go from a beginner in Excel to an Intermediate user ready to tackle most day to day work in Excel. Microsoft Excel is one of the most popular spreadsheet and business productivity tools in the world. I will be your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Excel saving you months and even years of frustration. Stop struggling through your daily tasks at work or wishing you had the skills to advance. Now you can quickly and easily go from beginner to intermediate step-by-step with clear video lessons and easy to use practice files designed just for this course. When you have finished this course you will be able to perform the most popular Excel functions and features and have the confidence to take on new challenges, responsibilities and opportunities. Here are a few of the highly sought after skills you will acquire in Excel: Create attractive and effective spreadsheets Sort and format large sets of data Create and format tables quickly Master useful functions like SUM, VLOOKUP, IF, AVERAGE, and many others Create dynamic Pivot Tables and Pivot Charts Automate your tasks with Macros Secure workbooks and worksheets Use conditional formatting to highlight data Enroll now and take the next step in making a real difference in your career and income potential. You are only a few clicks away from your new future! Who this course is for: Anyone who wants to improve their Microsoft Excel skills Show more Show less Course content 16 sections • 72 lectures • 9h 38m total length Expand all sections Getting familiar with Excel 10 lectures • 46min Using the exercise files Preview 00:22 Introducing Excel Preview 03:14 Using the Menu System 11:00 Using the Quick Access Toolbar Preview 04:15 Understanding Workbooks and Worksheets 05:54 Using the Formula Bar 02:41 Using the Status Bar 03:54 Using Navigation Tools Preview 07:37 Using Short Cut Menus and the Mini Toolbar 03:25 Using Excel help 03:09 Introduction to Excel 2 questions Entering Data in Excel 5 lectures • 24min Exploring data entry and editing techniques 06:39 Entering data with AutoFill 06:07 Working with dates and times 06:14 Using Undo and Redo 02:35 Adding Comments 02:52 Entering data 2 questions Creating Formulas and Functions 7 lectures • 54min Creating Formulas and Functions 12:47 Copying a formula into an adjacent cell Preview 03:29 Calculating Year to date totals 02:56 Creating a percent change formula 03:43 Working with absolute and relative references 10:54 Auto Sum and Auto Average 08:18 Other popular Excel functions 12:01 Creating Formulas and Functions 2 questions Formatting Excel data 8 lectures • 1hr 40min Fonts and Styles 14:22 Adjusting Columns and Rows 05:16 Align and Merge 04:28 Designing Borders 08:15 Exploring Numeric and special formats 12:52 Using Conditional Formatting 12:50 Creating and Customizing tables 17:50 Inserting Shapes 24:00 Adjusting Columns or Rows 2 questions Layout Features 4 lectures • 29min Insert and Delete Rows and Columns 06:45 Hiding and Un-hiding Rows and Columns 04:38 Moving Copying and Inserting Data 09:58 Find and Replace 07:17 Layout Features 2 questions Preparing for Printing 3 lectures • 27min Page Layout View 15:38 Page Break Preview 04:54 Page Setup 06:42 Creating Charts 4 lectures • 35min Creating Charts 07:40 Chart Types 11:21 Format Charts and Elements 07:16 Sparklines 08:14 View Options 3 lectures • 14min Freezing and Unfreezing Panes 04:59 Splitting Screens 03:57 Outlining 05:26 View Multiple Worksheets and Workbooks 3 lectures • 37min Viewing Multiple Workbooks and Worksheets 09:21 Working With Sheets 06:37 Linking Worksheets and Workbooks with Formulas 21:08 IF Functions and VLOOKUP 4 lectures • 24min If functions and VLOOKUP 06:00 VLOOKUP Approximate 06:02 VLOOKUP Exact with Function Assistance 05:47 IF Family Functions 06:06 6 more sections Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses Tim Wright has been an Instructional Designer for 10 years and an Educator for over 20 years. Mr. Wright developed and taught a nationally recognized course taught in San Francisco and New York City. Mr. Wright has a BFA Film School degree, a Secondary Education degree, and a Masters of Science degree in Technology Education. As a consultant, Mr. Wright's clients include the Pennsylvania Veterans Affairs Dept., the Los Angeles Fire Dept, and the National Emergency Training Center in Bethesda Maryland. Mr. Wright believes that anything can be learned if taught correctly. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67813a7988c853da',m:'5238f2301170034ed3ab29b865b4877622e4be58-1627843579-1800-AeTHIRzMPEK4JQzu6AU6+JoY8smI9u4ynIuODRw1CsbVpLMEFrtNpFoJ6TaVqD/Ij7u/KAHNynnGrc1oTnPLIe5na18womzgzB0aF4o0mOWFdZMCecU5q1rEAgqFLNFyMW9WCMvOrXrxgtT0otGRzY6mhSTlaJgNxE2dD15g7nDVzyGHz9nMpxy0kbkfEVpI1w==',s:[0x6675349ce1,0xd82b162f8e],}})();
  3. Effectively use the Status Bar Use the many help features in Excel Enter data quickly and effeciently Create formulas and use built-in functions Calculate dates and times Quickly format text, numbers, percentages, and currency Create conditional formatting such as data bars and highlighted text based on rules Create and format tables easily Create slicers to quickly filter table data Create and format shapes, images, and SmartArt to enhance your data Quickly "best fit" columns and rows Easily shift, insert, and move any data in rows or columns Use a wide rang of tools to prpare data for looking professional when printed Create insightful charts and control every aspect of layout and detail Freeze rows and or columns for better views of worksheet data View multiple worksheets or multiple workbooks ata the same time Moving, copying, grouping, and formating worksheets and worksheet tabs Undertand how to use the powerful IF, Vlookup and other Power Functions Use security and Sharing features Sort any column and sort multiple items at the same time Automatically insert subtotal data Filter out any item or data Quickly find and replace data Split data such and City, State, Zip between columns for better sorting Remove duplicate data easily Create drop down "pick lists" Use validation tools to only accept specific data in specified cells Create pivot table with ease Create pivot charts and change them quickly Use dozens of Excel hacks, short cuts, tricks, and tips! Show more Show less Requirements You should generally understand how to use the mouse and keyboard You will need access to Excel 2010, 2013, 2016 or Excel 365 version Description Microsoft Excel 2019 Complete Course. New topics added as new features arrive. This Microsoft Excel course was recorded with the latest version of Excel 365 to ensure it is up to date with all the latest features and enhancements. However it works great with 2016, 2010 and 2013 versions. Enroll now to get over 9 hours and over 70 lessons of professional training! Enroll now to go from a beginner in Excel to an Intermediate user ready to tackle most day to day work in Excel. Microsoft Excel is one of the most popular spreadsheet and business productivity tools in the world. I will be your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Excel saving you months and even years of frustration. Stop struggling through your daily tasks at work or wishing you had the skills to advance. Now you can quickly and easily go from beginner to intermediate step-by-step with clear video lessons and easy to use practice files designed just for this course. When you have finished this course you will be able to perform the most popular Excel functions and features and have the confidence to take on new challenges, responsibilities and opportunities. Here are a few of the highly sought after skills you will acquire in Excel: Create attractive and effective spreadsheets Sort and format large sets of data Create and format tables quickly Master useful functions like SUM, VLOOKUP, IF, AVERAGE, and many others Create dynamic Pivot Tables and Pivot Charts Automate your tasks with Macros Secure workbooks and worksheets Use conditional formatting to highlight data Enroll now and take the next step in making a real difference in your career and income potential. You are only a few clicks away from your new future! Who this course is for: Anyone who wants to improve their Microsoft Excel skills Show more Show less Course content 16 sections • 72 lectures • 9h 38m total length Expand all sections Getting familiar with Excel 10 lectures • 46min Using the exercise files Preview 00:22 Introducing Excel Preview 03:14 Using the Menu System 11:00 Using the Quick Access Toolbar Preview 04:15 Understanding Workbooks and Worksheets 05:54 Using the Formula Bar 02:41 Using the Status Bar 03:54 Using Navigation Tools Preview 07:37 Using Short Cut Menus and the Mini Toolbar 03:25 Using Excel help 03:09 Introduction to Excel 2 questions Entering Data in Excel 5 lectures • 24min Exploring data entry and editing techniques 06:39 Entering data with AutoFill 06:07 Working with dates and times 06:14 Using Undo and Redo 02:35 Adding Comments 02:52 Entering data 2 questions Creating Formulas and Functions 7 lectures • 54min Creating Formulas and Functions 12:47 Copying a formula into an adjacent cell Preview 03:29 Calculating Year to date totals 02:56 Creating a percent change formula 03:43 Working with absolute and relative references 10:54 Auto Sum and Auto Average 08:18 Other popular Excel functions 12:01 Creating Formulas and Functions 2 questions Formatting Excel data 8 lectures • 1hr 40min Fonts and Styles 14:22 Adjusting Columns and Rows 05:16 Align and Merge 04:28 Designing Borders 08:15 Exploring Numeric and special formats 12:52 Using Conditional Formatting 12:50 Creating and Customizing tables 17:50 Inserting Shapes 24:00 Adjusting Columns or Rows 2 questions Layout Features 4 lectures • 29min Insert and Delete Rows and Columns 06:45 Hiding and Un-hiding Rows and Columns 04:38 Moving Copying and Inserting Data 09:58 Find and Replace 07:17 Layout Features 2 questions Preparing for Printing 3 lectures • 27min Page Layout View 15:38 Page Break Preview 04:54 Page Setup 06:42 Creating Charts 4 lectures • 35min Creating Charts 07:40 Chart Types 11:21 Format Charts and Elements 07:16 Sparklines 08:14 View Options 3 lectures • 14min Freezing and Unfreezing Panes 04:59 Splitting Screens 03:57 Outlining 05:26 View Multiple Worksheets and Workbooks 3 lectures • 37min Viewing Multiple Workbooks and Worksheets 09:21 Working With Sheets 06:37 Linking Worksheets and Workbooks with Formulas 21:08 IF Functions and VLOOKUP 4 lectures • 24min If functions and VLOOKUP 06:00 VLOOKUP Approximate 06:02 VLOOKUP Exact with Function Assistance 05:47 IF Family Functions 06:06 6 more sections Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses Tim Wright has been an Instructional Designer for 10 years and an Educator for over 20 years. Mr. Wright developed and taught a nationally recognized course taught in San Francisco and New York City. Mr. Wright has a BFA Film School degree, a Secondary Education degree, and a Masters of Science degree in Technology Education. As a consultant, Mr. Wright's clients include the Pennsylvania Veterans Affairs Dept., the Los Angeles Fire Dept, and the National Emergency Training Center in Bethesda Maryland. Mr. Wright believes that anything can be learned if taught correctly. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67813a7988c853da',m:'5238f2301170034ed3ab29b865b4877622e4be58-1627843579-1800-AeTHIRzMPEK4JQzu6AU6+JoY8smI9u4ynIuODRw1CsbVpLMEFrtNpFoJ6TaVqD/Ij7u/KAHNynnGrc1oTnPLIe5na18womzgzB0aF4o0mOWFdZMCecU5q1rEAgqFLNFyMW9WCMvOrXrxgtT0otGRzY6mhSTlaJgNxE2dD15g7nDVzyGHz9nMpxy0kbkfEVpI1w==',s:[0x6675349ce1,0xd82b162f8e],}})();
  4. Use the many help features in Excel Enter data quickly and effeciently Create formulas and use built-in functions Calculate dates and times Quickly format text, numbers, percentages, and currency Create conditional formatting such as data bars and highlighted text based on rules Create and format tables easily Create slicers to quickly filter table data Create and format shapes, images, and SmartArt to enhance your data Quickly "best fit" columns and rows Easily shift, insert, and move any data in rows or columns Use a wide rang of tools to prpare data for looking professional when printed Create insightful charts and control every aspect of layout and detail Freeze rows and or columns for better views of worksheet data View multiple worksheets or multiple workbooks ata the same time Moving, copying, grouping, and formating worksheets and worksheet tabs Undertand how to use the powerful IF, Vlookup and other Power Functions Use security and Sharing features Sort any column and sort multiple items at the same time Automatically insert subtotal data Filter out any item or data Quickly find and replace data Split data such and City, State, Zip between columns for better sorting Remove duplicate data easily Create drop down "pick lists" Use validation tools to only accept specific data in specified cells Create pivot table with ease Create pivot charts and change them quickly Use dozens of Excel hacks, short cuts, tricks, and tips! Show more Show less Requirements You should generally understand how to use the mouse and keyboard You will need access to Excel 2010, 2013, 2016 or Excel 365 version Description Microsoft Excel 2019 Complete Course. New topics added as new features arrive. This Microsoft Excel course was recorded with the latest version of Excel 365 to ensure it is up to date with all the latest features and enhancements. However it works great with 2016, 2010 and 2013 versions. Enroll now to get over 9 hours and over 70 lessons of professional training! Enroll now to go from a beginner in Excel to an Intermediate user ready to tackle most day to day work in Excel. Microsoft Excel is one of the most popular spreadsheet and business productivity tools in the world. I will be your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Excel saving you months and even years of frustration. Stop struggling through your daily tasks at work or wishing you had the skills to advance. Now you can quickly and easily go from beginner to intermediate step-by-step with clear video lessons and easy to use practice files designed just for this course. When you have finished this course you will be able to perform the most popular Excel functions and features and have the confidence to take on new challenges, responsibilities and opportunities. Here are a few of the highly sought after skills you will acquire in Excel: Create attractive and effective spreadsheets Sort and format large sets of data Create and format tables quickly Master useful functions like SUM, VLOOKUP, IF, AVERAGE, and many others Create dynamic Pivot Tables and Pivot Charts Automate your tasks with Macros Secure workbooks and worksheets Use conditional formatting to highlight data Enroll now and take the next step in making a real difference in your career and income potential. You are only a few clicks away from your new future! Who this course is for: Anyone who wants to improve their Microsoft Excel skills Show more Show less Course content 16 sections • 72 lectures • 9h 38m total length Expand all sections Getting familiar with Excel 10 lectures • 46min Using the exercise files Preview 00:22 Introducing Excel Preview 03:14 Using the Menu System 11:00 Using the Quick Access Toolbar Preview 04:15 Understanding Workbooks and Worksheets 05:54 Using the Formula Bar 02:41 Using the Status Bar 03:54 Using Navigation Tools Preview 07:37 Using Short Cut Menus and the Mini Toolbar 03:25 Using Excel help 03:09 Introduction to Excel 2 questions Entering Data in Excel 5 lectures • 24min Exploring data entry and editing techniques 06:39 Entering data with AutoFill 06:07 Working with dates and times 06:14 Using Undo and Redo 02:35 Adding Comments 02:52 Entering data 2 questions Creating Formulas and Functions 7 lectures • 54min Creating Formulas and Functions 12:47 Copying a formula into an adjacent cell Preview 03:29 Calculating Year to date totals 02:56 Creating a percent change formula 03:43 Working with absolute and relative references 10:54 Auto Sum and Auto Average 08:18 Other popular Excel functions 12:01 Creating Formulas and Functions 2 questions Formatting Excel data 8 lectures • 1hr 40min Fonts and Styles 14:22 Adjusting Columns and Rows 05:16 Align and Merge 04:28 Designing Borders 08:15 Exploring Numeric and special formats 12:52 Using Conditional Formatting 12:50 Creating and Customizing tables 17:50 Inserting Shapes 24:00 Adjusting Columns or Rows 2 questions Layout Features 4 lectures • 29min Insert and Delete Rows and Columns 06:45 Hiding and Un-hiding Rows and Columns 04:38 Moving Copying and Inserting Data 09:58 Find and Replace 07:17 Layout Features 2 questions Preparing for Printing 3 lectures • 27min Page Layout View 15:38 Page Break Preview 04:54 Page Setup 06:42 Creating Charts 4 lectures • 35min Creating Charts 07:40 Chart Types 11:21 Format Charts and Elements 07:16 Sparklines 08:14 View Options 3 lectures • 14min Freezing and Unfreezing Panes 04:59 Splitting Screens 03:57 Outlining 05:26 View Multiple Worksheets and Workbooks 3 lectures • 37min Viewing Multiple Workbooks and Worksheets 09:21 Working With Sheets 06:37 Linking Worksheets and Workbooks with Formulas 21:08 IF Functions and VLOOKUP 4 lectures • 24min If functions and VLOOKUP 06:00 VLOOKUP Approximate 06:02 VLOOKUP Exact with Function Assistance 05:47 IF Family Functions 06:06 6 more sections Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses Tim Wright has been an Instructional Designer for 10 years and an Educator for over 20 years. Mr. Wright developed and taught a nationally recognized course taught in San Francisco and New York City. Mr. Wright has a BFA Film School degree, a Secondary Education degree, and a Masters of Science degree in Technology Education. As a consultant, Mr. Wright's clients include the Pennsylvania Veterans Affairs Dept., the Los Angeles Fire Dept, and the National Emergency Training Center in Bethesda Maryland. Mr. Wright believes that anything can be learned if taught correctly. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67813a7988c853da',m:'5238f2301170034ed3ab29b865b4877622e4be58-1627843579-1800-AeTHIRzMPEK4JQzu6AU6+JoY8smI9u4ynIuODRw1CsbVpLMEFrtNpFoJ6TaVqD/Ij7u/KAHNynnGrc1oTnPLIe5na18womzgzB0aF4o0mOWFdZMCecU5q1rEAgqFLNFyMW9WCMvOrXrxgtT0otGRzY6mhSTlaJgNxE2dD15g7nDVzyGHz9nMpxy0kbkfEVpI1w==',s:[0x6675349ce1,0xd82b162f8e],}})();
  5. Enter data quickly and effeciently Create formulas and use built-in functions Calculate dates and times Quickly format text, numbers, percentages, and currency Create conditional formatting such as data bars and highlighted text based on rules Create and format tables easily Create slicers to quickly filter table data Create and format shapes, images, and SmartArt to enhance your data Quickly "best fit" columns and rows Easily shift, insert, and move any data in rows or columns Use a wide rang of tools to prpare data for looking professional when printed Create insightful charts and control every aspect of layout and detail Freeze rows and or columns for better views of worksheet data View multiple worksheets or multiple workbooks ata the same time Moving, copying, grouping, and formating worksheets and worksheet tabs Undertand how to use the powerful IF, Vlookup and other Power Functions Use security and Sharing features Sort any column and sort multiple items at the same time Automatically insert subtotal data Filter out any item or data Quickly find and replace data Split data such and City, State, Zip between columns for better sorting Remove duplicate data easily Create drop down "pick lists" Use validation tools to only accept specific data in specified cells Create pivot table with ease Create pivot charts and change them quickly Use dozens of Excel hacks, short cuts, tricks, and tips! Show more Show less Requirements You should generally understand how to use the mouse and keyboard You will need access to Excel 2010, 2013, 2016 or Excel 365 version Description Microsoft Excel 2019 Complete Course. New topics added as new features arrive. This Microsoft Excel course was recorded with the latest version of Excel 365 to ensure it is up to date with all the latest features and enhancements. However it works great with 2016, 2010 and 2013 versions. Enroll now to get over 9 hours and over 70 lessons of professional training! Enroll now to go from a beginner in Excel to an Intermediate user ready to tackle most day to day work in Excel. Microsoft Excel is one of the most popular spreadsheet and business productivity tools in the world. I will be your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Excel saving you months and even years of frustration. Stop struggling through your daily tasks at work or wishing you had the skills to advance. Now you can quickly and easily go from beginner to intermediate step-by-step with clear video lessons and easy to use practice files designed just for this course. When you have finished this course you will be able to perform the most popular Excel functions and features and have the confidence to take on new challenges, responsibilities and opportunities. Here are a few of the highly sought after skills you will acquire in Excel: Create attractive and effective spreadsheets Sort and format large sets of data Create and format tables quickly Master useful functions like SUM, VLOOKUP, IF, AVERAGE, and many others Create dynamic Pivot Tables and Pivot Charts Automate your tasks with Macros Secure workbooks and worksheets Use conditional formatting to highlight data Enroll now and take the next step in making a real difference in your career and income potential. You are only a few clicks away from your new future! Who this course is for: Anyone who wants to improve their Microsoft Excel skills Show more Show less Course content 16 sections • 72 lectures • 9h 38m total length Expand all sections Getting familiar with Excel 10 lectures • 46min Using the exercise files Preview 00:22 Introducing Excel Preview 03:14 Using the Menu System 11:00 Using the Quick Access Toolbar Preview 04:15 Understanding Workbooks and Worksheets 05:54 Using the Formula Bar 02:41 Using the Status Bar 03:54 Using Navigation Tools Preview 07:37 Using Short Cut Menus and the Mini Toolbar 03:25 Using Excel help 03:09 Introduction to Excel 2 questions Entering Data in Excel 5 lectures • 24min Exploring data entry and editing techniques 06:39 Entering data with AutoFill 06:07 Working with dates and times 06:14 Using Undo and Redo 02:35 Adding Comments 02:52 Entering data 2 questions Creating Formulas and Functions 7 lectures • 54min Creating Formulas and Functions 12:47 Copying a formula into an adjacent cell Preview 03:29 Calculating Year to date totals 02:56 Creating a percent change formula 03:43 Working with absolute and relative references 10:54 Auto Sum and Auto Average 08:18 Other popular Excel functions 12:01 Creating Formulas and Functions 2 questions Formatting Excel data 8 lectures • 1hr 40min Fonts and Styles 14:22 Adjusting Columns and Rows 05:16 Align and Merge 04:28 Designing Borders 08:15 Exploring Numeric and special formats 12:52 Using Conditional Formatting 12:50 Creating and Customizing tables 17:50 Inserting Shapes 24:00 Adjusting Columns or Rows 2 questions Layout Features 4 lectures • 29min Insert and Delete Rows and Columns 06:45 Hiding and Un-hiding Rows and Columns 04:38 Moving Copying and Inserting Data 09:58 Find and Replace 07:17 Layout Features 2 questions Preparing for Printing 3 lectures • 27min Page Layout View 15:38 Page Break Preview 04:54 Page Setup 06:42 Creating Charts 4 lectures • 35min Creating Charts 07:40 Chart Types 11:21 Format Charts and Elements 07:16 Sparklines 08:14 View Options 3 lectures • 14min Freezing and Unfreezing Panes 04:59 Splitting Screens 03:57 Outlining 05:26 View Multiple Worksheets and Workbooks 3 lectures • 37min Viewing Multiple Workbooks and Worksheets 09:21 Working With Sheets 06:37 Linking Worksheets and Workbooks with Formulas 21:08 IF Functions and VLOOKUP 4 lectures • 24min If functions and VLOOKUP 06:00 VLOOKUP Approximate 06:02 VLOOKUP Exact with Function Assistance 05:47 IF Family Functions 06:06 6 more sections Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses Tim Wright has been an Instructional Designer for 10 years and an Educator for over 20 years. Mr. Wright developed and taught a nationally recognized course taught in San Francisco and New York City. Mr. Wright has a BFA Film School degree, a Secondary Education degree, and a Masters of Science degree in Technology Education. As a consultant, Mr. Wright's clients include the Pennsylvania Veterans Affairs Dept., the Los Angeles Fire Dept, and the National Emergency Training Center in Bethesda Maryland. Mr. Wright believes that anything can be learned if taught correctly. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67813a7988c853da',m:'5238f2301170034ed3ab29b865b4877622e4be58-1627843579-1800-AeTHIRzMPEK4JQzu6AU6+JoY8smI9u4ynIuODRw1CsbVpLMEFrtNpFoJ6TaVqD/Ij7u/KAHNynnGrc1oTnPLIe5na18womzgzB0aF4o0mOWFdZMCecU5q1rEAgqFLNFyMW9WCMvOrXrxgtT0otGRzY6mhSTlaJgNxE2dD15g7nDVzyGHz9nMpxy0kbkfEVpI1w==',s:[0x6675349ce1,0xd82b162f8e],}})();
  6. Create formulas and use built-in functions Calculate dates and times Quickly format text, numbers, percentages, and currency Create conditional formatting such as data bars and highlighted text based on rules Create and format tables easily Create slicers to quickly filter table data Create and format shapes, images, and SmartArt to enhance your data Quickly "best fit" columns and rows Easily shift, insert, and move any data in rows or columns Use a wide rang of tools to prpare data for looking professional when printed Create insightful charts and control every aspect of layout and detail Freeze rows and or columns for better views of worksheet data View multiple worksheets or multiple workbooks ata the same time Moving, copying, grouping, and formating worksheets and worksheet tabs Undertand how to use the powerful IF, Vlookup and other Power Functions Use security and Sharing features Sort any column and sort multiple items at the same time Automatically insert subtotal data Filter out any item or data Quickly find and replace data Split data such and City, State, Zip between columns for better sorting Remove duplicate data easily Create drop down "pick lists" Use validation tools to only accept specific data in specified cells Create pivot table with ease Create pivot charts and change them quickly Use dozens of Excel hacks, short cuts, tricks, and tips! Show more Show less Requirements You should generally understand how to use the mouse and keyboard You will need access to Excel 2010, 2013, 2016 or Excel 365 version Description Microsoft Excel 2019 Complete Course. New topics added as new features arrive. This Microsoft Excel course was recorded with the latest version of Excel 365 to ensure it is up to date with all the latest features and enhancements. However it works great with 2016, 2010 and 2013 versions. Enroll now to get over 9 hours and over 70 lessons of professional training! Enroll now to go from a beginner in Excel to an Intermediate user ready to tackle most day to day work in Excel. Microsoft Excel is one of the most popular spreadsheet and business productivity tools in the world. I will be your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Excel saving you months and even years of frustration. Stop struggling through your daily tasks at work or wishing you had the skills to advance. Now you can quickly and easily go from beginner to intermediate step-by-step with clear video lessons and easy to use practice files designed just for this course. When you have finished this course you will be able to perform the most popular Excel functions and features and have the confidence to take on new challenges, responsibilities and opportunities. Here are a few of the highly sought after skills you will acquire in Excel: Create attractive and effective spreadsheets Sort and format large sets of data Create and format tables quickly Master useful functions like SUM, VLOOKUP, IF, AVERAGE, and many others Create dynamic Pivot Tables and Pivot Charts Automate your tasks with Macros Secure workbooks and worksheets Use conditional formatting to highlight data Enroll now and take the next step in making a real difference in your career and income potential. You are only a few clicks away from your new future! Who this course is for: Anyone who wants to improve their Microsoft Excel skills Show more Show less Course content 16 sections • 72 lectures • 9h 38m total length Expand all sections Getting familiar with Excel 10 lectures • 46min Using the exercise files Preview 00:22 Introducing Excel Preview 03:14 Using the Menu System 11:00 Using the Quick Access Toolbar Preview 04:15 Understanding Workbooks and Worksheets 05:54 Using the Formula Bar 02:41 Using the Status Bar 03:54 Using Navigation Tools Preview 07:37 Using Short Cut Menus and the Mini Toolbar 03:25 Using Excel help 03:09 Introduction to Excel 2 questions Entering Data in Excel 5 lectures • 24min Exploring data entry and editing techniques 06:39 Entering data with AutoFill 06:07 Working with dates and times 06:14 Using Undo and Redo 02:35 Adding Comments 02:52 Entering data 2 questions Creating Formulas and Functions 7 lectures • 54min Creating Formulas and Functions 12:47 Copying a formula into an adjacent cell Preview 03:29 Calculating Year to date totals 02:56 Creating a percent change formula 03:43 Working with absolute and relative references 10:54 Auto Sum and Auto Average 08:18 Other popular Excel functions 12:01 Creating Formulas and Functions 2 questions Formatting Excel data 8 lectures • 1hr 40min Fonts and Styles 14:22 Adjusting Columns and Rows 05:16 Align and Merge 04:28 Designing Borders 08:15 Exploring Numeric and special formats 12:52 Using Conditional Formatting 12:50 Creating and Customizing tables 17:50 Inserting Shapes 24:00 Adjusting Columns or Rows 2 questions Layout Features 4 lectures • 29min Insert and Delete Rows and Columns 06:45 Hiding and Un-hiding Rows and Columns 04:38 Moving Copying and Inserting Data 09:58 Find and Replace 07:17 Layout Features 2 questions Preparing for Printing 3 lectures • 27min Page Layout View 15:38 Page Break Preview 04:54 Page Setup 06:42 Creating Charts 4 lectures • 35min Creating Charts 07:40 Chart Types 11:21 Format Charts and Elements 07:16 Sparklines 08:14 View Options 3 lectures • 14min Freezing and Unfreezing Panes 04:59 Splitting Screens 03:57 Outlining 05:26 View Multiple Worksheets and Workbooks 3 lectures • 37min Viewing Multiple Workbooks and Worksheets 09:21 Working With Sheets 06:37 Linking Worksheets and Workbooks with Formulas 21:08 IF Functions and VLOOKUP 4 lectures • 24min If functions and VLOOKUP 06:00 VLOOKUP Approximate 06:02 VLOOKUP Exact with Function Assistance 05:47 IF Family Functions 06:06 6 more sections Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses Tim Wright has been an Instructional Designer for 10 years and an Educator for over 20 years. Mr. Wright developed and taught a nationally recognized course taught in San Francisco and New York City. Mr. Wright has a BFA Film School degree, a Secondary Education degree, and a Masters of Science degree in Technology Education. As a consultant, Mr. Wright's clients include the Pennsylvania Veterans Affairs Dept., the Los Angeles Fire Dept, and the National Emergency Training Center in Bethesda Maryland. Mr. Wright believes that anything can be learned if taught correctly. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67813a7988c853da',m:'5238f2301170034ed3ab29b865b4877622e4be58-1627843579-1800-AeTHIRzMPEK4JQzu6AU6+JoY8smI9u4ynIuODRw1CsbVpLMEFrtNpFoJ6TaVqD/Ij7u/KAHNynnGrc1oTnPLIe5na18womzgzB0aF4o0mOWFdZMCecU5q1rEAgqFLNFyMW9WCMvOrXrxgtT0otGRzY6mhSTlaJgNxE2dD15g7nDVzyGHz9nMpxy0kbkfEVpI1w==',s:[0x6675349ce1,0xd82b162f8e],}})();
  7. Calculate dates and times Quickly format text, numbers, percentages, and currency Create conditional formatting such as data bars and highlighted text based on rules Create and format tables easily Create slicers to quickly filter table data Create and format shapes, images, and SmartArt to enhance your data Quickly "best fit" columns and rows Easily shift, insert, and move any data in rows or columns Use a wide rang of tools to prpare data for looking professional when printed Create insightful charts and control every aspect of layout and detail Freeze rows and or columns for better views of worksheet data View multiple worksheets or multiple workbooks ata the same time Moving, copying, grouping, and formating worksheets and worksheet tabs Undertand how to use the powerful IF, Vlookup and other Power Functions Use security and Sharing features Sort any column and sort multiple items at the same time Automatically insert subtotal data Filter out any item or data Quickly find and replace data Split data such and City, State, Zip between columns for better sorting Remove duplicate data easily Create drop down "pick lists" Use validation tools to only accept specific data in specified cells Create pivot table with ease Create pivot charts and change them quickly Use dozens of Excel hacks, short cuts, tricks, and tips! Show more Show less Requirements You should generally understand how to use the mouse and keyboard You will need access to Excel 2010, 2013, 2016 or Excel 365 version Description Microsoft Excel 2019 Complete Course. New topics added as new features arrive. This Microsoft Excel course was recorded with the latest version of Excel 365 to ensure it is up to date with all the latest features and enhancements. However it works great with 2016, 2010 and 2013 versions. Enroll now to get over 9 hours and over 70 lessons of professional training! Enroll now to go from a beginner in Excel to an Intermediate user ready to tackle most day to day work in Excel. Microsoft Excel is one of the most popular spreadsheet and business productivity tools in the world. I will be your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Excel saving you months and even years of frustration. Stop struggling through your daily tasks at work or wishing you had the skills to advance. Now you can quickly and easily go from beginner to intermediate step-by-step with clear video lessons and easy to use practice files designed just for this course. When you have finished this course you will be able to perform the most popular Excel functions and features and have the confidence to take on new challenges, responsibilities and opportunities. Here are a few of the highly sought after skills you will acquire in Excel: Create attractive and effective spreadsheets Sort and format large sets of data Create and format tables quickly Master useful functions like SUM, VLOOKUP, IF, AVERAGE, and many others Create dynamic Pivot Tables and Pivot Charts Automate your tasks with Macros Secure workbooks and worksheets Use conditional formatting to highlight data Enroll now and take the next step in making a real difference in your career and income potential. You are only a few clicks away from your new future! Who this course is for: Anyone who wants to improve their Microsoft Excel skills Show more Show less Course content 16 sections • 72 lectures • 9h 38m total length Expand all sections Getting familiar with Excel 10 lectures • 46min Using the exercise files Preview 00:22 Introducing Excel Preview 03:14 Using the Menu System 11:00 Using the Quick Access Toolbar Preview 04:15 Understanding Workbooks and Worksheets 05:54 Using the Formula Bar 02:41 Using the Status Bar 03:54 Using Navigation Tools Preview 07:37 Using Short Cut Menus and the Mini Toolbar 03:25 Using Excel help 03:09 Introduction to Excel 2 questions Entering Data in Excel 5 lectures • 24min Exploring data entry and editing techniques 06:39 Entering data with AutoFill 06:07 Working with dates and times 06:14 Using Undo and Redo 02:35 Adding Comments 02:52 Entering data 2 questions Creating Formulas and Functions 7 lectures • 54min Creating Formulas and Functions 12:47 Copying a formula into an adjacent cell Preview 03:29 Calculating Year to date totals 02:56 Creating a percent change formula 03:43 Working with absolute and relative references 10:54 Auto Sum and Auto Average 08:18 Other popular Excel functions 12:01 Creating Formulas and Functions 2 questions Formatting Excel data 8 lectures • 1hr 40min Fonts and Styles 14:22 Adjusting Columns and Rows 05:16 Align and Merge 04:28 Designing Borders 08:15 Exploring Numeric and special formats 12:52 Using Conditional Formatting 12:50 Creating and Customizing tables 17:50 Inserting Shapes 24:00 Adjusting Columns or Rows 2 questions Layout Features 4 lectures • 29min Insert and Delete Rows and Columns 06:45 Hiding and Un-hiding Rows and Columns 04:38 Moving Copying and Inserting Data 09:58 Find and Replace 07:17 Layout Features 2 questions Preparing for Printing 3 lectures • 27min Page Layout View 15:38 Page Break Preview 04:54 Page Setup 06:42 Creating Charts 4 lectures • 35min Creating Charts 07:40 Chart Types 11:21 Format Charts and Elements 07:16 Sparklines 08:14 View Options 3 lectures • 14min Freezing and Unfreezing Panes 04:59 Splitting Screens 03:57 Outlining 05:26 View Multiple Worksheets and Workbooks 3 lectures • 37min Viewing Multiple Workbooks and Worksheets 09:21 Working With Sheets 06:37 Linking Worksheets and Workbooks with Formulas 21:08 IF Functions and VLOOKUP 4 lectures • 24min If functions and VLOOKUP 06:00 VLOOKUP Approximate 06:02 VLOOKUP Exact with Function Assistance 05:47 IF Family Functions 06:06 6 more sections Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses Tim Wright has been an Instructional Designer for 10 years and an Educator for over 20 years. Mr. Wright developed and taught a nationally recognized course taught in San Francisco and New York City. Mr. Wright has a BFA Film School degree, a Secondary Education degree, and a Masters of Science degree in Technology Education. As a consultant, Mr. Wright's clients include the Pennsylvania Veterans Affairs Dept., the Los Angeles Fire Dept, and the National Emergency Training Center in Bethesda Maryland. Mr. Wright believes that anything can be learned if taught correctly. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67813a7988c853da',m:'5238f2301170034ed3ab29b865b4877622e4be58-1627843579-1800-AeTHIRzMPEK4JQzu6AU6+JoY8smI9u4ynIuODRw1CsbVpLMEFrtNpFoJ6TaVqD/Ij7u/KAHNynnGrc1oTnPLIe5na18womzgzB0aF4o0mOWFdZMCecU5q1rEAgqFLNFyMW9WCMvOrXrxgtT0otGRzY6mhSTlaJgNxE2dD15g7nDVzyGHz9nMpxy0kbkfEVpI1w==',s:[0x6675349ce1,0xd82b162f8e],}})();
  8. Quickly format text, numbers, percentages, and currency Create conditional formatting such as data bars and highlighted text based on rules Create and format tables easily Create slicers to quickly filter table data Create and format shapes, images, and SmartArt to enhance your data Quickly "best fit" columns and rows Easily shift, insert, and move any data in rows or columns Use a wide rang of tools to prpare data for looking professional when printed Create insightful charts and control every aspect of layout and detail Freeze rows and or columns for better views of worksheet data View multiple worksheets or multiple workbooks ata the same time Moving, copying, grouping, and formating worksheets and worksheet tabs Undertand how to use the powerful IF, Vlookup and other Power Functions Use security and Sharing features Sort any column and sort multiple items at the same time Automatically insert subtotal data Filter out any item or data Quickly find and replace data Split data such and City, State, Zip between columns for better sorting Remove duplicate data easily Create drop down "pick lists" Use validation tools to only accept specific data in specified cells Create pivot table with ease Create pivot charts and change them quickly Use dozens of Excel hacks, short cuts, tricks, and tips! Show more Show less Requirements You should generally understand how to use the mouse and keyboard You will need access to Excel 2010, 2013, 2016 or Excel 365 version Description Microsoft Excel 2019 Complete Course. New topics added as new features arrive. This Microsoft Excel course was recorded with the latest version of Excel 365 to ensure it is up to date with all the latest features and enhancements. However it works great with 2016, 2010 and 2013 versions. Enroll now to get over 9 hours and over 70 lessons of professional training! Enroll now to go from a beginner in Excel to an Intermediate user ready to tackle most day to day work in Excel. Microsoft Excel is one of the most popular spreadsheet and business productivity tools in the world. I will be your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Excel saving you months and even years of frustration. Stop struggling through your daily tasks at work or wishing you had the skills to advance. Now you can quickly and easily go from beginner to intermediate step-by-step with clear video lessons and easy to use practice files designed just for this course. When you have finished this course you will be able to perform the most popular Excel functions and features and have the confidence to take on new challenges, responsibilities and opportunities. Here are a few of the highly sought after skills you will acquire in Excel: Create attractive and effective spreadsheets Sort and format large sets of data Create and format tables quickly Master useful functions like SUM, VLOOKUP, IF, AVERAGE, and many others Create dynamic Pivot Tables and Pivot Charts Automate your tasks with Macros Secure workbooks and worksheets Use conditional formatting to highlight data Enroll now and take the next step in making a real difference in your career and income potential. You are only a few clicks away from your new future! Who this course is for: Anyone who wants to improve their Microsoft Excel skills Show more Show less Course content 16 sections • 72 lectures • 9h 38m total length Expand all sections Getting familiar with Excel 10 lectures • 46min Using the exercise files Preview 00:22 Introducing Excel Preview 03:14 Using the Menu System 11:00 Using the Quick Access Toolbar Preview 04:15 Understanding Workbooks and Worksheets 05:54 Using the Formula Bar 02:41 Using the Status Bar 03:54 Using Navigation Tools Preview 07:37 Using Short Cut Menus and the Mini Toolbar 03:25 Using Excel help 03:09 Introduction to Excel 2 questions Entering Data in Excel 5 lectures • 24min Exploring data entry and editing techniques 06:39 Entering data with AutoFill 06:07 Working with dates and times 06:14 Using Undo and Redo 02:35 Adding Comments 02:52 Entering data 2 questions Creating Formulas and Functions 7 lectures • 54min Creating Formulas and Functions 12:47 Copying a formula into an adjacent cell Preview 03:29 Calculating Year to date totals 02:56 Creating a percent change formula 03:43 Working with absolute and relative references 10:54 Auto Sum and Auto Average 08:18 Other popular Excel functions 12:01 Creating Formulas and Functions 2 questions Formatting Excel data 8 lectures • 1hr 40min Fonts and Styles 14:22 Adjusting Columns and Rows 05:16 Align and Merge 04:28 Designing Borders 08:15 Exploring Numeric and special formats 12:52 Using Conditional Formatting 12:50 Creating and Customizing tables 17:50 Inserting Shapes 24:00 Adjusting Columns or Rows 2 questions Layout Features 4 lectures • 29min Insert and Delete Rows and Columns 06:45 Hiding and Un-hiding Rows and Columns 04:38 Moving Copying and Inserting Data 09:58 Find and Replace 07:17 Layout Features 2 questions Preparing for Printing 3 lectures • 27min Page Layout View 15:38 Page Break Preview 04:54 Page Setup 06:42 Creating Charts 4 lectures • 35min Creating Charts 07:40 Chart Types 11:21 Format Charts and Elements 07:16 Sparklines 08:14 View Options 3 lectures • 14min Freezing and Unfreezing Panes 04:59 Splitting Screens 03:57 Outlining 05:26 View Multiple Worksheets and Workbooks 3 lectures • 37min Viewing Multiple Workbooks and Worksheets 09:21 Working With Sheets 06:37 Linking Worksheets and Workbooks with Formulas 21:08 IF Functions and VLOOKUP 4 lectures • 24min If functions and VLOOKUP 06:00 VLOOKUP Approximate 06:02 VLOOKUP Exact with Function Assistance 05:47 IF Family Functions 06:06 6 more sections Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses Tim Wright has been an Instructional Designer for 10 years and an Educator for over 20 years. Mr. Wright developed and taught a nationally recognized course taught in San Francisco and New York City. Mr. Wright has a BFA Film School degree, a Secondary Education degree, and a Masters of Science degree in Technology Education. As a consultant, Mr. Wright's clients include the Pennsylvania Veterans Affairs Dept., the Los Angeles Fire Dept, and the National Emergency Training Center in Bethesda Maryland. Mr. Wright believes that anything can be learned if taught correctly. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67813a7988c853da',m:'5238f2301170034ed3ab29b865b4877622e4be58-1627843579-1800-AeTHIRzMPEK4JQzu6AU6+JoY8smI9u4ynIuODRw1CsbVpLMEFrtNpFoJ6TaVqD/Ij7u/KAHNynnGrc1oTnPLIe5na18womzgzB0aF4o0mOWFdZMCecU5q1rEAgqFLNFyMW9WCMvOrXrxgtT0otGRzY6mhSTlaJgNxE2dD15g7nDVzyGHz9nMpxy0kbkfEVpI1w==',s:[0x6675349ce1,0xd82b162f8e],}})();
  9. Create conditional formatting such as data bars and highlighted text based on rules Create and format tables easily Create slicers to quickly filter table data Create and format shapes, images, and SmartArt to enhance your data Quickly "best fit" columns and rows Easily shift, insert, and move any data in rows or columns Use a wide rang of tools to prpare data for looking professional when printed Create insightful charts and control every aspect of layout and detail Freeze rows and or columns for better views of worksheet data View multiple worksheets or multiple workbooks ata the same time Moving, copying, grouping, and formating worksheets and worksheet tabs Undertand how to use the powerful IF, Vlookup and other Power Functions Use security and Sharing features Sort any column and sort multiple items at the same time Automatically insert subtotal data Filter out any item or data Quickly find and replace data Split data