{"id":8003,"date":"2017-07-26T22:24:37","date_gmt":"2017-07-27T03:24:37","guid":{"rendered":"https:\/\/kaceli.com\/a\/?page_id=8003"},"modified":"2019-01-19T13:32:50","modified_gmt":"2019-01-19T18:32:50","slug":"excel-for-the-workplace-advance-in-your-career","status":"publish","type":"page","link":"https:\/\/kaceli.com\/a\/excel-for-the-workplace-advance-in-your-career\/","title":{"rendered":"Excel for the Workplace &#8211; Advance in your Career"},"content":{"rendered":"<h3><b><\/b><b><a href=\"https:\/\/kaceli.com\/a\/wp-content\/uploads\/2019\/01\/excel-2016.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-medium wp-image-8600 alignleft\" src=\"https:\/\/kaceli.com\/a\/wp-content\/uploads\/2019\/01\/excel-2016-300x169.jpg\" alt=\"\" width=\"300\" height=\"169\" \/><\/a>Excel for the Workplace &#8211; Advance in your Career<\/b><\/h3>\n<p>A self-paced course on using Microsoft Excel in the workplace.<\/p>\n<h3><b>What you will learn:<\/b><\/h3>\n<ul>\n<li>Master Microsoft Excel from Beginner level to Intermediate level.<\/li>\n<li>Learn the most commonly used Excel functions in today&#8217;s business environment.<\/li>\n<li>Master unique tips and concepts that you won&#8217;t find in other courses.<\/li>\n<li>Build a solid understanding of the basics of Microsoft Excel to increase your proficiency at work.<\/li>\n<li>Create dynamic charts and data analysis using IF, VLOOKUP, and PivotTables.<\/li>\n<li>Access\u00a0 to a Professional Trainer with 15+ years of Excel and IT experience.<\/li>\n<li>Get lifetime access to the quizzes, exercises and new updates.<\/li>\n<\/ul>\n<h3 class=\"requirements__title\"><b>Requirements<\/b><\/h3>\n<div class=\"requirements__content\">\n<ul class=\"requirements__list\">\n<li class=\"requirements__item\">Install Microsoft Office: Excel 2016, 2013 or 2010. The course is designed using Excel 2016.<\/li>\n<li class=\"requirements__item\">No previous knowledge is required!<\/li>\n<li class=\"requirements__item\">Great for students or employees who want to learn at their own pace<\/li>\n<\/ul>\n<h3><b>Certificate<\/b><\/h3>\n<p>A Verifiable Certificate of Completion is presented to all students who request it upon completion of this course.<\/p>\n<\/div>\n<h3><b>Application<\/b><\/h3>\n<p>This course is suitable for individuals without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used the business environment.<\/p>\n<p>This course is perfect employee training for small and midsize businesses and for individuals such as\u00a0 students, entry-level finance, Business and Marketing professionals who would like to grow faster than their peers.<\/p>\n<ul>\n<li>Executive Assistant<\/li>\n<li>Office Clerk<\/li>\n<li>Auditor<\/li>\n<li>Accountant<\/li>\n<li>Business Analyst<\/li>\n<li>Financial Analyst<\/li>\n<li>Credit Counselor<\/li>\n<li>Sales Representative<\/li>\n<li>Sales Manager<\/li>\n<li>Financial Manager<\/li>\n<li>Investment Banker<\/li>\n<li>Real Estate Agent<\/li>\n<li>Market Research Analyst<\/li>\n<li>Financial Advisor<\/li>\n<li>Business Operations Manager<\/li>\n<li>Entrepreneur<\/li>\n<li>Someone who is involved with a business and would like to be successful<\/li>\n<li>Students<\/li>\n<\/ul>\n<p><strong><em>Please don\u2019t forget that the course comes with an unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?<\/em><\/strong><\/p>\n<h3><b>Unit Sections and Objectives <\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Lesson 1: Getting Started with Excel &#8211; General Concepts<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Getting started with Excel<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">General interface<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The Office Ribbon<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">General concepts on using Excel and Spreadsheets<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 2: Calculating the SUM, AVERAGE etc. in Excel <\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to use Excel basic features<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to enter a formula in Excel<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to calculate the sum of a series of cells<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to calculate the average of a series of cells<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to calculate the Max of a series of cells<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to calculate the Min of a series of cells<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to calculate the count function in a series of cells<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to use the Autofill feature in Excel<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 3: Basic Formulas: Multiplying, Division and Subtraction in Excel<\/span><span style=\"font-weight: 400;\"> \u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Basic arithmetic functions in Excel \u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Subtraction<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Multiplying<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Dividing using formulas<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 4: Absolute, Relative and Mixed References<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How and when to use different types of references in formulas in Excel. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Difference between absolute and relative references<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Mixed references<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 5: Using Conditional Formatting and Data Analysis in Excel<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to apply formatting styles to the data in a spreadsheet. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to apply conditional formatting to selected data<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to use Data Analysis in Excel<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 6: Data Sorting and Filtering in Excel<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to sort data in Excel<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to filter data based on various criteria<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to customize the filters<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to clear the filters<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to use sorting and filtering by right clicking<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">L<\/span><span style=\"font-weight: 400;\">esson 7: Calculating Percentages in Excel<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to calculate percentages using a formula in Excel <\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 8: Creating and Customizing Charts in Excel<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to create various types of charts in Excel <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to customize the charts<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Which types of charts to use for certain types of data<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 9: Cross-Sheet Calculations in Excel<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to use formulas to perform cross-sheet calculations in Excel <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to enter the value from a formula in a previous sheet in a new worksheet.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 10: Using the IF Function in Excel<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to use the IF Statement or function in a variety of ways in Excel 2013 via a formula<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 11: Using Named References in Excel<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to define Named References in Excel. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to apply Named References and how to use this important feature in Excel.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 12: Using Data Validation and Dropdown Lists in Excel<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How and why use data validation in Excel<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to define data validation rules and criteria. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to apply data validation lists and drop-down lists<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 13: Using Pivot Tables in Excel<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to setup the data to use it with Pivot Tables. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to create pivot tables in Excel<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to customize the pivot tables using various criteria.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 14: Setting the Print Area in Excel<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Setting and clearing the print area. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Headers and footers<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 15: Linking Data from Excel with Word for Reports<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to link data from Excel into Word for reports etc. using Paste Special. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Update the data in your Excel spreadsheet and have that data updated automatically in Word.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 16: Importing and Exporting Data in .csv Files in Excel to Transfer Data Between Systems<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Understanding .csv files and their usage. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to import .csv files in Excel<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to export an Excel file to .csv format. <\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 17: Sharing and Saving Data in PDF Format<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to share data files in Excel.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to export data in PDF format directly from Excel<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lesson 18: Creating a Mail Merge using Excel<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to perform a mail merge using an Excel Data File<\/span><\/li>\n<\/ul>\n<p>Lesson 19: Using VLOOKUP in Excel with 5 examples<\/p>\n<p>&nbsp;<\/p>\n<h3><b>Questions<\/b>?<\/h3>\n<p>See also these <a href=\"https:\/\/kaceli.com\/a\/faqs\">FAQs<\/a>.<\/p>\n<h3>Ready to sign up?<\/h3>\n<p>Click <a href=\"https:\/\/kaceli.com\/a\/courses\/excel-for-the-workplace-advance-in-your-career\/\">here<\/a>.<\/p>\n<h3><b>Bulk Enrollments\/Licensing<\/b><\/h3>\n<p><font color=\"#FF0000\">If you are a business owner and would like bulk enrollments\/licensing, please contact us. Bulk discounts are available.\u00a0<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel for the Workplace &#8211; Advance in your Career A self-paced course on using Microsoft Excel in the workplace. What you will learn: Master Microsoft Excel from Beginner level to Intermediate level. Learn the most commonly used Excel functions in today&#8217;s business environment. Master unique tips and concepts that you won&#8217;t find in other courses. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_eb_attr":"","footnotes":""},"class_list":["post-8003","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/pages\/8003","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/comments?post=8003"}],"version-history":[{"count":0,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/pages\/8003\/revisions"}],"wp:attachment":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/media?parent=8003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}