No products in the cart.

Microsoft Excel Course with 2019 New Features

Highlights
Curriculum
Testimonial

Microsoft Excel Course with 2019 New Features course is designed to equip you with the skill to manage Microsoft Excel profoundly and effectively. This course will help you to be familiar with the user interface and be dominant in using excel features according to business needs.

Microsoft Excel is the leading spreadsheet program used across any small or large industries, and having its skills are a tremendous boost in career paths. The Microsoft Excel Course with 2019 New Features course covers every level of lessons from beginner to advanced. It covers every aspect of data management tasks from performing necessary calculations to applying conditional formatting, creating stunning charts, automating tasks, and collaborating on workbooks. The lessons include the new features, shortcuts, and tips that are available in the 2019 update. Microsoft Excel, when used correctly, can increase productivity and efficiency multiple times.

By the end of the course, you will be able to use Microsoft Excel’s rich and built-in formula tools to create large and competent spreadsheets for business, office, or personal use.

Course Curriculum

Module 01: Microsoft Excel 2019 New Features
	Introduction to Microsoft Excel 2019 New Features		00:07:00
	CONCAT		00:02:00
	IFS		00:01:00
	MAXIFS		00:01:00
	MINIFS		00:01:00
	SWITCH		00:02:00
	TEXTJOIN		00:01:00
	Map Chart		00:02:00
	Funnel Chart		00:01:00
	Better Visuals		00:06:00
	Pivot Table Enhancements		00:02:00
	Power Pivot Updates		00:01:00
Module 02: Getting Started with Microsoft Office Excel 2016
	Navigate the Excel User Interface		00:28:00
	Use Excel Commands		00:10:00
	Create and Save a Basic Workbook		00:19:00
	Enter Cell Data		00:12:00
	Use Excel Help		00:05:00
Module 03: Performing Calculations
	Create Worksheet Formulas		00:15:00
	Insert Functions		00:17:00
	Reuse Formulas and Functions		00:17:00
Module 04: Modifying a Worksheet
	Insert, Delete, and Adjust Cells, Columns, and Rows		00:10:00
	Search for and Replace Data		00:09:00
	Use Proofing and Research Tools		00:07:00
Module 05: Formatting a Worksheet
	Apply Text Formats		00:16:00
	Apply Number Format		00:08:00
	Align Cell Contents		00:09:00
	Apply Styles and Themes		00:12:00
	Apply Basic Conditional Formatting		00:11:00
	Create and Use Templates		00:08:00
Module 06: Printing Workbooks
	Preview and Print a Workbook		00:10:00
	Set Up the Page Layout		00:09:00
	Configure Headers and Footers		00:07:00
Module 07: Managing Workbooks
	Manage Worksheets		00:05:00
	Manage Workbook and Worksheet Views		00:07:00
	Manage Workbook Properties		00:06:00
Module 08: Working with Functions
	Work with Ranges	FREE	00:18:00
	Use Specialized Functions		00:12:00
	Work with Logical Functions		00:24:00
	Work with Date & Time Functions		00:08:00
	Work with Text Functions		00:11:00
Module 09: Working with Lists
	Sort Data		00:10:00
	Filter Data		00:10:00
	Query Data with Database Functions		00:09:00
	Outline and Subtotal Data		00:09:00
Module 10: Analyzing Data
	Create and Modify Tables		00:16:00
	Apply Intermediate Conditional Formatting		00:07:00
	Apply Advanced Conditional Formatting		00:06:00
Module 11: Visualizing Data with Charts
	Create Charts		00:13:00
	Modify and Format Charts		00:12:00
	Use Advanced Chart Features		00:12:00
Module 12: Using PivotTables and PivotCharts
	Create a PivotTable		00:13:00
	Analyze PivotTable Data		00:12:00
	Present Data with PivotCharts		00:08:00
	Filter Data by Using Timelines and Slicers		00:11:00
Module 13: Working with Multiple Worksheets and Workbooks
	Use Links and External References		00:12:00
	Use 3-D References		00:06:00
	Consolidate Data		00:06:00
Module 14: Using Lookup Functions and Formula Auditing
	Use Lookup Functions		00:13:00
	Trace Cells		00:09:00
	Watch and Evaluate Formulas		00:09:00
Module 15: Sharing and Protecting Workbooks
	Collaborate on a Workbook		00:20:00
	Protect Worksheets and Workbooks		00:08:00
Module 16: Automating Workbook Functionality
	Apply Data Validation		00:13:00
	Search for Invalid Data and Formulas with Errors		00:04:00
	Work with Macros		00:18:00
Module 17: Creating Spark lines and Mapping Data
	Create Sparklines		00:07:00
	MapData		00:07:00
Module 18: Forecasting Data
	Determine Potential Outcomes Using Data Tables		00:09:00
	Determine Potential Outcomes Using Scenarios		00:09:00
	Use the Goal Seek Feature		00:04:00
	Forecasting Data Trends		00:06:00

Don't just take our word for it

Amazing workshop. Very informative for the freshers like me. Learned a lot of things about digital marketing. I'm really thankful.

Aarini Sinha

It was a great experience. The course was jampacked with excellent information. And when I needed help, Skill-up helped me with technical problems instantly. Fast feedback.

Varsha Sivamohan

I am currently signed on to several courses with skill up. I have just finished my second one. The courses are informative and good for all types of learners. I recommend them.

Judith Taylor

The support team was FANTASTIC!!! Very quick to respond and even though I was nervous as I am not good at tests, they made me feel comfortable. I am very grateful for the support

Charlie Anderson

Completed the Level 3 Mental Health Support Worker course, very good and highly recommend it. Very good course, enjoyed it thoroughly and important in my line of work as a Support worker.

Parmjit Dosanjh

I am pleased to have completed my online course in Mental Health First Aid with SkillUp. All the modules were detailed & comprehensive with review questions, which really helped me to grasp the information & prepared me well for the mock test & final exam.

Shan

I was a bit nervous about the course but I gave a try,it's perfect and I still can't believe I paid a peanut to acquire such a course,the sliding show and introduction was well understood.i will recommend skill up to anyone interested to persuade a meaningful career,and also to the support team keep doing the good work.💪

Sara Nana