You gain here the basic knowledge such as Navigate & Rename, Cells Borders, Build Formulas, Formatting Texts, Filter Ranges, Enter Numbers, Ranges Names, Show or Hide Headings, Subtotals, enter date and time, insert a row & a column, Extract information from a date, Creating workbooks and worksheets, Creating a basic chart, Create & move, Font layout & styles, Copy & delete operations ranges, Change view of the Excel Window, Insert a symbol etc. and Learn excel online from the beginning.
With Excel Mooc you learn to create a simple as well as multi page user form, select cells by value in Microsoft Excel, manage Databases in Excel, Excel VBA for Beginners to clean a dataset, calculate a loan payment, present and future value, prepare dependent data validation lists, list of reminders and future tasks, waterfall charts, use navigation tools, show negatives in a chart in a different color, Quick access toolbar, use the counting functions, create target lines charts, Rounding, edit and delete data, convert time to seconds, concatenate functions, goal seek, consolidate data, highlight with weighted average, add hours, multiple conditions, modify worksheet colors, change chart type, create a chart, worksheet layout, chart elements and types, use Excel galleries, delete data in a range, chart elements outline, use a range name in a formula, add comments to an excel workbook, a function to a formula, convert ranges to a table, move or copy a formula, learn Microsoft Excel window and ribbon, format fonts, arrange Windows, merge cells, transpose columns, hide and freeze rows & columns and much more advanced aspects.
You also understand and learn many functions like IMSUB, IMSQRT, IMSIN, IMREAL, INDIRECT, OFFSET, MATCH, CHOOSE, BETADIST, VLOOKUP, TRANSPOSE, RTD, ROW, LOOKUP, INDEX, HYPERLINK, HLOOKUP, CHOOSE, AREAS, ADDRESS, TRUE, OR, NOT, IF, FALSE, AND, TYPE, ISTEXT, ISREF, ISODD, ISNUMBER, ISNONTEXT, ISNA, ISLOGICAL, ISEVEN, ISERROR, ISERR, ISBLANK, INFO, ERROR, TYPE, CELL, OCT2HEX, OCT2DEC, OCT2BIN, IMSUM, IMPRODUCT, IMPOWER, IMLOG2, IMLOG10, IMLN, IMEXP, IMDIV, IMCOS, IMCONJUGATE, IMARGUMENT, IMAGINARY, IMABS, HEX2OCT, HEX2DEC, HEX2BIN, GESTEP, ERFC, ERF, DELTA, DEC2OCT, DEC2HEX, DEC2BIN, CONVERT, COMPLEX, BIN2OCT, BIN2HEX, BIN2DEC, BESSELY, BESSELK, BESSELJ, BESSELI, DVARP, DVAR, DSUM, DSTDEVP, DSTDEV, DPRODUCT, DMIN, DMAX, DGET, DCOUNT, DAVERAGE, TRUNC, Range, PMT, TANH, TAN and a lot of others.
gamechangershow
origamiaround
amandla
theartofmadeline