
Discover how Microsoft Excel stores, organizes, and analyzes data using cells, rows, and columns; apply formulas, pivot tables, and macros to create charts and dashboards for financial or research analysis.
Explore excel file formats and extensions, comparing the old xls with the new xlsx introduced in 2007, and note cross-version compatibility.
Explore Excel navigation tabs from file handling and OneDrive access to home, insert, page layout, formula, data, review, and view tools, enabling efficient formatting, analysis, and collaboration.
Explore how contextual tabs appear only when an object is selected, providing object-specific commands for shapes like formatting, color, and size, with examples including rectangles, SmartArt, pivot tables, and slicers.
Activate the developer tab in Excel by going to file, options, customize the ribbon, and checking the developer box. Explore macros, recording macros, and add-ins as you enable this tab.
Customize the quick access toolbar in excel to access commands with one click, add or rearrange items such as undo, redo, and color fill, and save your configuration.
Open a blank workbook in Excel 2013 from the welcome screen or with the Ctrl shortcut, then explore templates on office.com and search for invoices or calendars.
Save your workbook frequently to prevent loss from crashes. Use the Quick Access Toolbar, Ctrl+S, or the File tab to save, and use Save As for new versions.
Open an existing workbook quickly using multiple methods, including browse from computer, recent workbooks, SkyDrive cloud, keyboard shortcut Ctrl+O, and the quick access toolbar.
Learn to navigate a workbook in Excel 2013 using arrow keys, scroll bars, and the mouse; move between cells by double-clicking, pressing enter, or tab.
Navigate a worksheet quickly with keyboard arrows for single-cell moves, use control plus arrows to reach the range ends, and employ page up and page down for rapid scrolling.
Navigate Excel 2013 workbooks with mouse, activate cells with a left click, double-click to edit, input data, move with the scroll wheel, and right-click for cut, copy, insert, and delete.
Navigate a worksheet in Excel 2013 with vertical and horizontal scroll bars, arrow buttons, and dragging to move by rows, columns, or pages, and know when to select a cell.
Add new worksheets with the plus button to the right of last tab or via insert sheet under home, and delete sheets by right-click or delete menu, noting no undo.
Learn how to rename worksheet tabs in Excel, apply tab colors, and follow naming rules to keep workbooks organized and easy to navigate.
Learn to rearrange worksheets within a workbook and move them between workbooks using drag-and-drop or the move or copy option. Open two workbooks to place sheets in the desired order.
copy worksheets within a workbook to duplicate sheets for experiments without altering the original data, by dragging the tab to a new location or using move or copy.
Hide and unhide worksheets to reduce workbook clutter while keeping data accessible for references, showing how monthly data can be hidden while the quarterly overview aggregates the monthly data.
Master how to view and compare multiple worksheets or workbooks on a single screen by using the view tab, arrange all, and tiling options like horizontal, vertical, and cascade.
Learn how to adjust column widths and row heights in Excel to improve readability, using drag, exact values, auto fit, and format options to prevent truncation.
Adjusting the font in a workbook enhances readability by selecting the desired font from the font dropdown on the Home tab, previewing options, and applying changes to rows or columns.
Set the default font type and size for new workbooks in Excel by opening File > Options > General, choosing the font from the dropdown, and restarting Excel.
Select the target cells, open the font size menu from the home tab, and choose or enter a new size with live preview and optional increase or decrease adjustments.
Select the target cells, open the font color menu on the Home tab, and apply red to change text color; repeat to set the cell background color.
Explore how to align cell contents in Excel, using vertical options (top, middle, bottom) and horizontal options (left, center, right) via the home tab.
Learn how to adjust cell content indentation in Excel using the increase and decrease indent buttons, or set a left indentation via the alignment options, including horizontal and vertical choices.
Adjust cell contents orientation in Excel by turning vertical text on or off and rotating text up to 90 degrees clockwise or counterclockwise.
Format cells to change appearance without altering values, applying currency, date, time, or percentage formats with a live preview and quick access on the Home tab.
Learn to create custom number formats in Excel by entering codes in the format cells dialog, enabling leading zeros for a five-digit display, decimals, and added text.
Give your Worksheets a more compelling style by adding some subtle borders around Cells Columns and Rows. In this video you will learn how to select cells and implement different boarder styles
Insert line breaks in a cell by pressing enter in plain text or by using a formula with CHAR(10), turn wrap text on and enable red text to display them.
Discover how to merge and center cells in Excel to create centered titles, using the Format Cells alignment options and the Merge and Center button.
Enter data by activating a cell, confirm with enter or the check mark, delete if needed, and edit by double-clicking, while noting text versus number alignment.
Learn to perform basic calculations in Excel using formulas to add cells together, using equal signs and cell references like A1 and B2, with real-time recalculation.
Master basic subtraction in Excel by building formulas with the equal sign, referencing cells such as A1 and A2, and validating results in the subtraction workbook.
Learn to multiply with Excel formulas using the equal sign and cell references like A1 and A2, with automatic recalculation when data changes and order doesn't matter.
Explore basic division in Excel by building division formulas across a data grid with cell references, the equals sign, and order of operations to achieve the intended result.
Discover the order of calculation in Excel and how brackets override precedence for mixed operators like multiplication and addition.
Explore how to select and create professional charts in Excel, including bar, pie, line, scatter, and bubble charts, and tailor design and colors to your data.
Learn to create a clustered column chart in Excel by selecting the right data and using the insert ribbon to visualize individual sales per person across products.
Learn to create a pie chart with a single data series by selecting data and inserting a two-dimensional or three-dimensional pie chart for regional turnover insights.
Create a two-series line chart in Excel showing distances from Paris and Mumbai to major cities using a simple data selection and the insert line chart option.
Master data entry with Excel's AutoFill by entering January in a cell, dragging the fill handle, and previewing the months from January to December.
Learn how to create and use a custom AutoFill list in Excel by entering names, importing the list, and using the fill handle to auto populate a column.
Learn how to use the sum function in Excel to total weekly values across a range, including nonconsecutive cells and combining multiple ranges or individual cells.
Learn how to use Excel's AutoSum feature to quickly sum ranges with automatic pre-selection, validate results, and extend sums across weekdays with auto fill.
Explain how the sumif function adds values in a range that meet a criteria. Specify the range, the criteria, and the optional sum range, using a sales example.
Use the average function to compute the arithmetic mean across a range, ignoring text, logical values, and empty cells, while easily copying the formula across weekdays with the drag method.
Use the max function to find the largest value in a data range, handling numbers, empty cells, logical values, and text numbers, including examples on sales by division.
Master the min function, the opposite of max, to find the smallest value in a data range and compute weekly division sales using the same dataset.
learn how the date function returns a serial number for a date formed from year, month, and day, while Excel's 1900/1904 date systems handle overflow and cross-month adjustments.
Explore how the TODAY function returns the current date, calculates date differences with plus or minus days, and updates on recalculation; apply to deadlines, invoices, and age calculations.
Learn how the datedif function calculates time intervals between start and end dates using unit types such as years, months, and days, with three required arguments and practical Excel examples.
Learn to use the now function to return the current date and time, format it as date/time, and add days or hours with simple arithmetic, noting recalculation with F9.
Extract time and date components in Excel using second, minute, hour, day, month, year functions; work with date time values and now function to compute current components.
Learn how the weekday function converts a date serial number into a weekday number and explore return type options, with practical examples using the 20th of September 2015.
Use the networkdays function to calculate work days between a start date and end date, with an optional holidays list to aid salary calculations, and excludes weekends by default.
With this Excel training course you will get a State of the Art introduction to Microsoft Excel 2013. Learning how to use Microsoft Excel has never been more important. No matter what job you have, creating good Excel spreadsheets is a requirement in most jobs, not a bonus. Everything becomes more data driven and creating functional Excel spreadsheet is required for this. This Microsoft Excel training course is here to help, even if you have never used Excel before. This Excel training is a comprehensive course which can be taken by beginners as well as advanced users.
This Excel Course takes a beginner with no prior Microsoft Excel knowledge as well as intermediate users from the basics of Microsoft Excel 2013 into deeper and more advanced functions of this powerful spreadsheet software. Based on the Microsoft Excel Version 2013 and 2010 you will be able to use the most important and frequently used functions for analyzing business and research data. This Excel Training Course is specifically designed for a practical use and illustrates all concepts with easy to follow examples and exercises that you can complete yourself in order to apply what you have learned in this excel course.
What will you learn in this Excel course?
You will learn to apply the best practices of analyzing and displaying data in an easy and understandable way. If you want to learn excel from the ground up and want to know all the functions that you will need 90% of the time then this Excel course is for you. With a clear explanation, many examples and the possibility to try out everything for yourself this Excel training course will accelerate your learning curve significantly.
If you are a more advanced user you can use this Excel training course as a reference guide. Because of its detailed structured you will be able to look up certain functions and refresh your memory on how to use them very quickly.
Once you have completed this Excel training course, you will be able to harness the power of Microsoft Excel and take boring data, analyze it properly and display it so that it is easily understandable.
All working files are included, allowing you to follow along throughout the lessons.