
Discover how Microsoft Excel functions as a spreadsheet program for formatting, organizing, and calculating data, using cells to create formulas and visualize results with charts, histograms, and line graphs.
Explore how Excel organizes data and performs financial analysis across all business functions, from daily budgets to yearly reports, and supports dashboards, add-ons, and VBA tools.
Discover how to leverage the Microsoft Excel marketplace to find freelance work on platforms like Fiverr and Upwork, apply spreadsheet formulas, and turn Excel knowledge into revenue.
Discover how to create and customize charts and graphs in Microsoft Excel to visualize numeric data, highlight relationships and trends, and choose from ten chart types for clear presentations.
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 how to use Excel's find and replace to search for data and update multiple cells at once, with steps to access and apply replace across your sheet.
Column & Row Cells Insert, Delete, Hide, Unhide, Merge
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.
Learn to save and print your Excel workbooks, including choosing a location and file name, using the save button, and setting the print area, preview, copies, orientation, and paper size.
Explore relative, absolute, and mixed cell references in Excel to create robust and flexible spreadsheets.
Master basic filtering in Excel to quickly display relevant data using the filter button, dropdown headers, and multiple criteria for cameras, laptops, and projectors.
Master Excel advanced filtering to extract data from large datasets using complex criteria, criteria ranges, and copy to another location, boosting data analysis and reporting efficiency.
Learn how to sort data in Excel, including ascending and descending orders, using headers, and sorting by columns such as ID number, types, and equipment details to organize datasets quickly.
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 pie chart in Excel, showing percentage and actual data, in 2D or 3D with color customization. Select your data to build the chart accurately.
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 and customize area charts in Excel, including data selection, style choices, filters, color adjustments, and 3D options for visualizing covered areas.
Create and customize water charts in Excel to visualize progress bars, highlighting increases in green and decreases in red with monthly 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.
Parse data in Excel using various text functions to parse, extract, split, and join information, including left and right, text to columns, delimited data, and flash fill techniques.
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.
Create a pivot table in Excel by selecting data, inserting a pivot table, and arranging fields for rows, columns, values, and filters to analyze sales data.
Explore pivot tables and master filter techniques to analyze data, drag fields into the filters area, and filter by month, reason, or salesperson for targeted insights.
Explore pivot tables and slicers in Excel to analyze and filter data, insert pivots on a worksheet, and use slicers to filter by region and month.
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.
Automate repetitive Excel tasks by recording macros after enabling the developer tab. Name macros, assign shortcuts, and record actions to format tables with bold colors, then edit in VBA editor.
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 create a dropdown list in Excel using data validation and then apply filters to display specific items, including hiding unnecessary cells for clearer results.
Master VLOOKUP with exact match in Excel to retrieve product code, stock, and price from a product list, using data validation to create the source list.
Learn how to use vlookup with trim in Excel to handle spaces in data, apply exact match and fixed table references, and retrieve prices across tables.
Learn to use vlookup approximate match to map sales values to incentive rates with a vertical lookup and a table array and determine incentives via lookup value and column index.
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 use hlookup, a horizontal lookup, to retrieve product code, stock, and price from a table by selecting the lookup value, table array, and row index with exact match.
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.
Are you ready to unlock the full potential of Microsoft Excel?
Unlock the full potential of Microsoft Excel with our comprehensive course, "Excel - Microsoft Excel Course Beginner to Expert." Whether you're a beginner seeking to build a solid foundation or an intermediate user aiming to enhance your skills, this course is designed to empower you with the knowledge and expertise needed to excel in the world of spreadsheets and data analysis.
Course Highlights:
· Excel Fundamentals: Start with the essentials. Learn to navigate the Excel interface, create, format, and organize spreadsheets, and efficiently input and manage data.
· Advanced Functions: Dive deep into Excels powerful functions and formulas. Explore logical, statistical, and financial functions, and discover how to use them for complex calculations and data manipulation.
· Data Visualization: Master Excels charting tools to create visually compelling and informative graphs and charts. Transform raw data into meaningful insights.
· Data Analysis: Develop your data analysis skills. Explore Pivot Tables and Pivot Charts to summarize and visualize large datasets. Learn sorting, filtering, and data validation techniques.
· Advanced Data Management: Discover advanced data management techniques, including creating dynamic tables, using What-If analysis tools, and automating tasks with macros.
· Data Import and Export: Seamlessly import data from external sources and export Excel files in various formats. Learn to collaborate with other Microsoft Office applications.
· Data Security: Understand how to protect sensitive information with Excels security features, including password protection and encryption.
· Tips: Discover time-saving tips and keyboard shortcuts that will boost your productivity and efficiency when working with Excel.
· Certification: Upon course completion, receive a certificate of achievement to showcase your Excel proficiency.
Who Should Enroll:
This course caters to individuals from various backgrounds, including:
· Professionals looking to enhance their data analysis and reporting skills.
· Students seeking to gain a competitive edge in the job market.
· Entrepreneurs and small business owners aiming to streamline financial tracking and decision-making.
· Anyone interested in harnessing the power of Excel for personal or professional use.
First, you should watch promotional videos and watch the free preview lessons. I think they're going to give you a good idea of the quality of the course content, pace, and what to expect from taking the course. Apart from that, Udemy offers a 30-day money-back guarantee with no questions asked!
This Course includes:
Introduction
· What is Microsoft Excel
· Where Excel Is Used
· Microsoft Excel Marketplace
Microsoft Excel Fundamentals
· Microsoft Excel Startup Screen
· Creating & Save Document in Excel
· Font Styles and Size
· Data Handling Basics - Cut, Copy and Paste
· Text Wrapping and Alignment
· Dates and Times Formats
· Numbers Format
· Find and Replace
· Working With Rows and Columns
· Freezing Rows and Columns
· Working With Multiple Worksheets
· Saving and Printing
· Relative, Absolute, & Mixed Cell References
· Ribbon & Quick Access Toolbar
· Cell Borders and Merging
· Allow Text/Numbers Only in Excel
· Protect Ranges & Worksheets in Excel
· Save Multiple Excel Sheets in one PDF File
Filtering and Sorting Data
· Basic Filtering
· Advanced Filtering
· Data Sorting in Excel
Creating Charts In Excel
· Creating Charts
· Create A Bar In Bar Chart In Excel
· Progress Circle Chart in Excel
· Create Pie Chart
· Create Line Chart
· Create Column Chart
· Format Charts in Excel
· Area Chart in Excel
· Waterfall Charts in Excel
· Combination Charts In Excel
· Multi-Color Scatter Plot Chart in Excel
Import and Export Data
· Data from Text Files
· Import Data from Web to Excel
· Transpose Data in Excel
· Parse Data in Excel Using Various Functions
· Exporting Data to Text File
Pivot Tables
· Create a Pivot Table
· Pivot Tables Filtering
· Pivot Table Slice
· Pivot Table Grouping
· Advanced Pivot Table Techniques
Micro
· Create Macros in Excel
· Edit a Macro in Excel
· Create Macro Buttons in Excel
Essential Excel Functions & Formulas
· IF Formula
· AND Formula
· OR Formula
· SUM, SUMIF, SUMIFS Functions
· PERCENTAGE Functions
· TODAY Function
· NOW Functions
· CHOOSE Function
· AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS Functions
MATCH Formula
· ROUND, ROUNDUP, ROUNDDOWN Formulas
· COUNT, COUNTBLANK, COUNTIF, COUNTIFS Formulas
· UPPER, LOWER Formulas
Conclusion & Thank You
· Get Start Career in Excel
· Top Three Freelancing Jobs Website
I am sure you can do it! all you have to do is follow the lessons step-by-step!
Feel free to share any problem you are facing and i will be here to review it.
Note: Lectures are updated promptly following any modifications in Microsoft Excel.