Microsoft Excel Course - Complete Course - Accredited

Employer
New Skills Academy
Location
Washington, DC
Posted
Jun 13, 2017
Closes
Jun 21, 2017
Function
Accountant, IT
Industry
Other
Hours
Full Time
Microsoft Excel - Full Course - Beginners , Intermediate & Advanced - Accredited - Bestselling Complete Excel Course We have combined our Microsoft Excel Beginners , Intermediate and Advanced Courses to make the most in-depth, bestselling value for money Complete Excel Course on the market and for Careerbuilder users we are offering this course for only $60!One of the most widely used programmes in the world for visualizing and analyzing data is Microsoft Excel. This software is used in almost every industry, not to mention for personal use in households around the world. Small business owners rely on Excel to track hours, finances, and invoices, and large corporations rely on Excel for data analysis, to visualise data, and innumerable other tasks.Whether you are brand new to the world of Excel, or you have training and knowledge of the software and looking to improve your skills, this series of courses can help. By the time you finish the beginner, intermediate and advanced courses, you, too, will be an expert in Excel.You can learn at your own pace, as there is no time limit nor deadline to complete the courses. You can also access these courses from any mobile device, including tablets, computers, and mobiles, as long as you have access to the internet.Since the lessons in this course are only a few minutes each, it makes it very convenient for one to stop and start when necessary. This helps to study when you have time, even if you have less than 10 minutes or 15 minutes.**Careerbuilder Special** Now $60, was $597 - 90% discount, enter code: CAREERBUILDER60 in the coupon box at checkout for the price to reduce to only $60What's included -MS Excel Beginners CourseThe MS Excel beginners course will give you a full overview of all of the most common features of Excel and how to use them.Some of the highlights of this course include: A basic overview of Excel Calculating sums, averages, and totals Counting cells Learning formulas, such as IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF Pivot tables Inserting, editing, and deleting comments Creating borders Wrapping text Merging cells Pasting, sorting, and converting columns to rows Creating graphs and charts Using hyperlinksThis beginners course is recommended for anyone who might use Excel at home or at work for uncomplicated reasons, such as tracking simple expenditures or for calculating sums or totals.MS Excel Intermediate CourseThe MS Excel Intermediate Course will take what you learnt in the beginners course and expand upon it. Additionally, this course will teach you more advanced concepts than those that were presented in the beginners course.Some of the highlights of the intermediate Excel course include the following: Learning more about intermediate Excel functions including ABS, SUMIF, HLOOKUP, VLOOKUP, COUNTIF, AVERAGEIF, AVERAGEIFS, and AVERAGEA Data validation with date, list, time, and numbers Functions such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN, and EXACT How to remove duplicates in Excel Creating random numbers Changing text case Adding passwords Sending emails from Excel Adding custom backgrounds How to auto fill data Adding special characters Changing border colour and themeBefore jumping into the MS Excel Intermediate course, one should have a good basic overview of the beginner Excel functions. Those with experience in Excel might feel as if they can skip the beginner course, but it is best to at least go through the course and review it before starting the intermediate curriculum.The curriculum in the intermediate course is designed for those who work with Excel in the workplace, and it is primarily for those who want to improve their skills with this program.MS Excel Advanced CourseThe MS Excel Advanced Course is the longest and the most intense of the three Excel courses presented here. However, if you have successfully passed the beginner and the intermediate courses, you should consider yourself fully prepared to begin the advanced course.Some of the concepts that you will learn in the MS Excel Advance Course include the following: VLOOKUP Advanced formula options and manipulations Other advanced functions including OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND Functions including CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE Colouring a column and row with a formula Highlighting a cell with a formula Functions including ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK Functions including DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM Calculating loan IPMT and EMI Functions including DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX Full explanation of the INDEX and MATCH functions, covering several modules Looking up data Selecting only cells containing comments Hiding formulasAs you can see, the information you will get from the MS Excel Advanced Course will fully prepare you for virtually any career path, including those that require advanced skills with this software. Though this course is the longest and most involved of the three, once you complete it, you will have the knowledge and skills that most can only dream of.**Careerbuilder Special** Now $60, was $597 - 90% discount, enter code: CAREERBUILDER60 in the coupon box at checkout for the price to reduce to only $60Beginners Course Modules/LessonsModule 1: Introduction to ExcelModule 2 : AddModule 3 : MultiplyModule 4 : Subtraction in ExcelModule 5 : DividingModule 6 : SortModule 7 : PercentageModule 8 : Running TotalsModule 9 : PrintModule 10 : Paste SpecialModule 11 : MergeModule 12 : FilterModule 13 : AverageModule 14 : AVERAGEIFModule 15: SUMIF FormulaModule 16: IF FormulaModule 17: VLOOKUPModule 18: HLOOKUPModule 19 : Countif FormulaModule 20 : CountBlankModule 21 : Counta FormulaModule 22 : Count FormulaModule 23 : ConcatenateModule 24 : TransposeModule 25: Date FormulaModule 26: Month FormulaModule 27: Pivot TablesModule 28: Pie ChartsModule 29: Doughnut ChartsModule 30: Line ChartsModule 31: Column ChartsModule 32: Bar ChartsModule 33: Number FormattingModule 34: Create BordersModule 35: Conditional FormattingModule 36: Comments FAQ'sIntermediate Course Modules/LessonsModule 1: SumProduct FormulaModule 2 : Data Validation With DateModule 3 : Data Validation with Whole NumbersModule 4 : Data Validation with List FeatureModule 5 : ABS FunctionModule 6 : CHAR FunctionModule 7 : CLEAN FunctionModule 8 : CODE FunctionModule 9 : EXACT FunctionModule 10 : AVERAGEA FunctionModule 11 : AVERAGEIFModule 12 : AVERAGEIFS FunctionModule 13 : CELL Function With 10 VariationsModule 14 : LARGE FunctionModule 15: MAX FunctionModule 16: MEDIAN FunctionModule 17: MIN FunctionModule 18: MODE FunctionModule 19 : N FunctionModule 20 : RANDBETWEEN Function (Insert Random Numbers)Module 21 : RANK FunctionModule 22 : Remove Duplicate ValuesModule 23 : ROUND Function Up/DownModule 24 : Add Custom Background ImageModule 25: Change Text To Lower CaseModule 26: Change Text To Upper CaseModule 27: Change Text To Proper CaseModule 28: Insert Special CharacterModule 29: Use Autofill : A Time Saving TrickModule 30: Treemap ChartModule 31: Sunburst ChartModule 32: Use TablesModule 33: Use TemplatesModule 34: Use ThemesAdvanced Course Modules/LessonsModule 1: Add a PasswordModule 2 : AND FunctionModule 3 : Auto Updating Drop-down ListsModule 4 : CEILING FormulaModule 5 : Charts that Update AutomaticallyModule 6 : CHOOSE FormulaModule 7 : Compare 2 Lists with VLOOKUP FunctionModule 8 : CORREL FunctionModule 9 : Create an Advanced CalculatorModule 10 : Create a Combo ChartModule 11 : Create a Custom TabModule 12 : Create a Pivot ChartModule 13 : Create Visual In-cell IndicatorsModule 14 : Create Visual In-cell Indicators with Icon SetsModule 15: Customise the Status BarModule 16: DATEDIF FunctionModule 17: DATEVALUE FunctionModule 18: DAVERAGE FunctionModule 19 : DCOUNT FunctionModule 20 : DCOUNTA FunctionModule 21 : Depreciation FormulaModule 22 : DGET FunctionModule 23 : DMAX FunctionModule 24 : DPRODUCTModule 25: DSUM FunctionModule 26: EDATE FunctionModule 27: EOMONTH FunctionModule 28: Find and ReplaceModule 29: FIND FunctionModule 30: INDEX FunctionModule 31: Index and Match FormulaModule 32: Indirect FormulaModule 33: Insert Serial Number AutomaticallyModule 34: IPMT FormulaModule 35: Isblank FormulaModule 36: Iserr FormulaModule 37: Islogial FormulaModule 38: Isnon Text FormulaModule 39: IsNumber FormulaModule 40: Isodd FormulaModule 41: Isolate First NameModule 42: ISTEXT FormulaModule 43: Left FormulaModule 44: Len FormulaModule 45: Match FormulaModule 46: Vlookup Multiple Results at OnceModule 47: OR FormulaModule 48: PMT FormulaModule 49: Replace FormulaModule 50: Select all Cells with CommentsModule 51: Sparkline Charts in ExcelModule 52: Straight Line DepreciationModule 53: StrikethroughModule 54: Sum of Years DepreciationModule 55: Timeline in Pivot TableModule 56: Vlookup with 2 CriteriaModule 57: Vlookup with DropDown ListModule 58: Vlookup with MaxModule 59: Vlookup with MinModule 60: Watch Window In Excel**Careerbuilder Special** Now $60, was $597 - 90% discount, enter code: CAREERBUILDER60 in the coupon box at checkout for the price to reduce to only $60**Careerbuilder Special** Now $60, was $597 - 90% discount, enter code: CAREERBUILDER60 in the coupon box at checkout for the price to reduce to only $60