Complete MS Office and Web Design Development Course

Explore Excel basics, including formatting, organizing, and calculating data in a spreadsheet, and learn the interface, workbook concepts, pivot tables, and essential tools.

Learn to open a new blank workbook, navigate the file and home tabs, understand tabs and ribbons, and explore templates, recent and pinned workbooks, and OneDrive integration.

Learn to save data in Excel with quick save, Ctrl+S, and Save. Save as lets you export formats like PDF, XPS, or Excel 2003 to PC or OneDrive.

Learn to identify and fix common Microsoft Excel errors, including division by zero, number, value, n/a, reference, name, null, and hash errors, with practical solutions.

Master the core logical functions in Microsoft Excel, including and, or, not, exclusive or, and switch, using true/false outcomes, cell references, and practical examples for streamlined worksheet logic.

Master cell references in excel, including relative and absolute references and anchoring with F4, then explore the rho function and compare the R function with exclusive or for logical tests.

Learn to use the if function in Microsoft Excel to perform logical tests and return true or false, with practical examples and guidance on ifs for multiple conditions.

Learn how to filter and sort data in Microsoft Excel using the filter function, selecting headers and categories to display, print, and focus on the items you need.

Learn how to convert numbers into words in Excel using the currency to English function, including enabling developer mode, handling version differences, and applying to data ranges.

Explore page layout settings in Excel, including margins, orientation, and page size, and learn to set print area, apply breaks, and adjust scale to fit.

Master printing in spreadsheets by setting up pages, selecting print areas, adjusting margins, headers and footers, and choosing active sheets, entire workbook, orientation, scaling, and copies.

Master sharing and collab in Excel to work with remote teammates by staying connected to a Microsoft account and Internet, saving to cloud, and assigning editor or viewer roles.

Explore the basics of Microsoft PowerPoint, a slideshow presentation tool in the Microsoft Office suite, and learn to create slides, use templates and themes, and collaborate in real time.

Learn to add and organize slides in PowerPoint, select from nine types of slides, use Ctrl+M, duplicate slides, and manage content with sections and reset.

Learn to format fonts in Word and PowerPoint, selecting text, changing font and size, adjusting case and spacing, applying bold, italic, underline, shading, colors, and clearing formatting.

Master drawing in PowerPoint by creating blank slides, adding text boxes and shapes, arranging and grouping elements, and applying quick styles, fill, outlines, gradients, texture, and shape effects.

Learn to insert and customize tables in PowerPoint, including draw and insert table and Excel spreadsheet options, and add and edit images from device, stock, or online pictures.

Learn to enhance presentations with shapes, icons, three-dimensional models, and smart art, then create and format charts and diagrams using fills, textures, gradients, and text options.

Explore add-ins for PowerPoint, a type of extension you can download from the office store to enhance your presentation with graphics, emoji keyboard, draw.io, and more.

Master zoom features and links in PowerPoint, including section and summary zoom, hyperlinks, and actions, to create interactive slides with comments and email or file links.

Master adding and formatting text, symbols, and media in PowerPoint, including text boxes, headers and footers, word art, date and time, slide numbers, equations, and video, audio, and screen recordings.

Explore design tab options to apply themes and variants, customize content from office.com or your files, then adjust slide size and orientation and format background with solid fill or gradient.

Master adding transitions and animations to slides, including morph and advanced morph, adjusting timing, effect options, and previewing changes for smooth, engaging presentations.

Master the slideshow and view tab to configure slide size, custom slideshows, timings and narrations, manage monitor setup, and switch between presentation views and masters.

Learn to start an HTML project by creating an index.html, converting text to HTML, and using Visual Studio Code with Live Server to edit head, title, and basic tags.

Explore how to structure content with the HTML body tag, heading tags (h1–h6), and the paragraph tag, and preview results in a live server using Visual Studio Code.

Learn to create hyperlinks in HTML and CSS with href attributes, link pages and external sites, open in new tabs with target blank, and implement bookmarking using ids.

Create a basic HTML table using table, tr, and td with a 1px solid black border. Set the table width to 50% and populate rows with name, address, and email.

Learn to embed another website with the iframe tag in HTML and tune its size on a live server. Discover adding symbols like copyright and heart using HTML entities.

Learn practical HTML and CSS styling to color text and backgrounds, adjust font sizes and styles, and apply font families using Visual Studio Code and a live server.

Explore css, the cascading style sheets language that styles web pages and controls how html elements display across devices, including inline, internal, and external stylesheets.

Explore how to apply color and background styles to headings and paragraphs in CSS, using selectors for h1, ids, and classes to control individual elements.

Learn to apply and customize backgrounds in CSS, switching between background color and image, adjusting background size and position, using div wrappers for selective styling, and tweaking opacity.

Explore four CSS border styles—dotted, double, solid, and inset—by applying class selectors in style.css, linking to HTML, and adjusting width, height, and color to see live changes.

Learn how to apply CSS padding to a div or class by setting padding top, bottom, left, and right, and observe the heading's spacing alongside a 50% opacity effect.

Learn to align text using CSS with center, left, and default right options, and adjust spacing through line height, word spacing, and letter spacing using classes.

Modify and style hyperlinks using CSS to enhance link display, colors, and hover effects. Learn to apply stylesheet rules to the a tag, including color, visited states, and hover interactions.

Learn to navigate WordPress functions, including posts, categories, tags, media, pages, comments, appearance and themes, and master site settings, permalinks, privacy, and basic tools.

Learn how to add media to a WordPress post by selecting images from the media library or uploading files, set alignment, optional link, and insert and update the post.

Learn to apply bold, italic, and bold plus italic formatting in WordPress posts. Explore creating bullet and numbered lists, using block quotes, aligning text, inserting and updating hyperlinks, applying strikethrough.

Learn to manage website comments via the dashboard: approve or edit comments, trash unwanted ones, and test the user experience in a private/incognito window.

Learn to customize a WordPress blog with live preview, adjusting site identity, colors, header and background images, logo options, and publish changes.

Explore WordPress headings from heading one to heading six, adjusting size via the paragraph settings, and compare visual editing with coding in a simple, practical workflow.

Learn how to create and organize pages in WordPress, publish content with dummy text like lorem ipsum, set parent and subpages, and use plugins to build menus and categories.

Learn to post on WordPress by installing and activating the classic editor plugin, then create, save, and publish a new blog post from the dashboard.

Discover the essential requirements to start building a WordPress website, including offline setup with Zamp software or online paid hosting and domain options.