Excel - Microsoft Excel Course Beginner to Expert

Discover how the Microsoft Excel startup screen helps you work more efficiently by accessing recent files, pinning items, creating new workbooks from a template, and using account, feedback, and options.

Create a new blank workbook in Excel and save your document by using the file tab, choosing a desktop destination, naming the file, and saving as an Excel workbook.

Explore how to change font styles and adjust font sizes in Excel using home tab. Learn to select text, choose a font, and set sizes with increase and decrease options.

Master cut, copy, and paste in Microsoft Excel, using the clipboard and keyboard shortcuts like Ctrl+X, Ctrl+C, and Ctrl+V to move or duplicate text, files, or data and formulas.

Learn how to wrap long text within a cell using wrap text and adjust alignment in Excel, including center, left, right, top, middle, and bottom options.

Master how Excel stores dates as serial numbers and times as decimals, and format, import, and manipulate date and time data with short, long, and custom formats.

Explore number formats in Excel to display data clearly. Learn how to use general, currency, accounting, percentage, date, time, and custom formats through the number format menu.

Learn to freeze rows and columns in Excel to keep headers visible as you scroll, using the view tab and freeze panes to lock the top row or first column.

Discover how to work with multiple worksheets in Excel by creating and renaming sheets, navigating tabs, and moving or copying sheets between workbooks.

Master basic filtering in Excel to quickly display relevant data using the filter button, dropdown headers, and multiple criteria for cameras, laptops, and projectors.

Learn to create a bar chart in Excel with the insert menu, customize colors and elements, and copy it to a new worksheet for page view, including 3D options.

Build a data table with progress percentages and insert a donut chart to visualize a progress bar in Excel. Update percentages to see the progress bar change.

Learn to create a 2D line chart in Excel by selecting data, inserting the line chart, and adjusting design, colors, filters, and layout to analyze trends.

Learn to create a column chart in Excel via the insert menu, choosing 2D or 3D options, and customize the title and axes for sales data.

learn to create a combo chart in excel by selecting your data, choosing the combo chart option, and combining column and line charts to compare profit and loss over months.

Learn how to import and analyze data from text files in Excel, including CSV and TSV formats, and ensure well-structured data with headers, delimiters, and consistency.

Learn to import data from the web into Excel by copying a web page url, using the from web option, loading the table, and refreshing to keep the data updated.

Learn to transpose data in Excel by flipping rows to columns (or vice versa) using copy and paste special with the transpose option on a sample range like A1:E5.

Export data from Excel to a text file by selecting cells and saving as text or tab delimited via the file menu, and explore manual or VBA options.

Master pivot table grouping in Excel to analyze sales by region and month. Learn to group, ungroup, and name groups such as January–February.

Master advanced pivot table techniques in Excel to analyze data with a slicer, timeline, grouping, design options, and calculated fields for deeper data insights.

Learn how to edit macros in Excel by recording, running, and modifying VBA code using the Developer tab and the Visual Basic for Applications editor.

Discover how to create a macro button in Excel by recording macros, enabling the developer tab, inserting an ActiveX control, and assigning the macro to the button to automate tasks.

Explore how the if formula drives conditional statements in Excel, using a logical test to return values based on true or false outcomes, with a budget example.

Master the or function in Excel by understanding that it returns true if any argument is true and false if all are false. Apply or in formulas for logical conditions.

Learn to use the today function in Excel to automatically insert the current date, see it update, and use shortcuts like Ctrl+; on Windows or Command+; on Mac.

Learn to display the current date and time in Excel with the now function by typing now() and pressing enter. Discover Windows and Mac shortcuts to insert it quickly.

Learn how to use the CHOOSE function to map codes to colors and names in Excel, using index values to select colors and ratings.

Explore how to use the match formula in Excel to return a position from horizontal and vertical tables, using lookup value, lookup array, and exact match options.

Learn how to use round, round up, and round down formulas in Excel to round to two decimal numbers, convert to whole numbers, and manage decimal values.

Learn how to use the upper and lower functions in Excel to convert names and cities to uppercase. Create and apply formulas to transform text across your worksheet.

Create a dynamic dropdown in Excel using data validation and a source that updates automatically. Convert the list to a table with a header and reference it to keep the dropdown current.

Learn how to use Vlookup with the match function in Excel to retrieve a subject score and its position from a data table.

Learn to perform a horizontal lookup in Excel with hlookup and match to retrieve a student's marks by subject, mastering exact match and positioning.

Explore freelancing platforms like freelancer.com, upwork.com, and fiverr.com to secure hourly excel tasks, maintain spreadsheets, and build a career as an Excel freelancer.

Learn to launch a freelancing career in Excel by securing contracts on top freelancing websites, building experience and testimonials, and setting an hourly rate.